jdbc Statement 和CallableStatement 和 PreparedStatement

最新推荐文章于 2021-01-19 04:46:59 发布

原创最新推荐文章于 2021-01-19 04:46:59 发布 · 362 阅读

0 ·

CC 4.0 BY-SA版权

Statement 同时被 3 个专栏收录

2 篇文章

订阅专栏

CallableStatement

1 篇文章

订阅专栏

PreparedStatemen

1 篇文章

订阅专栏

本文介绍如何使用Java JDBC进行SQL批量操作及参数化查询，包括Statement、PreparedStatement和CallableStatement的基本用法，展示了如何利用这些对象提高数据库操作效率。

Statement用法:

String sql = "select seq_orderdetailid.nextval as test dual";
Statement stat1=conn.createStatement();
ResultSet rs1 = stat1.executeQuery(sql);
if ( rs1.next() ) {
	id = rs1.getLong(1);
}

INOUT参数使用：

CallableStatement cstmt = conn.prepareCall("{call revise_total(?)}");
cstmt.setByte(1, 25);
cstmt.registerOutParameter(1, java.sql.Types.TINYINT);
cstmt.executeUpdate();
byte x = cstmt.getByte(1);

Statement的Batch使用:

Statement stmt  = conn.createStatement();
String sql = null;
for(int i =0;i<20;i++){
	sql = "insert into test(id,name)values("+i+","+i+"_name)";
	stmt.addBatch(sql);
}
stmt.executeBatch();

PreparedStatement的Batch使用:

PreparedStatement pstmt  = con.prepareStatement("UPDATE EMPLOYEES  SET SALARY = ? WHERE ID =?");
for(int i =0;i<length;i++){
	pstmt.setBigDecimal(1, param1[i]);
	pstmt.setInt(2, param2[i]);
	pstmt.addBatch();
}
pstmt.executeBatch();

PreparedStatement用法:

PreparedStatement pstmt  = con.prepareStatement("UPDATE EMPLOYEES  SET SALARY = ? WHERE ID =?");
pstmt.setBigDecimal(1, 153.00);
pstmt.setInt(2, 1102);
pstmt. executeUpdate()

;