JDBC使用Statement,PreparedStatement,CallableStatement.实例

java操作数据库创建Statement,PreparedStatement,CallableStatement.
1.Statement

  
int max =0; 
String sql ="select max(subStr(no,10,10)) as max from INF_APPLY_RESULT";
Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(sql);
   while(rs.next()){
       max = rs.getInt(1));
   }
   rs.close();

2.PreparedStatement 预处理
  

String sql = "update  INF_APPLY_RESULT set status=? where no=?";
 PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, "2");
ps.setString(2,"yc09600000001");
int i = ps.executeUpdate(); 

3.CallableStatement 调用存储过程

   String sql = "{call power_proc(?,?)}";
CallableStatement proc = conn.prepareCall(sql);
   int status = 0;   
proc.setString(1, "2");
   proc.registerOutParameter(2, Types.INTEGER);
   proc.execute();
   status = proc.getInt(2);