jdbc连接sqlite工具类

将sqlite数据库拷贝到制定文件，修改工具类中的位置，然后写操作代码就可以了。

   
   

   
   
    
    
    
     
     org.xerial
    
    
    
    
    
     
     sqlite-jdbc
    
    
    
    
    
     
     3.15.0
    
    

   
   package com.sql.utils;

import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class J4SqlLiteUtils {
	private Connection connection = null;
	private PreparedStatement pstat = null;
	private ResultSet rst = null;
	public J4SqlLiteUtils() {
		try {
			Class.forName("org.sqlite.JDBC");
			connection = DriverManager.getConnection("jdbc:sqlite:E:/tmp/yps_2016-12-19.db");
			System.out.println("[SQL LITE]: 获取到sqlite的jdbc连接： "+connection);
		} catch (Exception e) {
			System.err.println("[SQL LITE]: 获取sqlite的jdbc连接失败");
			System.err.println(e.getMessage());
		} finally {
			close();
		}
	}
	public Connection getConnection() {
		return connection;
	}
	
	/**
	 * 执行修改删除插入操作
	 * @param sql
	 * @param args
	 * @return
	 */
	public int execute(String sql, Object ...args) {
		int executeUpdate = 0;
		try {
			System.out.println("[SQL EXECUTE]: " + sql);
			pstat = connection.prepareStatement(sql);
			if(args.length>0) {
				for (int i = 0, len = args.length; i < len; i++) {
					pstat.setObject(i+1, args[i]);
				}
			}
			
			executeUpdate = pstat.executeUpdate();
			rst = pstat.getGeneratedKeys();
			
			if(rst!=null) {
				
			}
			
			System.out.println("[SQL EXECUTE RESULT]: "+executeUpdate);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close();
		}
		return executeUpdate;
	}
	
	/**
	 * 查询一条记录
	 * @param sql
	 * @return
	 */
	public Map
   
   
    
     unique(String sql) {
		Map
    
    
     
      result = null;
		try {
			System.out.println("[SQL UNIQUE]: " + sql);
			pstat = connection.prepareStatement(sql);
			rst = pstat.executeQuery();
			
			//获取到
			ResultSetMetaData metaData = rst.getMetaData();
			int cols = metaData.getColumnCount();
			
			if(rst.next()) {
				//封装一行数据
				result = new HashMap
     
     
      
      ();
				for (int i = 0; i < cols; i++) {
					String key = metaData.getColumnName(i+1);
					Object value = rst.getObject(i+1);
					result.put(key, value);
				}
			}
			System.out.println("[SQL UNIQUE RESULT]: "+result);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close();
		}
		return result;
	}
	
	/**
	 * 查询一个列表中的数据
	 * @param sql
	 * @return
	 */
	public List