public int gettopicid(String topic) {
String sql = "select topicid from topic where topic=?";
JdbcUtils db = new JdbcUtils();
db.getConnection();
List<Object> addparams = new ArrayList<Object>();
addparams.add(topic);
try {
return (int) db.getsimpleresult(sql, addparams).get("topicid");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return 0;
}
