JDBC批量保存数据

/** 
 *  保存业务公告的网页提示对象列表; 
 * @param voList 
 * @return 
 * @throws DAOException 
 */ 
public int saveBatchWebTipToListBox(final List<WebTipVo> voList) throws DAOException{  
return (Integer)getHibernateTemplate().execute(new HibernateCallback()   {    
public Object doInHibernate(Session s) throws HibernateException,SQLException {    
int retVal=0;  
 
//DataSource ds = SessionFactoryUtils.getDataSource(s.getSessionFactory());  
Connection conn=s.connection();  
PreparedStatement ps=null;  
 
String savesql="insert into WebTipBox(cityId,countyId,startTime,endTime,msgId) values(?,?,?,?,?)";  
try {  
//conn = ds.getConnection();  
 
ps=conn.prepareStatement(savesql);  
for(WebTipVo vo : voList){  
ps.setString(1, vo.getCityId());  
ps.setString(2, vo.getCountyId());  
ps.setTimestamp(3,new Timestamp(vo.getStartTime().getTime()));  
ps.setTimestamp(4, new Timestamp(vo.getEndTime().getTime()));  
ps.setInt(5, vo.getMsgId());  
 
ps.addBatch();  
}//endfor;  
int[] savedNum=ps.executeBatch();  
retVal=savedNum.length;  
logger.info("_saved WebTip records num: "+retVal);  
   
if(ps!=null) ps.close();  
if(conn!=null) conn.close();  
 
} catch (SQLException e) {  
e.printStackTrace();  
if(conn!=null)   
try{conn.close();   
}catch(SQLException esql){  
retVal=0;  
logger.info("_deleteNopassAuditRow() exception,msg:"+esql.getMessage());  
};  
} 
/**
 *  保存业务公告的网页提示对象列表;
 * @param voList
 * @return
 * @throws DAOException
 */
public int saveBatchWebTipToListBox(final List<WebTipVo> voList) throws DAOException{
return (Integer)getHibernateTemplate().execute(new HibernateCallback()   { 
public Object doInHibernate(Session s) throws HibernateException,SQLException { 
int retVal=0;

//DataSource ds = SessionFactoryUtils.getDataSource(s.getSessionFactory());
Connection conn=s.connection();
PreparedStatement ps=null;

String savesql="insert into WebTipBox(cityId,countyId,startTime,endTime,msgId) values(?,?,?,?,?)";
try {
//conn = ds.getConnection();

ps=conn.prepareStatement(savesql);
for(WebTipVo vo : voList){
ps.setString(1, vo.getCityId());
ps.setString(2, vo.getCountyId());
ps.setTimestamp(3,new Timestamp(vo.getStartTime().getTime()));
ps.setTimestamp(4, new Timestamp(vo.getEndTime().getTime()));
ps.setInt(5, vo.getMsgId());

ps.addBatch();
}//endfor;
int[] savedNum=ps.executeBatch();
retVal=savedNum.length;
logger.info("_saved WebTip records num: "+retVal);
 
if(ps!=null) ps.close();
if(conn!=null) conn.close();

} catch (SQLException e) {
e.printStackTrace();
if(conn!=null)
try{conn.close();
}catch(SQLException esql){
retVal=0;
logger.info("_deleteNopassAuditRow() exception,msg:"+esql.getMessage());
};
}

 


本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/wf_0817/archive/2010/01/10/5166143.aspx

<script src="/js/feedbackcount.js" type="text/javascript"></script>