struts 框架应用案列--图书管理系统

package com.accp.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.accp.dao.StudentDao; import com.accp.entity.Student; import com.accp.util.BaseDao; public class StudentDaoImpl extends BaseDao implements StudentDao { public List<Student> findStudentAll() throws ClassNotFoundException, SQLException { //返回 List<Student> list = new ArrayList<Student>(); //创建连接 Connection conn = GetConnection(); //准备sql String sql = "select * from student where 1=1"; //创建处理器 PreparedStatement pstm = conn.prepareStatement(sql); //执行 ResultSet rs = pstm.executeQuery(); // while(rs.next()) { Student student = new Student(); student.setStuid(rs.getInt("stuid")); student.setStuNo(rs.getString("stuNo")); student.setStuname(rs.getString("stuname")); student.setStupass(rs.getString("stupass")); student.setStustate(rs.getInt("stustate")); list.add(student); } //释放资源 CloseALL(rs, pstm, conn); return list; } @SuppressWarnings("unchecked") public Student findStudentByStudent(Student stu) throws ClassNotFoundException, SQLException { //创建返回对象 Student student = null; //创建连接 Connection conn = GetConnection(); //准备sql String sql = "select * from student where 1=1"; //参数 List list = new ArrayList(); // if(stu.getStuid()!=null&&stu.getStuid()!=0) { sql += " and stuid=?"; list.add(stu.getStuid()); } if(stu.getStuNo()!=null&&!"".equals(stu.getStuNo())) { sql += " and stuNo=?"; list.add(stu.getStuNo()); } if(stu.getStuname()!=null&&!"".equals(stu.getStuname())) { sql += " and stuname=?"; list.add(stu.getStuname()); } if(stu.getStupass()!=null&&!"".equals(stu.getStupass())) { sql += " and stupass=?"; list.add(stu.getStupass()); } if(stu.getStustate()!=null&&stu.getStustate()!=0) { sql += " and stustate=?"; list.add(stu.getStustate()); } //创建处理器 PreparedStatement pstm = conn.prepareStatement(sql); //设置参数 for(int i=0;i<list.size();i++) { pstm.setObject(i+1, list.get(i)); } //执行 ResultSet rs = pstm.executeQuery(); // if(rs.next()) { student = new Student(); student.setStuid(rs.getInt("stuid")); student.setStuNo(rs.getString("stuNo")); student.setStuname(rs.getString("stuname")); student.setStupass(rs.getString("stupass")); student.setStustate(rs.getInt("stustate")); } //释放资源 CloseALL(rs, pstm, conn); return student; } @SuppressWarnings("unchecked") public boolean insertStudent(Student stu) throws ClassNotFoundException, SQLException { // 参数 List list = new ArrayList(); // 准备sql String sql = "insert into student values(?,?,?,?)"; // list.add(stu.getStuNo()); list.add(stu.getStuname()); list.add(stu.getStupass()); list.add(stu.getStustate()); return update(sql, list); } @SuppressWarnings("unchecked") public boolean updateStudent(Student stu) throws ClassNotFoundException, SQLException { // if (stu.getStuid() == null || stu.getStuid() == 0) { return false; } // 参数 List list = new ArrayList(); // 准备sql String sql = "update student set"; if (stu.getStuname() != null && !"".equals(stu.getStuname())) { sql += " stuname=?,"; list.add(stu.getStuname()); } if (stu.getStupass() != null && !"".equals(stu.getStupass())) { sql += " stupass=?,"; list.add(stu.getStupass()); } if (stu.getStustate() != null && stu.getStustate() != 0) { sql += " stustate=?,"; list.add(stu.getStustate()); } // sql += " stuNo=stuNo where stuid=?"; list.add(stu.getStuid()); // return update(sql, list); } }