public void execSQL(String fileName) {
File myFile = new File(fileName);
if (!myFile.exists()) {
System.err.println("Can't Find " + fileName);
return;
}
try {
DriverManagerDataSource dataSource=new DriverManagerDataSource();
dataSource.setDriverClassName("org.hsqldb.jdbcDriver");
dataSource.setUrl("jdbc:hsqldb:hsql://localhost/algz");
dataSource.setUsername("sa");
dataSource.setPassword("");
JdbcTemplate jt=new JdbcTemplate();
jt.setDataSource(dataSource);
BufferedReader in = new BufferedReader(new FileReader(myFile));
String sql;
while ((sql = in.readLine()) != null) {
jt.execute(sql);
System.out.print(".");
}
in.close();
System.out.println();
} catch (IOException e) {
e.getStackTrace();
}
}