JDBC使用Statement,PreparedStatement,CallableStatement.实例

最新推荐文章于 2022-01-19 19:13:00 发布

jc_dreaming2

最新推荐文章于 2022-01-19 19:13:00 发布

阅读量101

点赞数

分类专栏： JAVA 文章标签： JDBC SQL Java

JAVA 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

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);