我用的是JCreatot,在连接SQL SERVER2000 的时候总是不能成功,请求帮助!
import java.sql.*;
public class JDBCTest{
public static void main(String args[]){
String url="jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=company";
String user="sa";
String password="******";
String Is_1="select * from employee";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//加栽驱动程序
Connection con=DriverManager.getConnection(url,user,password);//建立连接
Statement stmt=con.createStatement();//执行SQL语句
ResultSet rs=stmt.executeQuery(Is_1);//得到结果
System.out.println("姓:");
System.out.println("名:");
System.out.println("年龄:");
System.out.println("地址:");
System.out.println("城市:");
while(rs.next()){
System.out.print(rs.getString(1)+"|");
System.out.print(rs.getString(2)+"|");
System.out.print(rs.getString(3)+"|");
System.out.print(rs.getString(4)+"|");
System.out.print(rs.getString(5));
}
rs.close();
stmt.close();
con.close();
}
catch(SQLException sqle){
System.err.println(1+sqle.toString());
}
catch(Exception e){
System.err.println(2+e.toString());
}
}
}
import java.sql.*;
public class JDBCTest{
public static void main(String args[]){
String url="jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=company";
String user="sa";
String password="******";
String Is_1="select * from employee";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//加栽驱动程序
Connection con=DriverManager.getConnection(url,user,password);//建立连接
Statement stmt=con.createStatement();//执行SQL语句
ResultSet rs=stmt.executeQuery(Is_1);//得到结果
System.out.println("姓:");
System.out.println("名:");
System.out.println("年龄:");
System.out.println("地址:");
System.out.println("城市:");
while(rs.next()){
System.out.print(rs.getString(1)+"|");
System.out.print(rs.getString(2)+"|");
System.out.print(rs.getString(3)+"|");
System.out.print(rs.getString(4)+"|");
System.out.print(rs.getString(5));
}
rs.close();
stmt.close();
con.close();
}
catch(SQLException sqle){
System.err.println(1+sqle.toString());
}
catch(Exception e){
System.err.println(2+e.toString());
}
}
}
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
//mydb为数据库
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
然后选中在jcreator中的configure选项的options-》jdk profiles->edit->add->
然后选中驱动所在的路径