1、SQLServer2000数据库连接
首先下载SQL Server2000的JDBC驱动程序,即三个jar包,名字依次是 :msbase.jar ,mssqlserver.jar ,msutil.jar
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driver);
String urlString = "jdbc:microsoft:sqlserver://"+ip+":1433;DatabaseName=";
dbconn = DriverManager.getConnection(urlString, user, pwd);
2 、Oracle8/8i/9i(thin模式)数据库连接
首先下载Oracle的JDBC驱动程序,即classes12.jar
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:orcl"; //orcl为数据库的SID
String user="test";
String password="test";
Connection conn= DriverManager.getConnection(url,user,password);
3、MySQL数据库连接
首先下载MySQL的JDBC驱动程序,即三个jar包mysql-connector-java-3.1.13-bin.jar
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/databaseName"; // URL指向要访问的数据库名databaseName
String user = "root";
String password = "root";
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);