sql文件里边的内容
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50096
Source Host : localhost:3306
Source Database : cemscenter1
Target Server Type : MYSQL
Target Server Version : 50099
File Encoding : 65001
Date: 2015-04-22 10:09:37
*/
SET FOREIGN_KEY_CHECKS=0;
-- Procedure structure for QueryLimberWaterHourData
DROP PROCEDURE IF EXISTS QueryLimberWaterHourData
;
DELIMITER ;;
CREATE DEFINER=root
@localhost
PROCEDURE QueryLimberWaterHourData
()
BEGIN
select * from temp_waterhourdata;
END
;;
DELIMITER ;
这个sql文件在Navicat里边执行可以成功
在java程序里用 SQLExec 执行就报错
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER' at line 1
java 代码
SQLExec sqlExec = new SQLExec();
sqlExec.setDriver("com.mysql.jdbc.Driver");
sqlExec.setUrl("jdbc:mysql://localhost:3306/test");
sqlExec.setUserid("root");
sqlExec.setPassword("ssdlh");
sqlExec.setSrc(new File("src/process"+name+".sql"));
sqlExec.setOnerror((SQLExec.OnError)(EnumeratedAttribute.getInstance(
SQLExec.OnError.class, "abort")));
sqlExec.setPrint(true);
sqlExec.setOutput(new File("src/sql.out"));
sqlExec.setProject(new Project());
try{
sqlExec.execute();