mysql原始jdbc查詢例子，返回資料列表

標籤：列表   arraylist   amp   content   dstat   des   print   connect   auto   

//根據查詢條件查詢訊息列表public List<Message> queryMessageList(String command,String description){List<Message> messageList = new ArrayList<Message>();try {Class.forName("com.mysql.jdbc.Driver");//1.載入資料庫驅動Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/micro_message", "root", "root");//2.擷取連線物件StringBuilder sql = new StringBuilder("select ID,COMMAND,DESCRIPTION,CONTENT from message where 1=1");List<String> paramList = new ArrayList<String>();//拼接sql語句if(command!=null&&!"".equals(command.trim())){sql.append(" and COMMAND=?");paramList.add(command);}if(description!=null&&!"".equals(description.trim())){sql.append(" and DESCRIPTION like ‘%‘ ? ‘%‘");//mysql字串拼接用空格拼，傳進佔位符處的參數和%拼接到一塊paramList.add(description);}//3.先行編譯SQL語句PreparedStatement statement = conn.prepareStatement(sql.toString());//4.填充預留位置for(int i = 0;i < paramList.size(); i++){statement.setString(i+1,paramList.get(i));}//5.查詢資料庫ResultSet rs = statement.executeQuery();//6.遍曆出所有資料while(rs.next()){Message message = new Message();messageList.add(message);message.setId(rs.getString("ID"));message.setCommand(rs.getString("COMMAND"));message.setDescription(rs.getString("DESCRIPTION"));message.setContent(rs.getString("CONTENT"));}} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}catch (SQLException e){e.printStackTrace();}return messageList;}

 

mysql原始jdbc查詢例子，返回資料列表