自己学习java的jdbc时写的一个关于数据库连接小程序,代码如下:
package whu.cs.util;
import java.sql.*;
public class DBConnUtil {
public static final String DB_Driver = "com.mysql.jdbc.Driver";
public static final String DB_Url = "jdbc:mysql://localhost:3306/studb";
public static final String DB_User = "root";
public static final String DB_Password = "1234";
//加载驱动
static {
try {
Class.forName(DB_Driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//获取连接
public static Connection getConnection() throws SQLException{
return DriverManager.getConnection(DB_Url, DB_User, DB_Password);
}
//关闭
public static void close(ResultSet rs,Statement stm,Connection conn){
try {
if(rs != null)
rs.close();
if(stm != null)
stm.close();
if(conn != null)
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
System.out.print(DBConnUtil.getConnection());
}
}