java jdbc for sql 2000 and mysql-优快云博客

本文提供了两个示例：一个是使用Java连接SQL Server 2000并从特定表中检索数据；另一个是通过Java连接MySQL数据库的方法，包括加载驱动、获取连接及关闭连接等关键步骤。

sql 2000

package sql;
import java.sql.*;
public class TestDB {
    public static void main(String[] args) throws SQLException {
        String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=a";
        String userName = "sa";
        String userPwd = "123";
        Connection dbConn = null;

            try {
    Class.forName(driverName);
             dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
             System.out.println("Connection Successful!");

   } catch (Exception e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }

Statement stmt= dbConn.createStatement();
ResultSet res=stmt.executeQuery("select * from a.dbo.system");
while (res.next()) {
  System.out.println(res.getString(1));

}

}
}
====================================

mysql

=============================================

public class DataBase {
    private String dbUrl ="jdbc:mysql://localhost:3306/test";//数据库
    private String dbUser="root";                              //用户名
    private String dbPwd="root";                            //密码

    public DataBase() {
        try {
            //加载数据库驱动程序
            Class.forName("org.gjt.mm.mysql.Driver");
        } catch (ClassNotFoundException exception) {
        exception.printStackTrace();
        }
    }
    //获取数据库连接
    public Connection getConnection(){
        Connection con = null;
        try {
          //建立数据库连接
          con = java.sql.DriverManager.getConnection(dbUrl, dbUser, dbPwd);
        } catch (SQLException exception) {
          exception.printStackTrace();
        }
        return con;
    }
    //关闭数据库连接
    public void closeConnection(Connection con){
        try{
            if(con!=null) con.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }
}