谁能告诉我jbuilder9和SQL2000怎么连起来呢?上那找驱动啊?

Question

谁能告诉我jbuilder9和SQL2000怎么连起来呢?上那找驱动啊?

Answer 1

步骤如下：
一、下载SQLSERVER2000的jdbc驱动程序并安装。在微软站点就有这个驱动程序：http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/msdn-files/027/001/779/msdncompositedoc.xml&FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D38312%26area%3Dsearch%26ordinal%3D1%26redirect%3Dno
二、启动JBuilder6.0。打开Tools-->Enterprise Setup-->DataBase Drivers-->Add--> New，然后命名"Microsoft SqlServer JDBC Driver"，选择sqlserver2000--jdbc驱动的安装路径，加入三个jar文件（在安装目录的lib下面）。确定。三、新建project,然后在project的属性中，选择Paths-->Required Libraries，添加"Microsoft SqlServer JDBC Driver"。四、在程序上面添加：
import com.microsoft.*;  // 加载类库下面是我调试的一段代码，供参考：  void jButton1_actionPerformed(ActionEvent e) {
    try{
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=;DatabaseName=maxwell");
      Statement stmt=conn.createStatement();
      String sql="select * from employee";
      ResultSet rs = stmt.executeQuery(sql);
      while(rs.next())
      {
        JOptionPane.showMessageDialog(null,rs.getString("name"),"员工名称",JOptionPane.YES_OPTION+JOptionPane.INFORMATION_MESSAGE );
      }     }
    catch(Exception ex)
    {
      System.err.println(ex.getMessage());
    }
  }转贴

Answer 2

sqlserver的驱动到主都有搜一下
msbase.jar
mssqlserver.jar
msutil.jar
就这三个  把这三个文件放到你的工作下的web-inf下的lib里 ，
在项目中倒入这三个白就可以了，连接其他的数据库大同小异，又不太大的差别
//sql_data.java
/*
作成者:陈一男
作成日:2005/7/20
         （测试通过）
*/
package news;
import java.sql.*;
public class sql_data {
        String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        String url =
                "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=news";
        //news为你的数据库的
        String user = "sa";//用户名
        String password = "sa";//密码
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        public sql_data() {
                try {
                        Class.forName(sDBDriver);
                } catch (java.lang.ClassNotFoundException e) {
                        System.err.println("sql_data(): " + e.getMessage());
                }
        }
        public void executeInsert(String sql) {
                try {
                        //conn = DriverManager.getConnection(url,user,password);
                        conn = DriverManager.getConnection(url, user, password);
                        stmt = conn.createStatement();
                        stmt.executeUpdate(sql);
                        stmt.close();
                        conn.close();
                } catch (SQLException ex) {
                        System.err.println("sql_data.executeUpdate:" + ex.getMessage());
                }
        }
        public ResultSet executeQuery(String sql) {
                try {
                        conn = DriverManager.getConnection(url, user, password);
                        stmt =
                                conn.createStatement(
                                        ResultSet.TYPE_SCROLL_SENSITIVE,
                                        ResultSet.CONCUR_READ_ONLY);
                        rs = stmt.executeQuery(sql);
                } catch (SQLException ex) {
                        System.err.println("sql_data.executeQuery:" + ex.getMessage());
                }
                return rs;
        }
        public void executeUpdate(String sql) {
                try {
                        conn = DriverManager.getConnection(url, user, password);
                        stmt = conn.createStatement();
                        stmt.executeUpdate(sql);
                        stmt.close();
                        conn.close();
                } catch (SQLException ex) {
                        System.err.println("aq.executeQuery: " + ex.getMessage());
                }
        }
        public void executeDelete(String sql) {
                try {
                        conn = DriverManager.getConnection(url, user, password);
                        stmt = conn.createStatement();
                        stmt.executeUpdate(sql);
                        stmt.close();
                        conn.close();
                } catch (SQLException ex) {
                        System.err.println("sql_data.executeDelete:" + ex.getMessage());
                }
        }
        public void closeStmt() {
                try {
                        stmt.close();
                } catch (SQLException e) {
                        e.printStackTrace();
                }
        }        public void closeConn() {
                try {
                        conn.close();
                } catch (SQLException e) {
                        e.printStackTrace();
                }
        }
}