再贴一遍程序import java.sql.*;
class connect
{
public static void main(String[] args)
{
try{Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();String url="jdbc:microsoft:sqlserver://localhost:crt137;DatabaseName=dds";String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from hmjl"; ResultSet rs=stmt.executeQuery(sql);rs.close(); stmt.close(); conn.close(); }catch (Exception e) {
System.out.println(e.getMessage()); }}
}
class connect
{
public static void main(String[] args)
{
try{Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();String url="jdbc:microsoft:sqlserver://localhost:crt137;DatabaseName=dds";String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from hmjl"; ResultSet rs=stmt.executeQuery(sql);rs.close(); stmt.close(); conn.close(); }catch (Exception e) {
System.out.println(e.getMessage()); }}
}
拷贝放在tomcat\common\lib下
重新启动服务器String url="jdbc:microsoft:sqlserver://localhost:crt137;DatabaseName=dds";
-》
String
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dds";
拷贝放到服务器可以识别的地方(tomcat\common\lib)后
就不需要在classpath设置了
另外:1433是sqlserver默认的端口号