publicVectorsearchMemInfo_theme(Stringtheme){//TODOAuto-generatedmethodstubLog.log(this,"searchMemInfo_theme");Connectionconn=null;PreparedStatementstmt=null;Resu...
public Vector searchMemInfo_theme(String theme) {
// TODO Auto-generated method stub
Log.log(this, "searchMemInfo_theme");
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
Vector v = null;
Vector meminfo = new Vector();
try {
conn = Dbcp.getConnection();
stmt = conn.prepareStatement(Constants.QUERY_MEMORANDUM_THEME);
stmt.setString(1, "'%"+theme+"%'");
Log.log(this, "'%"+theme+"%'");
rs = stmt.executeQuery();
while(rs.next()){
Log.log(this, "MemDao:");
v = new Vector();
v.add(rs.getInt("M_NUM"));
v.add(rs.getString("M_THEME"));
v.add(rs.getString("M_CONTENT"));
v.add(rs.getString("M_WEEK"));
v.add(rs.getTimestamp("M_TIME"));
meminfo.add(v);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
Dbcp.close(rs,stmt, conn);
Log.log( this, "savememinfo:"+Constants.QUERY_MEMORANDUM_THEME);
}
return meminfo;
}
展开