public static ArrayList<String> readFileByLines(String filePath) throws Exception{
ArrayList<String> sqlList = new ArrayList<String>();
StringBuffer str = new StringBuffer();
BufferedReader reader = null;
reader = new BufferedReader(new InputStreamReader(
new FileInputStream(filePath), "UTF-8"));
String tempString = null;
int line = 1;
while ((tempString = reader.readLine()) != null) {
str = str.append(" " + tempString);
line++;
}
reader.close();
String[] sqlArr = str.toString().split(";");
for (int i = 0; i < sqlArr.length; i++) {
sqlList.add(sqlArr[i].toString());
}
return sqlList;
} public static void test3(String sqlPath) throws Exception {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ArrayList<String> sqlList = (ArrayList) readFileByLines(sqlPath);
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test", "root", "123456");
conn.setAutoCommit(false);
stmt = conn.createStatement();
for(int i=0;i<sqlList.size();i++){
String sql = sqlList.get(i);
stmt.addBatch(sql);
}
//stmt.addBatch("drop table if exists b");
stmt.executeBatch();
conn.commit(); // 提交
drop table if exists c
CREATE TABLE `c` ( `id` int(11) NOT NULL, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `hiredate` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
ArrayList<String> sqlList = new ArrayList<String>();
StringBuffer str = new StringBuffer();
BufferedReader reader = null;
reader = new BufferedReader(new InputStreamReader(
new FileInputStream(filePath), "UTF-8"));
String tempString = null;
int line = 1;
while ((tempString = reader.readLine()) != null) {
str = str.append(" " + tempString);
line++;
}
reader.close();
String[] sqlArr = str.toString().split(";");
for (int i = 0; i < sqlArr.length; i++) {
sqlList.add(sqlArr[i].toString());
}
return sqlList;
} public static void test3(String sqlPath) throws Exception {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ArrayList<String> sqlList = (ArrayList) readFileByLines(sqlPath);
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test", "root", "123456");
conn.setAutoCommit(false);
stmt = conn.createStatement();
for(int i=0;i<sqlList.size();i++){
String sql = sqlList.get(i);
stmt.addBatch(sql);
}
//stmt.addBatch("drop table if exists b");
stmt.executeBatch();
conn.commit(); // 提交
drop table if exists c
CREATE TABLE `c` ( `id` int(11) NOT NULL, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `hiredate` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
解决方案 »
- 加了个拦截器,程序报这个错,求帮忙解决
- 在jsp中怎样嵌入一个流媒体播放器
- Oracle版本对java应用程序的影响?
- 工程登陆页面间歇性异常
- XFire Webservices 异常
- 分享 jasperreport1.3.2打印空白行
- 请大家帮忙看看谢谢!!
- 哪位高手可以提供一个详细的hibernate3.1的Blob操作的代码
- [200分]HashMap如何和logic:present、logic:iterate结合使用,我在hashmap中放了多个formbean的实例,解决马上给分 !
- 关于ActrionForward的问题
- java的异常问题
- 大佬们求助 linuex的tomcat一直起不来 不知道怎么回事
在mysql客户端中:
mysql>select @@autocommit;
查看是否开启了自动提交,如果为1,表明开启了。如果是0,表明关闭。
可以采用下面的方式,进行关闭。
mysql>set autocommit=0;