JDBC for SQL Lite

package com.june.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public final class JDBCUtil {

	private static JDBCUtil instance = null;
	static Connection conn = null;
	private JDBCUtil() {
		
	}

	public static synchronized JDBCUtil getInstance() {
		if (instance == null) {
			instance = new JDBCUtil();
		}
		return instance;
	}

	static {
		try {
			Class.forName("org.sqlite.JDBC");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	public Connection getConnection(){
		try {
			// 建立一个数据库名proman.db的连接，如果不存在就在当前目录下创建之
			Connection conn = DriverManager
					.getConnection("jdbc:sqlite:proman.db");
			return conn;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn = null;
	}
	public void free(ResultSet rs, Statement st, Connection conn) {
		try {
			if (rs != null) {
				rs.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if (st != null) {
					st.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				try {
					if (conn != null) {
						conn.close();
					}
				} catch (SQLException e) {
					e.printStackTrace();
				}finally{
					
				}
			}
		}
	}
	
	
	
}

 

-------------------------------------------------------

/**
 * 
 */
package com.june.db;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * @author yongjun.he
 *
 */
public class DbService_Tbl_Project implements DbServiceBase {
	public JDBCUtil jdbc = JDBCUtil.getInstance();
	/* (non-Javadoc)
	 * @see com.june.db.DbServiceBase#excSql()
	 */
	@Override
	public void excSql() {
		// TODO Auto-generated method stub
		
	}

	/* (non-Javadoc)
	 * @see com.june.db.DbServiceBase#querySql()
	 */
	@Override
	public void querySql() {
		try {
			jdbc.conn = jdbc.getConnection();
			Statement stat = jdbc.conn.createStatement();
			ResultSet rs = stat.executeQuery("select * from table1;");// 查询数据
			while (rs.next()) {
				System.out.print("name = " + rs.getString("name") + " ");// 列属性一
				System.out.println("age = " + rs.getString("age"));// 列属性二
			}
			jdbc.free(rs, stat, jdbc.conn);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public static void main(String[] arts){
		DbService_Tbl_Project t = new DbService_Tbl_Project();
		t.querySql();
	}

}