1. java連接sqlite3,怎麼支持中文路徑,路徑怎麼轉碼
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
publicclassSample
{
publicstaticvoidmain(String[]args)
{
Connectionconnection=null;
try
{
//createadatabaseconnection
connection=DriverManager.getConnection("jdbc:sqlite:示例.db");
Statementstatement=connection.createStatement();
statement.setQueryTimeout(30);//settimeoutto30sec.
statement.executeUpdate("droptableifexistsperson");
statement.executeUpdate("createtableperson(idinteger,namestring)");
statement.executeUpdate("insertintopersonvalues(1,'leo')");
statement.executeUpdate("insertintopersonvalues(2,'yui')");
ResultSetrs=statement.executeQuery("select*fromperson");
while(rs.next())
{
//readtheresultset
System.out.println("name="+rs.getString("name"));
System.out.println("id="+rs.getInt("id"));
}
}
catch(SQLExceptione)
{
//iftheerrormessageis"outofmemory",
//
System.err.println(e.getMessage());
}
finally
{
try
{
if(connection!=null)
connection.close();
}
catch(SQLExceptione)
{
//connectionclosefailed.
System.err.println(e);
}
}
}
}