java sqlite 操作_Java SQLite 数据库操作

Java SQLite 数据库操作

1.[代码][Java]代码

package UI;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import GPS.GPS_Info;

public class DB

{

public String dbname="posidata.db";

private String connectionUrl="jdbc:sqlite:";

public Connection con=null;

private Statement stmt=null;

private PreparedStatement psm=null;

private ResultSet rs=null;

String path=null;

public DB()

{

path=this.getClass().getClassLoader().getResource("").getPath()+"/resource/posidata.db";

//System.out.println(path);

connectionUrl+=path;

}

public boolean connect()

{

String psql="insert into position values(?,?,?,?,?,datetime('now'),?)";// id,lat,lats,lng,lngs,time,speed

try

{

Class.forName("org.sqlite.JDBC");

con=DriverManager.getConnection(connectionUrl);

stmt=con.createStatement();

this.psm=con.prepareStatement(psql);

return true;

}

catch(SQLException e)

{

e.printStackTrace();

return false;

}

catch(ClassNotFoundException e)

{

e.printStackTrace();

return false;

}

}

public void close()

{

if(rs!=null)

try

{

rs.close();

}

catch(Exception e)

{

}

if(stmt!=null)

try

{

stmt.close();

}

catch(Exception e)

{

}

if(psm!=null)

try

{

psm.close();

}

catch(Exception e)

{

}

if(con!=null)

try

{

con.close();

}

catch(Exception e)

{

}

}

public synchronized int update(String sql) throws SQLException

{

return stmt.executeUpdate(sql);

}

}