@Test
/**
*
*/
public void demo1(){
Connection conn = null;
PreparedStatement pstmt = null;
try{
// :
conn = JDBCUtils.getConnection();
// SQL :
String sql = "insert into user values (null,?,?,?,?)";
// SQL:
pstmt = conn.prepareStatement(sql);
// :
pstmt.setString(1, "eee");
pstmt.setString(2, "abc");
pstmt.setString(3, " ");
pstmt.setInt(4, 32);
// SQL
int num = pstmt.executeUpdate();
if(num > 0){
System.out.println(" !");
}
}catch(Exception e){
e.printStackTrace();
}finally{
JDBCUtils.release(pstmt, conn);
}
}