JDBC的常用对象
1. DriverManager
2. Connection
3. PreparedStatement
4. Statement
5. public Connection getConnection()throws Exception{
return java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
}
6. JDBC的执行过程
7. JDBC的缺点
a. 冗余代码太多
b. 可扩展性差
1. DriverManager
2. Connection
3. PreparedStatement
4. Statement
5. public Connection getConnection()throws Exception{
return java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
}
6. JDBC的执行过程
Connection con=null;
PreparedStatement stmt=null;
try {
con=getConnection();
con.setAutoCommit(false);
if(customer.getName()==null)
throw new BusinessException("");
long customerId=getNextId(con,"CUSTOMERS");
stmt=con.prepareStatement("insert into CUSTOMERS(ID,NAME,AGE) values(?,?,?)");
stmt.setLong(1,customerId);
stmt.setString(2,customer.getName());
stmt.setInt(3,customer.getAge());
stmt.execute();
con.commit();
}
catch(Exception e){
e.printStackTrace();
try{
con.rollback();
}catch(SQLException sqlex){
sqlex.printStackTrace(System.out);
}
throw e;
}finally{
try{
stmt.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
7. JDBC的缺点
a. 冗余代码太多
b. 可扩展性差