List<Message> messageList = new ArrayList<Message>();

try {

Class.forName("com.mysql.jdbc.Driver");

Connection connection;

connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/micro_message","root","root");

StringBuilder sql = new StringBuilder("select id,command,desription,content from message where 1=1");

List<String> paramList = new ArrayList<String>();

if(command != null && !"".equals(command.trim())){

sql.append("and command=?");

paramList.add(command);

}

if(desription != null && !"".equals(desription.trim())){

sql.append("and desription like '%' ? '%' ");

paramList.add(desription);

}

PreparedStatement statement = connection.prepareStatement(sql.toString());

for(int i=0;i<paramList.size();i++){

statement.setString(i + 1,paramList.get(i));

}

ResultSet rs = statement.executeQuery();

Message message = new Message();

while(rs.next()){

message.setId(rs.getString("id"));

message.setCommand(rs.getString("command"));

message.setDesription(rs.getString("desription"));

message.setContent(rs.getString("content"));

messageList.add(message);

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

}catch (SQLException e) {

e.printStackTrace();

}

return messageList;