UC知道java+sql server2000出现的问题？
来源：百度知道 编辑：UC知道 时间：2024/07/14 03:32:02
import java.sql.*;
public class lianjie
{ public static void main (String[] args) {
Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");}
catch(ClassNotFoundException e)
{System.out.print(""+e);}
try
{ con=DriverManager.getConnection("jdbc:lianjie1://WWW-7B0D2418F20;DatabaseName=lianjie","sa","sa");
sql=con.createStatement();
String x="数学系";
//int x=20;
rs=sql.executeQuery("select sno,sname,ssex from wuzi where sdept="+"'"+x+"'");
while(rs.next())
{ String a=rs.getString(1);
String b=rs.getString(2);
String c=rs.getString("Ssex");
String d=rs.getString(4);
System.out.print(a+"\t");
System.out.print(b+"
public class lianjie
{ public static void main (String[] args) {
Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");}
catch(ClassNotFoundException e)
{System.out.print(""+e);}
try
{ con=DriverManager.getConnection("jdbc:lianjie1://WWW-7B0D2418F20;DatabaseName=lianjie","sa","sa");
sql=con.createStatement();
String x="数学系";
//int x=20;
rs=sql.executeQuery("select sno,sname,ssex from wuzi where sdept="+"'"+x+"'");
while(rs.next())
{ String a=rs.getString(1);
String b=rs.getString(2);
String c=rs.getString("Ssex");
String d=rs.getString(4);
System.out.print(a+"\t");
System.out.print(b+"
错误显示:com.microsoft.jdbc.sqlserver.SQLServerDriver 这个类找不到..
所以是你的包没导入...
找找,把包导入就行了...
你有导入jdbc的jar包吗?
还有就是
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=lianjie","sa","sa");
一般都是这样写的