JdbcUtil

最新推荐文章于 2024-02-02 20:44:30 发布

饭帅

最新推荐文章于 2024-02-02 20:44:30 发布

阅读量2.6k

点赞数

分类专栏： JAVA 文章标签： exception properties disk insert jdbc null

本文链接：https://blog.csdn.net/doctormacky/article/details/6641187

版权

JAVA 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

package com.ibm.irip.util;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

import com.ibm.constant.Constant;
import com.ibm.irip.service.connect.GetProperty;
/**
 * 
 * @author doctormacky
 *
 */
public class JdbcUtil

{
	static{
	  String driverClassName =
		  GetProperty.getValue(Constant.DRIVER_CLASSNAME_JDBC);
	  try{
	    Class.forName(driverClassName);
	  }catch(Exception e){
	    e.printStackTrace();
	  }
	}
    
	public static Connection getConnection(){

		
		Connection con = null;
		String url = GetProperty.getValue(Constant.URL_JDBC);
		Properties properties = new Properties();
		properties.setProperty("user", GetProperty.getValue(Constant.USER_NAME_JDBC));
		properties.setProperty("password", GetProperty.getValue(Constant.PWD_JDBC));
		properties.setProperty("currentSchema",GetProperty.getValue(Constant.SCHEMA));
		
		try {
			// con = DriverManager.getConnection(url, userName, pwd);
			con = DriverManager.getConnection(url, properties);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
		return con;
	}

    public static void close(ResultSet rs,
    		PreparedStatement pstmt ,Connection con){
	   try{
		 if(rs!=null) rs.close();
	   }catch(Exception e){
	     e.printStackTrace();
	   }
	   try{
		 if(pstmt!=null) pstmt.close();
	   }catch(Exception e){
	     e.printStackTrace();
	   }
	   try{
		 if(con!=null) con.close();
	   }catch(Exception e){
	     e.printStackTrace();
	   }
	}

    public static void close(Object o){
	   try{
	     if(o instanceof ResultSet){
		   ((ResultSet)o).close();
		 }else if(o instanceof PreparedStatement){
		   ((PreparedStatement)o).close();
		 }else if(o instanceof Connection){
		   ((Connection)o).close();
		 } 
	   }catch(Exception e){
	     e.printStackTrace();
	   }
	}
}

使用方法：

package com.ibm.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;
import java.util.logging.Logger;

import com.ibm.dao.DiskInfoDAO;
import com.ibm.irip.bean.DiskInfo;
import com.ibm.irip.util.JdbcUtil;
import com.ibm.irip.util.LogManager;

public class DiskInfoDAOImpl implements DiskInfoDAO {

   private static Logger logger = LogManager.getLogger(DiskInfoDAOImpl.class);
   public void add(DiskInfo diskInfo) {

   }
   public void add(List<DiskInfo> diskInfos,String time) {
       StringBuffer sb = new StringBuffer();
       sb.append("insert into KP2_LOGICAL_DISK(");
       sb.append("TMZDIFF,");
       sb.append("WRITETIME,");
       sb.append("Node,");
       sb.append("Timestamp,");
       sb.append("Parent_OID,");
       sb.append("OID,");
       sb.append("Server_Name,");
       sb.append("Logical_Disk_Name,");
       sb.append("Type,");
       sb.append("Disk_Space_Used_Pct,");
       sb.append("Disk_Space_Available_Pct,");
       sb.append("Disk_Space_Used_MB,");
       sb.append("Disk_Space_Available_MB)");
       sb.append("values(?,?,?,?,?,?,?,?,?,?,?,?,?)");
       Connection connection = JdbcUtil.getConnection();
       PreparedStatement preparedStatement = null;
       try {
           connection.setAutoCommit(false);
           preparedStatement = connection.prepareStatement(sb.toString());

           for(int i=0;i<diskInfos.size();i++){
               DiskInfo diskInfo = diskInfos.get(i);
               diskInfo.setWriteTime(time);
               diskInfo.setTmzdiff(2500);
               diskInfo.setNode("iripnode");
               diskInfo.setTimeStamp(time);
               diskInfo.setType(100);
               preparedStatement.setInt(1, diskInfo.getTmzdiff());
               preparedStatement.setString(2, diskInfo.getWriteTime());
               preparedStatement.setString(3, diskInfo.getNode());
               preparedStatement.setString(4, diskInfo.getTimeStamp());
               preparedStatement.setBigDecimal(5, diskInfo.getParentOid());
               preparedStatement.setBigDecimal(6, diskInfo.getParentOid());
               preparedStatement.setString(7, diskInfo.getServerName());
               preparedStatement.setString(8, diskInfo.getDiskName());
               preparedStatement.setInt(9, diskInfo.getType());
               preparedStatement.setDouble(10, diskInfo.getDiskSpaceUsed());
               preparedStatement.setDouble(11, diskInfo.getDiskSpaceAvailable());
               preparedStatement.setDouble(12, diskInfo.getDiskSpaceUsedPct());
               preparedStatement.setDouble(13, diskInfo.getDiskSpaceAvailablePct());
               preparedStatement.addBatch();
           }
           preparedStatement.executeBatch();
           connection.commit();
           //System.out.println("============== disk insert success==================");
       } catch (SQLException e) {

           logger.severe("Disk info insert error!!!!!");
           try {
               connection.rollback();
           } catch (SQLException e1) {
               logger.severe("Disk info insert faild and rollback faild!!");
           }
       }finally{
           JdbcUtil.close(null, preparedStatement, connection);
       }
   }
}