jdbc 胖连接_JDBC 使用db.properties 获取数据库连接

packagecn.itheima.jdbc.test;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importorg.junit.Test;importcn.itheima.jdbc.JDBCUtils_V1;importcn.itheima.jdbc.JDBCUtils_V2;importcn.itheima.jdbc.JDBCUtils_V3;/*** 测试工具类*/

public classTestUtils {/*** 根据id更新用户信息方法*/@Testpublic voidtestUpdateById() {

Connection conn= null;

PreparedStatement pstmt= null;try{//1.获取连接

conn =JDBCUtils_V3.getConnection();//2.编写sql语句

String sql = "update tbl_user set upassword=? where uid=?";//3.获取执行sql语句对象

pstmt =conn.prepareStatement(sql);//4.设置参数

pstmt.setString(1, "999");

pstmt.setInt(2, 3);//5.执行更新操作

int row =pstmt.executeUpdate();if (row > 0) {

System.out.println("更新成功!");

}else{

System.out.println("更新失败!");

}

}catch(Exception e) {throw newRuntimeException(e);

}finally{//6.释放资源

JDBCUtils_V3.release(conn, pstmt, null);

}

}/*** 根据id删除信息方法*/@Testpublic voidtestDeleteById() {

Connection conn= null;

PreparedStatement pstmt= null;try{//1.获取连接

conn =JDBCUtils_V3.getConnection();//2.编写sql语句

String sql = "delete from tbl_user where uid=?";//3.获取执行sql语句对象

pstmt =conn.prepareStatement(sql);//4.设置参数

pstmt.setInt(1, 4);//5.执行删除操作

int row =pstmt.executeUpdate();if (row > 0) {

System.out.println("删除成功!");

}else{

System.out.println("删除失败!");

}

}catch(Exception e) {throw newRuntimeException(e);

}finally{//6.释放资源

JDBCUtils_V3.release(conn, pstmt, null);

}

}/*** 添加用户信息方法*/@Testpublic voidtestAdd() {

Connection conn= null;

PreparedStatement pstmt= null;try{//1.获取连接

conn =JDBCUtils_V2.getConnection();//2.编写sql语句

String sql = "insert into tbl_user values(null,?,?)";//3.获取执行sql语句对象

pstmt =conn.prepareStatement(sql);//4.设置参数

pstmt.setString(1, "lisi");

pstmt.setString(2, "hehe");//5.执行插入操作

int row =pstmt.executeUpdate();if (row > 0) {

System.out.println("添加成功!");

}else{

System.out.println("添加失败!");

}

}catch(Exception e) {throw newRuntimeException(e);

}finally{//6.释放资源

JDBCUtils_V2.release(conn, pstmt, null);

}

}/*** 根据id查询用户信息*/@Testpublic voidtestFindUserById() {

Connection conn= null;

PreparedStatement pstmt= null;

ResultSet rs= null;try{//1.获取连接

conn =JDBCUtils_V1.getConnection();//2.编写sql语句

String sql = "select * from tbl_user where uid=?";//3.获取执行sql语句对象

pstmt =conn.prepareStatement(sql);//4.设置参数

pstmt.setInt(1, 2);//5.执行查询操作

rs =pstmt.executeQuery();//6.处理结果集

while(rs.next()) {

System.out.println(rs.getString(2) + "----" + rs.getString("upassword"));

}//释放资源放在此处行么？【不行滴！】

} catch(SQLException e) {

e.printStackTrace();

}finally{//7.释放资源

JDBCUtils_V1.release(conn, pstmt, rs);

}

}

}