PreparedStatement中使用like

String sql = "SELECT a.title,a.content FROM poetries a WHERE a.title LIKE ?";PreparedStatement prep = conn.prepareStatement(sql);prep.setString(1, "%"+poetries.getTitle()+"%");ResultSet result = prep.executeQuery();