67,512
社区成员
发帖
与我相关
我的任务
分享
@Override
public boolean saveReconciliation(ArrayList<ConsumedReconciliation> reconciliationList) {
boolean isSucceed=false;
ConsumedReconciliation consumedReconciliation;
String sql="insert into kgl_jfkxfdz (JYRQ,JYSJ,SHMC,JSH,KH,KSSSH,JYLX,ZFFS,SQM,JYJE,ZDH,XTGZH,PCH,ZCY,DDH)"+
" values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
for (int i = 0; i <reconciliationList.size(); i++) {
consumedReconciliation=reconciliationList.get(i);
}
return false;
}
<bean id="jdbcTemplate"
class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource"><ref bean="dataSource"/></property>
</bean>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<bean id="dao" class="cn.com.hnisi.dao.DaoJDBCImpl">
<property name="jdbcTemplate" ref="jdbcTemplate"/>
</bean>
<bean id="serviceTarget" class="cn.com.hnisi.service.ServiceImpl">
<property name="dao" ref="dao"/>
</bean>
<bean id="service" parent="baseTransactionProxy">
<property name="target" ref="serviceTarget"/>
</bean>
<bean id="traceGeneratorTarget" class="cn.com.hnisi.message.DBTraceGenerator" >
<property name="dao" ref="dao" />
</bean>
<bean id="traceGenerator" parent="baseTransactionProxy">
<property name="target" ref="traceGeneratorTarget" />
</bean>
public void saveAll(List<DocHead> dhl) {
String sql = "insert into doc_head(doc_seq,head_seq,head_fnam,head_fval) values(?,?,?,?)";
Connection con = JdbcUtil.getRecordConnection();
try {
con.setAutoCommit(false);
PreparedStatement ps = con.prepareStatement(sql);
for (DocHead dh : dhl) {
ps.setString(1, dh.getDoc_seq());
ps.setString(2, dh.getHead_seq());
ps.setString(3, dh.getHead_fnam());
ps.setString(4, dh.getHead_fval());
ps.executeUpdate();
}
con.commit();
} catch (SQLException e) {
try {
con.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
e.printStackTrace();
} finally {
JdbcUtil.closeConnection(con);
}
}