java连接sqllite数据库

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(); 
			} 
		} 

	   
	   
   }