src/dao/CommDAO.java

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

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

package dao;

import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;
import java.util.Enumeration;
import java.util.HashMap;
import java.util.List;
import java.util.Properties;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import util.Info;

public class CommDAO {

	Connection conn = null;

	public CommDAO() {
		conn = this.getConn();
	}

	private static Properties config = null;

	static {
		try {

			config = new Properties();
			// InputStream in = config.getClass().getResourceAsStream("dbconnection.properties");

			InputStream in = CommDAO.class.getClassLoader()
					.getResourceAsStream("dbconnection.properties");

			config.load(in);
			System.out.println(config.get("dburl"));
			in.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public HashMap getmap(String id, String table) {
		List<HashMap> list = new ArrayList();
		try {
			Statement st = conn.createStatement();
			System.out.println("select * from " + table + " where id=" + id);
			ResultSet rs = st.executeQuery("select * from " + table
					+ " where id=" + id);
			ResultSetMetaData rsmd = rs.getMetaData();
			while (rs.next()) {
				HashMap map = new HashMap();