package?com.jdbc.dbutils;

import?java.lang.reflect.Field;
import?java.lang.reflect.InvocationTargetException;
import?java.lang.reflect.Method;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;

import?domain.UserInfo;


public?class?JdbcUtils?{
	//數(shù)據(jù)庫(kù)用戶名
	private?static?final?String?USERNAME?=?“root“;
	//數(shù)據(jù)庫(kù)密碼
	private?static?final?String?PASSWORD?=?“yanzi“;
	//驅(qū)動(dòng)信息?
	private?static?final?String?DRIVER?=?“com.mysql.jdbc.Driver“;
	//數(shù)據(jù)庫(kù)地址
	private?static?final?String?URL?=?“jdbc:mysql://localhost:3306/mydb“;
	private?Connection?connection;
	private?PreparedStatement?pstmt;
	private?ResultSet?resultSet;
	public?JdbcUtils（）?{
		//?TODO?Auto-generated?constructor?stub
		try{
			Class.forName（DRIVER）;
			System.out.println（“數(shù)據(jù)庫(kù)連接成功！“）;

		}catch（Exception?e）{

		}
	}

	/**
	?*?獲得數(shù)據(jù)庫(kù)的連接
	?*?@return
	?*/
	public?Connection?getConnection（）{
		try?{
			connection?=?DriverManager.getConnection（URL?USERNAME?PASSWORD）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?connection;
	}


	/**
	?*?增加、刪除、改
	?*?@param?sql
	?*?@param?params
	?*?@return
	?*?@throws?SQLException
	?*/
	public?boolean?updateByPreparedStatement（String?sql?Listject>params）throws?SQLException{
		boolean?flag?=?false;
		int?result?=?-1;
		pstmt?=?connection.prepareStatement（sql）;
		int?index?=?1;
		if（params?!=?null?&&?!params.isEmpty（））{
			for（int?i=0;?i				pstmt.setobject（index++?params.get（i））;
			}
		}
		result?=?pstmt.executeUpdate（）;
		flag?=?result?>?0???true?:?false;
		return?flag;
	}

	/**
	?*?查詢單條記錄
	?*?@param?sql
	?*?@param?params
	?*?@return
	?*?@throws?SQLException
	?*/
	public?Mapject>?findSimpleResult（String?sql?Listject>?params）?throws?SQLException{
		Mapject>?map?=?new?HashMapject>（）;
		int?index??=?1;
		pstmt?=?connection.prepareStatement（sql）;
		if（params?!=?null?&&?!params.isEmpty（））{
			for（int?i=0;?i				pstmt.setobject（index++?params.get（i））;
			}
		}
		resultSet?=?pstmt.executeQuery（）;//返回查詢結(jié)果
		ResultSetmetaData?metaData?=?resultSet.getmetaData（）;
		int?col_len?=?metaData.getColumnCount（）;
		while（resultSet.next（））{
			for（int?i=0;?i				String?cols_name?=?metaData.getColumnName（i+1）;
				object?cols_value?=?resultSet.getobject（cols_name）;
				if（cols_value?==?null）{
					cols_value?=?““;
				}
				map.put（cols_name?cols_value）;
			}
		}
		return?map;
	}

	/**查詢多條記錄
	?*?@param?sql
	?*?@param?params
	?*?@return
	?*?@throws?SQLException
	?*/
	public?Listject>>?findModeResult（String?sql?Listject>?params）?throws?SQLException{
		List