1.下载sqllietjdbc包
package dateconverttool;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Db3Conn {
//数据库变量
Connection c = null;
Statement conn;
ResultSet rs = null;
//初始化连接
public Db3Conn()
{
try
{
Class.forName("org.sqlite.JDBC");
//与url指定的数据源建立连接
c = DriverManager.getConnection("jdbc:sqlite://E:/data.db3");
//采用Statement进行查询
conn = c.createStatement();
}
catch (Exception e)
{
e.printStackTrace();
}
}
public synchronized void execute(String sql)
{
try {
conn.execute(sql);
}
catch (SQLException e)
{
e.printStackTrace();
}
}
public ResultSet executeQuery(String sql)
{
rs = null;
try {
rs = conn.executeQuery(sql);
}
catch (SQLException e)
{
e.printStackTrace();
}
return rs;
}
public void close()
{
try {
conn.close();
c.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}