数据库连接工具类-创新互联

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

你是否还在寻找稳定的海外服务器提供商？创新互联www.cdcxhl.cn海外机房具备T级流量清洗系统配攻击溯源，准确流量调度确保服务器高可用性，企业级服务器适合批量采购，新人活动首月15元起，快前往官网查看详情吧