执行sql脚本

1、链接数据库

	private static Connection getMySqlConnection() throws Exception {

		ResourceBundle rb = ResourceBundle.getBundle("jdbc");
		String driver = rb.getString("datasource.driverClassName");
		String url = rb.getString("datasource.url")+"&port=3306";
		String userName = rb.getString("datasource.username");
		String password = rb.getString("datasource.password");
		Class.forName(driver);
		return DriverManager.getConnection(url, userName, password);
	}

2、获取数据

public String importSql(HttpServletRequest request) {

		JsonView jv = new JsonView();
		MultipartRequest mrequest = (MultipartRequest) request;
		MultipartFile file = mrequest.getFile("file");
		try {
			Connection conn = getMySqlConnection();
			ScriptRunner runner = new ScriptRunner(conn);
			runner.setLogWriter(null);// 设置是否输出日志
			Reader reader = new InputStreamReader(file.getInputStream(),
					"utf-8");

            // 绝对路径读取
            //Reader read = new FileReader(new File("f:\\test.sql"));
            // 从class目录下直接读取
            //Reader read = Resources.getResourceAsReader("test.sql");
			runner.runScript(reader);
			runner.closeConnection();
			conn.close();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return jv.toString();
	}