public boolean insertJob(long jobid,List prlist,String time,int khid){

boolean b=false;
Connection conn=null;
PreparedStatement ps =null;?
conn = DB.getConnection();
String sql="insert into job(jobid,msisdn,sendtime,name,khid) values (?,?,?,?,?)";
try{
conn.setAutoCommit(false);

ps = conn.prepareStatement(sql);

for(int i=0;i<prlist.size();i++){
Partyregister pr=(Partyregister)prlist.get(i);
ps.setLong(1, jobid);
ps.setString(2,pr.getMsisdn());
ps.setTimestamp(3, Timestamp.valueOf(time));
ps.setString(4, pr.getName());
ps.setInt(5, khid);
ps.addBatch();
}

??? ps.executeBatch();
??? conn.commit();??
??? conn.setAutoCommit(true);
??? b=true;
}
catch(Exception e){
b=false;
??? System.err.println("ERROR:"+e);
??? }
?????? finally
?????? {
?????????? try
?????????? {
?????????????? ps.close();
?????????????? if(null!=conn)
?????????????? {
?????????????? conn.close();
?????????????? }
?????????? }
?????????? catch(SQLException sqle)
?????????? {
?????????? System.err.println("SQLException, sqle=" + sqle.toString());
?????????? }
?????? }
??????
return b;
}

?