package cn.utils;

import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class DbConnect {

	public static String BASE_NAME="db";
	private static String DB_DRIVER= PropUtil.getValue("DB_DRIVER");
	private static String DB_URL= PropUtil.getValue("DB_URL");
	private static String DB_USERNAME= PropUtil.getValue("DB_USERNAME");
	private static String DB_PASSWORD= PropUtil.getValue("DB_PASSWORD");
	
	static{
		try {
			Class.forName(DB_DRIVER);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}


	public static int excuteUpdate(String sql,Object...obj) {
		int row=0;
		Connection con= DbConnect.getConnection();
		PreparedStatement pst=null;
		try {
			pst=con.prepareStatement(sql);
			if(obj!=null&&obj.length>0) {
				for(int i=0;i>executeQuery(String sql,Object...obj){ 
		List>list=new ArrayList>();
		Connection con = DbConnect.getConnection();
		PreparedStatement pst=null;
		ResultSet rs=null;
		System.out.println(sql);
		try {
			pst=con.prepareStatement(sql);
			if(obj!=null&&obj.length>0) {
				for(int i=0;imso=new HashMap();
					for(int i=1;i<=colCount;i++) {
						mso.put(rsmd.getColumnName(i), rs.getObject(i));
					}
					list.add(mso);
				}
			}	
		} catch (Exception e) {
			e.getStackTrace();
		}finally {
			dbClose(con, pst, rs);
		}	
		return	list;	
	}

	public static MapqueryOne(String sql,Object...obj){
		Mapmap=new HashMap<>();
		Connection con = DbConnect.getConnection();
		PreparedStatement pst=null;
		ResultSet rs=null;
		System.out.println(sql);
		try {
			pst=con.prepareStatement(sql);
			if(obj!=null&&obj.length>0) {
				for(int i=0;i

你是否還在尋找穩(wěn)定的海外服務器提供商？創(chuàng)新互聯(lián)www.cdcxhl.cn海外機房具備T級流量清洗系統(tǒng)配攻擊溯源，準確流量調(diào)度確保服務器高可用性，企業(yè)級服務器適合批量采購，新人活動首月15元起，快前往官網(wǎng)查看詳情吧