java连接mysql的代码_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;

}

}