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的执行过程
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. 可扩展性差