StringBuilder sql = new StringBuilder("SELECT ID,COMMAND,DESCRIPTION,CONTENT FROM message where 1= 1"); if(command!=null&&!"".equals(command.trim())) { sql.append(" and COMMAND = ? "); }
StringBuilder sql = new StringBuilder("SELECT ID,COMMAND,DESCRIPTION,CONTENT FROM message where 1= 1"); if(command!=null&&!"".equals(command.trim())) { sql.append(" and COMMAND = ? "); }