阅读背景:

jdbc查询数据库时重复最后一条记录

来源:互联网 
!-- flowchart 箭头图标 勿删 --
	public List<JavaQuestion> getAllJavaQuestion() {
		Connection con = null;
		PreparedStatement pre = null;
		ResultSet re = null;
		List<JavaQuestion> list1 = new ArrayList<>();
		con = JDBCutil.getCon();
			String sql = "select *from javaquestion";
			JavaQuestion javaQuestion = new JavaQuestion();
			try {
				pre = con.prepareStatement(sql);
				re = pre.executeQuery();
				while(re.next()) {
					String titltNumber = re.getString("titlenumber");
					String title = re.getString("title");
					String answer = re.getString("answer");
					javaQuestion.setAnswer(answer);
					javaQuestion.setTitltNumber(titltNumber);
					javaQuestion.setTitle(title);
					list1.add(javaQuestion);
					
				}
				
			} 
			catch (SQLException e) {
				
			}
		return list1;
	}
	public Li



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: