import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
public class TransactionDemo {
// 驱动程序就是之前在classpath中配置的jdbc的驱动程序的jar包中
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
// 连接地址是由各个数据库生产商单独提供的,所以需要单独记住
public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:orcl";
// 连接数据库的用户名
public static final String DBUSER = "system";
// 连接数据库的密码
public static final String DBPASS = "orcl";
public static void main(String[] args) {
Connection conn = null; // 表示数据库的连接对象
Statement stmt = null; // 表示数据库的更新操作
ResultSet result = null; // 表示接收数据库的查询结果
// 1.使用Class类加载驱动程序
try {
Class.forName(DBDRIVER);
// 2.连接数据库
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
conn.setAutoCommit(false); // 取消自动提交
// 3.Statement接口需要通过Connetion接口进行实例化操作
stmt = conn.createStatement();
try {
stmt.addBatch("INSERT INTO person(pid,name,age,birthday,salary) VALUES (perseq.nextval,'张三',30,TO_DATE('1995-02-14','yyyy-mm-dd'),9000.0)");
stmt.addBatch("INSERT INTO person(pid,name,age,birthday,salary) VALUES (perseq.nextval,'李四',30,TO_DATE('1995-02-14','yyyy-mm-dd'),9000.0)");
stmt.addBatch("INSERT INTO person(pid,name,age,birthday,salary) VALUES (perseq.nextval,'王五',30,TO_DATE('1995-02-14','yyyy-mm-dd'),9000.0)");
stmt.addBatch("INSERT INTO person(pid,name,age,birthday,salary) VALUES (perseq.nextval,'赵六',30,TO_DATE('1995-02-14','yyyy-mm-dd'),9000.0)");
// 执行sql语句,更新数据库
int i[] = stmt.executeBatch();
System.out.println(i.length);
conn.commit();// 提交
} catch (SQLException e) {
conn.rollback();
}
// 4.关闭数据库
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
public class TransactionDemo {
// 驱动程序就是之前在classpath中配置的jdbc的驱动程序的jar包中
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
// 连接地址是由各个数据库生产商单独提供的,所以需要单独记住
public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:orcl";
// 连接数据库的用户名
public static final String DBUSER = "system";
// 连接数据库的密码
public static final String DBPASS = "orcl";
public static void main(String[] args) {
Connection conn = null; // 表示数据库的连接对象
Statement stmt = null; // 表示数据库的更新操作
ResultSet result = null; // 表示接收数据库的查询结果
// 1.使用Class类加载驱动程序
try {
Class.forName(DBDRIVER);
// 2.连接数据库
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
conn.setAutoCommit(false); // 取消自动提交
// 3.Statement接口需要通过Connetion接口进行实例化操作
stmt = conn.createStatement();
try {
stmt.addBatch("INSERT INTO person(pid,name,age,birthday,salary) VALUES (perseq.nextval,'张三',30,TO_DATE('1995-02-14','yyyy-mm-dd'),9000.0)");
stmt.addBatch("INSERT INTO person(pid,name,age,birthday,salary) VALUES (perseq.nextval,'李四',30,TO_DATE('1995-02-14','yyyy-mm-dd'),9000.0)");
stmt.addBatch("INSERT INTO person(pid,name,age,birthday,salary) VALUES (perseq.nextval,'王五',30,TO_DATE('1995-02-14','yyyy-mm-dd'),9000.0)");
stmt.addBatch("INSERT INTO person(pid,name,age,birthday,salary) VALUES (perseq.nextval,'赵六',30,TO_DATE('1995-02-14','yyyy-mm-dd'),9000.0)");
// 执行sql语句,更新数据库
int i[] = stmt.executeBatch();
System.out.println(i.length);
conn.commit();// 提交
} catch (SQLException e) {
conn.rollback();
}
// 4.关闭数据库
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}