src/com/inloam/common/QueryAssistant.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.inloam.common;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.sql.DataSource;

public class QueryAssistant {
	
	
	private DataSource dataSource;

	private static QueryAssistant instance;

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

	private QueryAssistant() {

	}

	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
	}

	private Connection getConnection(Object marker) throws SQLException {

		Connection conn = dataSource.getConnection();
		return conn;
	}
	/**
	 * @param  sql 查询的sql语句。 
	 * @return 封装好的list
	 * <p>List 内封装com.westerasoft.common.HashMap. 
	 * HashMap的key为数据库中的字段名，全部小写</p>
	 */
	@SuppressWarnings("unchecked")
	public List select(String sql) {
		Connection conn = null;
		PreparedStatement pst = null;
		ResultSet rs = null;
		ResultSetMetaData rsmd = null;
		List<Object> list = new ArrayList<Object>();
		try {
			conn = getConnection(this);
			pst = conn.prepareStatement(sql);
			rs = pst.executeQuery();
			while (rs.next()) {