/** * 新增申成知道提问 * * @param cloudKnowAsk * @throws Exception */ public static void insertCloudKnowAsk(CloudKnowAsk cloudKnowAsk) throws Exception { String sql = "insert into cloud_know_ask(id,user_id,question,description,type,urgent,state," + "create_date,create_time,create_ip,update_date,update_time,update_ip) values " + "(null," + cloudKnowAsk.getUserId() + ",'" + cloudKnowAsk.getQuestion() + "','" + cloudKnowAsk.getDescription() + "','" + cloudKnowAsk.getType() + "'," + cloudKnowAsk.getUrgent() + "," + cloudKnowAsk.getState() + ",'" + cloudKnowAsk.getCreateDate() + "','" + cloudKnowAsk.getCreateTime() + "','" + cloudKnowAsk.getCreateIp() + "','" + cloudKnowAsk.getUpdateDate() + "','" + cloudKnowAsk.getUpdateTime() + "','" + cloudKnowAsk.getUpdateIp() + "')"; DB.executeUpdate(sql); cloudKnowAsk.setId(getMaxIdByUserId(cloudKnowAsk.getUserId())); }
/** * 更新申成知道提问 * * @param cloudKnowAsk * @throws Exception */ public static void updateCloudKnowAsk(CloudKnowAsk cloudKnowAsk) throws Exception { String sql = "update cloud_know_ask set question='" + cloudKnowAsk.getQuestion() + "',description='" + cloudKnowAsk.getDescription() + "',type='" + cloudKnowAsk.getType() + "',urgent=" + cloudKnowAsk.getUrgent() + ",state=" + cloudKnowAsk.getState() + ",update_date='" + cloudKnowAsk.getUpdateDate() + "',update_time='" + cloudKnowAsk.getUpdateTime() + "',update_ip='" + cloudKnowAsk.getUpdateIp() + "' where id=" + cloudKnowAsk.getId(); DB.executeUpdate(sql); }