import java.sql.*;
public class TestBatch {
/**
* @param args
*/
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
Class.forName("oracle.jdbc.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL", "scott", "lomboz_eclipse");
/*Statement stmt = conn.createStatement();
stmt.addBatch("insert into dept values (52,'a','aa')");
stmt.addBatch("insert into dept values (53,'b','bb')");
stmt.addBatch("insert into dept values (54,'c','cc')");
stmt.executeBatch();*/
PreparedStatement pstmt = conn.prepareStatement("insert into dept values (?,?,?)");
pstmt.setInt(1, 58);
pstmt.setString(2, "hefei");
pstmt.setString(3, "HF");
pstmt.addBatch();
pstmt.setInt(1, 59);
pstmt.setString(2, "hefei");
pstmt.setString(3, "HF");
pstmt.addBatch();
pstmt.setInt(1, 60);
pstmt.setString(2, "hefei");
pstmt.setString(3, "HF");
pstmt.addBatch();
pstmt.executeBatch();
pstmt.close();
conn.close();
}
}
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。