java连接sqlite文件，并进行增删改查

package com.genersoft.circulate.bsgl.bssjlcsp.utils;
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.List;

import com.genersoft.circulate.bsgl.bssjlcsp.view.RcBssjwhmxView;
public class SqliteUtils {

	private String sqlurl;
	
     

	public String getSqlurl() {
		return sqlurl;
	}

	public void setSqlurl(String sqlurl) {
		this.sqlurl = sqlurl;
	}

	private Connection connect()
    { 
        Connection conn = null;//定义数据库连接对象

        try {
            //String url = "jdbc:sqlite:E:/sqlite/9111000071092649XU_0034_1000_20201112193540.db";   //定义连接数据库的url(url:访问数据库的URL路径),test为数据库名称
            String url=sqlurl; 
        	Class.forName("org.sqlite.JDBC");//加载数据库驱动
            conn = DriverManager.getConnection(url);    //获取数据库连接

            System.out.println("数据库连接成功！\n");//数据库连接成功输出提示
        } 
        //捕获异常信息
        catch (Exception e) {
            System.out.println("数据库连接失败！"+e.getMessage());
        }
        return conn;//返回一个连接
    }

    public int selectAll(String table) {   //选择 文本区 中的所有文本。在 null 或空文档上不执行任何操作。
        String sql="Select max(cast(LIN_FLAG as integer)) AS LIN_FLAG from "+table+"";//将从表中查询到的的所有信息存入sql
        int lineflag=0;
        try {
            Connection conn = this.connect();
            Statement stmt = conn.createStatement();//得到Statement实例
            ResultSet rs = stmt.executeQuery(sql);//执行SQL语句返回结果集
            //输出查询到的记录的内容（表头）
         // 当返回的结果集不为空时，并且还有记录时，循环输出记录
            while (rs.next()) {
                //输出获得记录中的"name","sex","age"字段的值
            	lineflag=rs.getInt("LIN_FLAG");
                System.out.println( "lineflag=="+lineflag);
            }
        } 
        catch (SQLException e) {
            System.out.println("查询数据时出错！"+e.getMessage());
        }
        return lineflag;
    }
    public  int saveDb(String table,RcBssjwhmxView mx,int i){
    	StringBuffer sb=new StringBuffer();
    	sb.append("INSERT INTO '");
    	sb.append(table);
    	sb.append("'( 'CORP_CD', ");
    	sb.append("'CORP_NM',");
    	sb.append("'INFO_RES_ID',");
    	sb.append("'INDX_ID',");
    	sb.append("'INDX_NM', ");
    	sb.append("'DATA_CONTT',");
    	sb.append(" 'LIN_FLAG','DATA_FLAG',");
    	sb.append("'SETUP_TM', 'UPD_TM') VALUES ('");
    	sb.append(mx.getCorpCd());
    	sb.append("','");
    	sb.append(mx.getCorpNm());
    	sb.append("','");
    	sb.append(mx.getInfoResId());
    	sb.append("','");
    	sb.append(mx.getIndxId());
    	sb.append("','");
    	sb.append(mx.getIndxNm());
    	sb.append("','");
    	sb.append(mx.getDataContt());
    	sb.append("','");
    	sb.append(i+1);
    	sb.append("',");
    	sb.append(mx.getDataFlag());
    	sb.append(",'");
    	sb.append(mx.getSetupTm());
    	sb.append("','");
    	sb.append(mx.getUpdTm());
    	sb.append("')");
    	System.out.println("sql="+sb.toString());
	  	//创建sql语句执行器
    	 Connection conn = this.connect();
	  	PreparedStatement ps;
	  	int n=0;
		try {
			ps = conn.prepareStatement(sb.toString());
			//执行语句
		  	n=ps.executeUpdate();
		  	//判断是否添加成功
		  	if(n>0) {
		  		System.out.println("添加成功！");
		  	}else {
		  		System.out.println("添加失败！");
		  	}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return n;
	  	
    }
    public  int savebatchDb(String table,List<RcBssjwhmxView> mxlist, int linefalg){
    	int seccess=0;
    	if(mxlist.size()>0){
    		for(int i = 0 ; i < mxlist.size() ; i++) {
    			int saveDb = saveDb(table,mxlist.get(i),linefalg);
    			seccess=seccess+saveDb;
    		}
    		
    	}
    	return seccess;
	  
    }
    public String sqldata(String table,RcBssjwhmxView mx){
    	StringBuffer sb=new StringBuffer();
    	sb.append("INSERT INTO '");
    	sb.append(table);
    	sb.append("'( 'CORP_CD', ");
    	sb.append("'CORP_NM',");
    	sb.append("'INFO_RES_ID',");
    	sb.append("'INDX_ID',");
    	sb.append("'INDX_NM', ");
    	sb.append("'DATA_CONTT',");
    	sb.append(" 'LIN_FLAG','DATA_FLAG',");
    	sb.append("'SETUP_TM', 'UPD_TM') VALUES ('");
    	sb.append(mx.getCorpCd());
    	sb.append("','");
    	sb.append(mx.getCorpNm());
    	sb.append("','");
    	sb.append(mx.getInfoResId());
    	sb.append("','");
    	sb.append(mx.getIndxId());
    	sb.append("','");
    	sb.append(mx.getIndxNm());
    	sb.append("','");
    	sb.append(mx.getDataContt());
    	sb.append("','");
    	sb.append(mx.getLinFlag());
    	sb.append("',");
    	sb.append(mx.getDataFlag());
    	sb.append(",'");
    	sb.append(mx.getSetupTm());
    	sb.append("','");
    	sb.append(mx.getUpdTm());
    	sb.append("')");
    	System.out.println("sql="+sb.toString());
    	return sb.toString();
    }
	
        //定义main方法
       public static void main(String[] args) {
    	  // System.out.println("11111");
    	  /* List<RcBssjwhmxView> listBssjmx = new ArrayList<RcBssjwhmxView>();
    	   RcBssjwhmxView mx=new RcBssjwhmxView();
    	   mx.setCorpCd("9111000071092649XU");
    	   mx.setCorpNm("中国储备粮管理集团有限公司");
    	   mx.setInfoResId("3031271068");
    	   mx.setIndxId("16031");
    	   mx.setIndxNm("企业名称（全称）");
    	   mx.setDataContt("保存555");
    	   mx.setLinFlag("1");
    	   mx.setDataFlag("1");
    	   mx.setSetupTm("2021-01-06 11:20:20");
    	   mx.setUpdTm("2021-03-31 15:28:01");
    	   listBssjmx.add(mx);
    	   RcBssjwhmxView mx2=new RcBssjwhmxView();
    	   mx2.setCorpCd("9111000071092649XU");
    	   mx2.setCorpNm("中国储备粮管理集团有限公司");
    	   mx2.setInfoResId("3031271068");
    	   mx2.setIndxId("16031");
    	   mx2.setIndxNm("企业名称（全称）");
    	   mx2.setDataContt("保存666");
    	   mx2.setLinFlag("1");
    	   mx2.setDataFlag("1");
    	   mx2.setSetupTm("2021-01-06 11:20:20");
    	   mx2.setUpdTm("2021-03-31 15:28:01");
    	   listBssjmx.add(mx2);
    	   SqliteUtils app = new SqliteUtils();//创建了一个INFOR对象
    	   app.setSqlurl("jdbc:sqlite:D:\\inspurywxt\\03项目\\审批系统\\02代码目录\\分版本代码_漏洞整改\\sinoWeb_sp\\test-file\\sqlite\\9111000071092649XU_0034_1000_20201112193540.db");
            int saveDb = app.savebatchDb("hadwn_rest_gathr_tab_077",listBssjmx);//调用对象的selectAll方法
            System.out.println("saveDb=="+saveDb);
    	   int a=app.selectAll("hadwn_rest_gathr_tab_077");
    	   System.out.println("a=="+a);*/
    	   SqliteUtils app = new SqliteUtils();//创建了一个INFOR对象
    	   app.setSqlurl("jdbc:sqlite:F:/93540.db");//sqlite文件路径
    	   int a=app.selectAll("hadwn_rest_gathr_tab_077");//sqlite相关的数据表名称
    	   System.out.println("a=="+a);
        }

    }