java面向对象高级分层实例_数据库操作类

来源：互联网发布：网络电视机顶盒直播软件哪个好编辑：程序博客网时间：2024/06/05 21:25
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;}}
1 0