JdbcUtil

来源：互联网发布：隐藏图标的软件编辑：程序博客网时间：2024/05/18 02:54

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);
       }
   }
}