1、我的sqlserver2005 TCP/IP 里的IP选项:ipall(最后一项)被设为1450;
2.、连接实例:
package test;
import java.sql.*;
public class DbOperation {
/**
* @param args
*/
private Connection con=null;
private Statement stmt=null;
private ResultSet rs=null;
public Connection getConn(){
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
try{
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1450;DatabaseName=javaweb","sa","sa");
}catch(SQLException e){
e.printStackTrace();
con=null;
}
return con;
}
public ResultSet getRS(String s){
con=getConn();
try{
stmt=con.createStatement();
rs=stmt.executeQuery(s);
}catch(SQLException e){
e.printStackTrace();
rs=null;
stmt=null;
}
return rs;
}
public static void main(String[] args) {
// TODO Auto-generated method stub
DbOperation db=new DbOperation();
Connection c=db.getConn();
if(c!=null){
System.out.print("CONN SUCC");
}
}
}