JDBCUtils
创建JDBC步骤
1.加载并注册驱动 class.forNmae();
2.数据库连接 DriverManager.getConnection(url,username,password);
3.通过connection对象创建statement对象
创建方式:conn.createStament(); conn.prepareStament();
4.使用stament执行SQL语句
执行sql方法:Execute() 任何sql语句
excuteQuery() 查询语句,执行返回结果集Result对象
excuteUpdate() 非查询操作
5.执行ResultSet结果集 rs.next()
6.关闭连接,释放资源
相关代码:
public class JDBCUtils {
//创建连接对象
public static Connection getConnection() throws ClassNotFoundException, SQLException {
//1. 注册数据库的驱动
Class.forName(“com.mysql.jdbc.Driver”);
// 2.通过DriverManager获取数据库连接
String url = “jdbc:mysql://localhost:3306/jdbc”;
String username = “root”;
String password = “root”;
return DriverManager.getConnection(url, username, password);
}
//释放rs
public static void release(ResultSet rs) {
//释放rs
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
rs = null;
}
}
//释放statement
public static void release(Statement statement) {
//释放statement
if (statement != null) {
try {
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
statement = null;
}
}
//释放connection
public static void release(Connection connection) {
//释放connection
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
connection = null;
}
}
//释放statement 和connection
public static void release(Statement statement,Connection connection){
release(statement);
release(connection);
}
}
C3p0Utils
public class C3p0Utils {
private static DataSource ds;
static {
ds=new ComboPooledDataSource();
}
public static DataSource getDataSource(){
return ds;
}
}