注册 登录
编程论坛 J2EE论坛

jsp连接SQL server2000怎么连接啊

lb382414013 发布于 2008-04-14 14:11, 872 次点击
给我写的详细点啊 ,我比较笨。哈哈 !!!
3 回复
#2
Ethip2008-04-14 18:34
回复 1# 的帖子
去我的Blog看看,有你要的!
#3
mszhou2008-04-17 14:44
桥连的
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("连接成功") ;
        }
    }
}
#4
guoxhvip2008-04-17 23:51
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master","sa","sqlpass");
需要sql server的三个jar
1