jsp连接SQL server2000怎么连接啊
给我写的详细点啊 ,我比较笨。哈哈 !!! 搜索更多相关主题的帖子:
SQL jsp
----------------解决方案--------------------------------------------------------
回复 1# 的帖子
去我的Blog看看,有你要的! ----------------解决方案--------------------------------------------------------
桥连的
package loginch13;
import java.sql.*;
public class ConBean {
public static Connection getConBean(){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver ") ;
} catch (ClassNotFoundException ex) {
}
try {
Connection conn = DriverManager.getConnection("jdbc:odbc:test");
return conn;
} catch (SQLException ex1) {
return null;
}
}
public static void main(String ars[]){
ConBean obj=new ConBean();
Connection conn=obj.getConBean();
if(conn!=null){
System.out.println("hello world");
}
}
}
直连的
package regist;
import java.sql.*;
public class DBConn {
public static Connection getCon(){
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (ClassNotFoundException ex) {
System.out.println("加载失败") ;
}
try {
return DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;", "sa", "");
} catch (SQLException ex1) {
return null;
}
}
public static void main(String args[]){
if(DBConn.getCon() !=null){
System.out.println("连接成功") ;
}
}
}
----------------解决方案--------------------------------------------------------
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master","sa","sqlpass");
需要sql server的三个jar
----------------解决方案--------------------------------------------------------