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();
}
}
本站僅提供存儲服務(wù),所有內(nèi)容均由用戶發(fā)布,如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請
點擊舉報。