81,094
社区成员
发帖
与我相关
我的任务
分享
请用代码格式帮助别人阅读代码
public void insertMessageInfo(Assets m) {
String sql = "insert into XAS_Assets (FUser,FNumber,FName,Famount,FAssetsAcctType,FAssetsType,FAssetsState,FLocation,FDepartment,FMemo,FClear,FCpu)values(?,?,?,?,?,?,?,?,?,?,?,?)";
DBBean db = new DBBean();
System.out.print("insertsql="+sql);
PreparedStatement pstmt = null;
try {
db.connect();
db.con.setAutoCommit(false);//----更改JDBC事务的默认提交方式
pstmt = db.con.prepareStatement(sql);
pstmt.setString(1, m.getFNumber());
pstmt.setString(2,m.getFUser());
pstmt.setString(3, m.getFName());
pstmt.setInt(4,m.getFAmount());
pstmt.setString(5, m.getFAssetsAcctType());
pstmt.setString(6, m.getFAssetsType());
pstmt.setString(7, m.getFAssetsState());
pstmt.setString(8, m.getFDepartment());
pstmt.setString(9, m.getFLocation());
pstmt.setString(10, m.getFMemo());
pstmt.setInt(11, m.getFClear());
pstmt.setString(12, m.getFCpu());
pstmt.executeUpdate();
con.commit();//提交JDBC事务
con.setAutoCommit(true);// 恢复JDBC事务的默认提交方式
} catch (Exception e) {
System.out.println(e);
} finally {
db.close();
}
}