package bdqn.studentSys.Dao.impl; /**** 學生表的數據庫操作類*/ import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List;import bdqn.studentSys.Dao.BaseDao; import bdqn.studentSys.Dao.StudentDao; import bdqn.studentSys.entity.Student;public class StudentDaoImpl extends BaseDao implements StudentDao {//查詢全部public List<Student> getAllStudent() {// TODO Auto-generated method stubList<Student> studentlist=new ArrayList<Student>();String sql="select * from Student";try {ResultSet rs=executeQurey(sql, null);while(rs.next()){Student stu=new Student();stu.setName(rs.getString(1));stu.setPwd(rs.getString(2));stu.setAge(rs.getInt(3));stu.setSex(rs.getString(4));studentlist.add(stu);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{closeAll();}return studentlist;}//修改public int UpdateStudent(Student stu) {// TODO Auto-generated method stubint rel=0;String sql="update Student set name=?,pwd=?,age=?,sex=? where stuno=?";Object[]prams={stu.getName(),stu.getPwd(),stu.getAge(),stu.getSex(),stu.getStuno()};try {rel=executeUpdate(sql, prams);} catch (SQLException e) {e.printStackTrace();}finally{closeAll();}return rel;}//添加public int addStudent(Student stu) {int rel=0;String sql="insert Student (name,pwd,age,sex) values(?,?,?,?)";Object []prams={stu.getName(),stu.getPwd(),stu.getAge(),stu.getSex()};try {rel=executeUpdate(sql, prams);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{closeAll();}return rel;}//刪除public int delStudent(int stuno) {int rel=0;String sql="delete from Student where studentno=?";Object[]prams={stuno};try {rel=executeUpdate(sql, prams);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{closeAll();}return rel;}}

總結

以上是生活随笔為你收集整理的java面向对象高级分层实例_数据库操作类的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。