假如有如下的代码,那么会默认创建一个数据库“sample.db”,并且该数据库被创建于tomcat目录中的bin目录下
private String driverClass = "org.sqlite.JDBC";
private String jdbcURL = "jdbc:sqlite:sample.db";
private String user = "";
private String pwd = "";
abstract public T execute() throws Exception;
protected Connection getConnection() throws Exception {
Class.forName(driverClass);
Connection conn = DriverManager.getConnection(jdbcURL);
createtable(conn);
return conn;
}
如果要指定数据库的生成路径,比如创建于"C:/backup/“目录中,则应把第二句改为
private String jdbcURL = "jdbc:sqlite://C:/backup/sample.db";
sqlite后面的蓝色双斜杠表示可以从最根目录开始