?? lab10.java
字號:
package com.jdbclab;
import java.sql.*;
public class Lab10
{
public static void main(String[] args){
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try{
con = JdbcUtil.getConnection();
//1.關閉自動提交
con.setAutoCommit(false);
//2.進行若干數據庫操作
String sql =
"insert into t_sd0709_test values(?,?)";
ps = con.prepareStatement(sql);
//ps.setInt(1,1000);
//ps.setString(2,"Black");
//ps.executeUpdate();
for(int i=101;i<121;i++){
ps.setInt(1,i);
ps.setString(2,"Rose"+i);
ps.executeUpdate();
}
JdbcUtil.release(ps);
sql = "select * from t_sd0709_test order by id";
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
JdbcUtil.printRs(rs);
JdbcUtil.release(rs);
//3.提交或回滾
//con.commit();
rs = ps.executeQuery();
System.out.println("-------second select------");
JdbcUtil.printRs(rs);
}catch(Exception e){
e.printStackTrace();
try{
if(con!=null) con.rollback();
}catch(Exception ex){
ex.printStackTrace();
}
}finally{
JdbcUtil.release(rs,ps,con);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -