java连接mysql查询操作

//查询操作
	public ArrayList<Student> queryStudent(String sname){
		//经常的插入删除用LinkedList，显示的话用ArrayList
		ArrayList<Student> students=new ArrayList<Student>();
		DBConnection db=new DBConnection();
		ResultSet rs=null;
		PreparedStatement preStmt=null;
		try {
			preStmt=db.getConn().prepareStatement("select * from student where sname like ?");
			preStmt.setString(1, "%"+sname+"%");
			rs=preStmt.executeQuery();
			while(rs.next()){
				Student student=new Student();
				student.setSname(rs.getString("sname"));
				student.setSid(rs.getString("sid"));
				student.setSaddress(rs.getString("saddress"));
				student.setSlikes(rs.getString("slikes"));
				
				students.add(student);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return students;
	}