Java连接常见数据库代码

1.连接SQL server 2005数据库

public class JDBCConnection { /**

* DRIVER 数据库驱动 * URL 数据库地址

* USER_NAME 数据库⽤户名 * PASSWORD 数据库登录密码 */

private static final String DRIVER=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\";

private static final String URL=\"jdbc:sqlserver://localhost:1433;DatabaseName=LibraryManagement\"; private static final String USER_NAME=\"sa\"; private static final String PASSWORD=\"123456\"; private static Connection conn;

private static final ThreadLocal threadLocal = new ThreadLocal(); //通过静态代码块加载JDBC驱动

static { try{

Class.forName(DRIVER).newInstance(); }catch(ClassNotFoundException e) {

e.printStackTrace(); }

catch(Exception e) {

e.printStackTrace(); } } /**

* 功能：建⽴与数据库的连接 * @return Connection的实例

*@throws ClassNotFound,SQLException */

public static Connection getConnection() {

//从线程中获得数据库连接 conn=threadLocal.get(); if(conn==null) { try{

conn=DriverManager.getConnection(URL,USER_NAME,PASSWORD); //将数据库连接保存到线程中 threadLocal.set(conn); }catch(SQLException e) {

e.printStackTrace(); } }

return conn; } }

2.连接MySQL数据库

public Connection getConnection() throws ClassNotFoundException { String url = \"jdbc:mysql://localhost:3306/mesdb\"; String name = \"root\"; String passw = \"123456\";

Class.forName(\"com.mysql.jdbc.Driver\"); try {

Connection conn=DriverManager.getConnection(url,name,passw); return conn;

} catch (Exception e) { e.printStackTrace(); return null; } }

3.连接Oracle数据库

public OracleJDBC {

public Connection getConnection() throws ClassNotFoundException { String url = \"jdbc:oracle:thin:@192.168.102.243:1521:orcl\"; String name = \"training\"; String passw = \"123456\";

Class.forName(\"oracle.jdbc.driver.OracleDriver\"); try {

Connection conn =DriverManager.getConnection(url,name,passw); return conn;

} catch (Exception e) {

e.printStackTrace(); return null; } }