//查询操作
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;
}
java连接mysql查询操作
最新推荐文章于 2024-05-27 02:47:55 发布