JDBC ConncetionFactory、Statement、事务提交模式和事务隔离级别和批量处理的应用
创建配置文件和ConncetionFactory类
sqlite.driver=org.sqlite.JDBC
sqlite.url=jdbc:sqlite:E:/SQLite3/StudentManageSystem.db
sqlite.user=
sqlite.password=
oracle.driver=oracle.jdbc.driver.OracleDriver
oracle.url=jdbc:oracle:thin:@" + "host:port:databaseName
oracle.user=**
oracle.password=**
mysql.driver=com.mysql.jdbc.Driver
mysql.url=jdbc:mysql://host:port:databaseName
mysql.user=**
mysql.password=**
package cjx913;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class ConnectionFactory {
private static String DRIVER;
private static String URL;
private static String USER;
private static String PASSWORD;
static{
Properties properties = new Properties();
InputStream is =
ConnectionFactory.class.getResourceAsStream("jdbcinfo.properties");
try {
properties.load(is);//加载配置文件
DRIVER = properties.getProperty("sqlite.driver");//读取文件配置数据库驱动
URL = properties.getProperty("sqlite.url");//读取文件配置数据库URL
USER = properties.getProperty("sqlite.user");//读取文件配置数据库用户
PASSWORD = properties.getProperty("sqlite.password");//读取文件配置数据库用户密码
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* 提供getConnection()方法
* @return Connection
*/
public static Connection getConnection(){
Connection conn = null;
try {
Class.forName(DRIVER);
conn = DriverManager.getConnection(URL);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
}
创建Test类,测试代码
package cjx913;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class test {
public static void main(String[] args) {
insertData();
}
private static void insertData() {
//通过ConnectionFactory建立数据库连接
Connection conn = ConnectionFactory.getConnection();
//创建PreparedStatement,传输SQL语句或参数
PreparedStatement stmt = null;
try {
//设置事务手动提交模式
conn.setAutoCommit(false);
//设置事务隔离级别
conn.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
//
stmt = conn.prepareStatement(
"INSERT INTO Teacher(id,name) VALUES(?,?)");
for(int i=1;i<=1000;i++){
stmt.setInt(1, i);
stmt.setString(2, "教师"+i);
stmt.addBatch();//将参数传输到stmt缓存中
}
stmt.executeBatch();//将所有参数传输到数据库批量处理
conn.commit();//提交事务
} catch (SQLException e) {
e.printStackTrace();
try {
conn.rollback();//回滚事务
} catch (SQLException e1) {
e1.printStackTrace();
}
}finally{
try {
conn.close();//关闭连接
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
我这里使用SQLite数据库,用的是SQLite数据库JDBC的驱动,
插入数据成功后,再次运行显示错误,
应该是回滚失败。。。。。。