SQL SERVER,ORACLE,MYSQL数据库的直连的参
类别: JSP教程
//SQL_Server:
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String user = "sa";
String password = "";
//Oracle:
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:wanchao";
String user = "scott";
String password = "tiger";
//mysql
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/chinabank?useUnicode=true&characterEncoding=GBK";
String user="root";
String passeord="root";
Class.forName(driver);
con = DriverManager.getConnection(url,user,password);
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String user = "sa";
String password = "";
//Oracle:
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:wanchao";
String user = "scott";
String password = "tiger";
//mysql
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/chinabank?useUnicode=true&characterEncoding=GBK";
String user="root";
String passeord="root";
Class.forName(driver);
con = DriverManager.getConnection(url,user,password);
-= 资 源 教 程 =-
文 章 搜 索