public static void updateInfoState(Context ctx, String id,//id:表fid,StateField:字段名,state:状态字段
String StateField, int state) throws SQLDataException, BOSException {
IMetaDataLoader metaData = MetaDataLoaderFactory
.getLocalMetaDataLoader(ctx);
String tableName = metaData.getEntity(BOSUuid.read(id).getType())
.getTable().getName();
String sql = "UPDATE " + tableName + " SET " + StateField
+ "=? WHERE FID=?";
Connection con = null;
PreparedStatement pstmt = null;
try {
con = EJBFactory.getConnection(ctx);
pstmt = con.prepareStatement(sql);
pstmt.setInt(1, state);
pstmt.setString(2, id);
pstmt.executeUpdate();
} catch (SQLException e) {
} finally {
SQLUtils.cleanup(pstmt, con);
}
}
EAS SHR:根据ctx取表名
最新推荐文章于 2020-05-24 19:19:43 发布