基于JSP的医院挂号预约系统的设计与实现源码

package cc.zte.dao; import java.io.OutputStream; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import jxl.Workbook; import jxl.write.Label; import jxl.write.VerticalAlignment; import jxl.write.WritableCellFormat; import jxl.write.WritableFont; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import cc.zte.db.DBManager; import cc.zte.entity.Admin; import cc.zte.entity.Appointment; import cc.zte.entity.CurAppointment; import cc.zte.entity.Doctor; import cc.zte.entity.Orders; public class AdminDao extends DBManager{ //检查用户是否存在 public boolean checkAdmin(Admin admin){ boolean b = false; String sql = "select aid from Admin where uname = ? and upwd = ?"; this.setSql(sql); List param = new ArrayList(); param.add(admin.getUname()); param.add(admin.getUpwd()); this.setParam(param); try { rs = this.executeQuery(); if(rs.next()){ b = true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.closeAll(conn, pstmt, rs); } return b; } //操作excel public void printToExcel(List<Doctor> list,OutputStream os){ Label label = null; try { //打开文件 WritableWorkbook book = Workbook.createWorkbook(os); //生成名为‘医生信息表’的工作表，参数0为第一页 WritableSheet sheet = book.createSheet("医生信息表",0); //sheet.setColumnView(1,30); String[] titles = {"医生编号","姓名","性别","职称","年龄","特长","科室","电话"}; //标题字体加粗，TIMES字体，14号字 WritableFont font1 = new WritableFont(WritableFont.TIMES, 14 ,WritableFont.BOLD); WritableCellFormat format1 = new WritableCellFormat(font1); format1.setBackground(jxl.format.Colour.BROWN);//背景颜色 format1.setBorder(jxl.format.Border.TOP,jxl.format.BorderLineStyle.THICK); //居中对齐 format1.setAlignment(jxl.format.Alignment.CENTRE); //把垂直对齐方式指定为居中 format1.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE); //format1.setWrap(true); //字放不下一个单元格自动换行 sheet.setColumnView(0,15);//第一列宽度设为30 //设置单元格对齐(只保留居中，不设置字体大小，粗体) WritableCellFormat format2 = new WritableCellFormat(); format2.setAlignment(jxl.format.Alignment.CENTRE); //第一个for循环把表头添加到工作表中 for (int i = 0; i < titles.length; i++) { //在Label单元格，i从第0列开始，标题是第0行，titles[i]为内容 label = new Label(i,0,titles[i],format1); sheet.addCell(label);//把单元格添加到工作薄中 } //添加信息到工作表 for (int j = 0; j < list.size(); j++) { Doctor doctor = list.get(j); //System.out.println(list.get(j)); //format1.setAlignment(jxl.format.Alignment.CENTRE);//居中对齐 String[] cellContents = {doctor.getDid(),doctor.getName(),doctor.getSex(), doctor.getLevel(),"n"+doctor.getAge(),doctor.getSpecial(),doctor.getSection(),doctor.getPhone() }; for (int i = 0; i < cellContents.length; i++) { String content = cellContents[i]; if (content.startsWith("n")) {//处理数值型数据,如果以n开头 int price = Integer.parseInt(content.substring(1)); System.out.println(content.substring(1)); jxl.write.Number number = new jxl.write.Number(i,j+1,price,format2); sheet.addCell(number); }else{ //直接放入单元格 label = new Label(i,j+1,cellContents[i],format2); sheet.addCell(label); } } } //写入信息并关闭。 book.write(); book.close(); } catch (Exception e) { // TODO: handle exception } } //查询医生的方法 public List<Doctor> checkDoctor(){ List<Doctor> list = new ArrayList<Doctor>(); String sql = "select * from Doctor"; this.setSql(sql); rs = this.executeQuery(); Doctor d = null; try { while(rs.next()){ d = new Doctor(); d.setDid(rs.getString("did")); d.setPwd(rs.getString("pwd")); d.setName(rs.getString("name")); d.setSex(rs.getString("sex")); d.setAge(rs.getInt("age")); d.setLevel(rs.getString("level")); d.setSpecial(rs.getString("special")); d.setSection(rs.getString("section")); d.setPhone(rs.getString("phone")); this.setParam(param); list.add(d);//返回医生的集合 } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } //插入医生方法，要插入3个表 public int insertDoctor(Doctor doc,Appointment appointment,CurAppointment curAppointment){ String sql = "insert into Doctor values(?,?,?,?,?,?,?,?,?)"; List param = new ArrayList(); param.add(doc.getDid()); param.add(doc.getPwd()); param.add(doc.getName()); param.add(doc.getSex()); param.add(doc.getAge()); param.add(doc.getLevel()); param.add(doc.getSpecial()); param.add(doc.getSection()); param.add(doc.getPhone()); this.setParam(param); String sql1 = "insert into Appointment values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; List param1 = new ArrayList(); param1.add(appointment.getDid()); param1.add(appointment.getSuna()); param1.add(appointment.getSunp()); param1.add(appointment.getMona()); param1.add(appointment.getMonp()); param1.add(appointment.getTuea()); param1.add(appointment.getTuep()); param1.add(appointment.getWeda()); param1.add(appointment.getWedp()); param1.add(appointment.getThua()); param1.add(appointment.getThup()); param1.add(appointment.getFria()); param1.add(appointment.getFrip()); param1.add(appointment.getSata()); param1.add(appointment.getSatp()); String sql2 = "insert into CurAppointment values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; List param2 = new ArrayList(); param2.add(curAppointment.getDid()); param2.add(curAppointment.getSuna()); param2.add(curAppointment.getSunp()); param2.add(curAppointment.getMona()); param2.add(curAppointment.getMonp()); param2.add(curAppointment.getTuea()); param2.add(curAppointment.getTuep()); param2.add(curAppointment.getWeda()); param2.add(curAppointment.getWedp()); param2.add(curAppointment.getThua()); param2.add(curAppointment.getThup()); param2.add(curAppointment.getFria()); param2.add(curAppointment.getFrip()); param2.add(curAppointment.getSata()); param2.add(curAppointment.getSatp()); try { this.conn.setAutoCommit(false); this.setSql(sql); this.setParam(param); int a = this.executeUpdate(); this.setSql(sql1); this.setParam(param1); int b = this.executeUpdate(); this.setSql(sql2); this.setParam(param2); int c = this.executeUpdate(); this.conn.commit(); if(a>0&&b>0&&c>0){ return 1; }else{ this.conn.rollback(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); try { this.conn.rollback(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } }finally{ this.closeAll(conn, pstmt, rs); } return 0; } //删除医生 public boolean deleteDoctorInfo(String did){ String sql = "delete from Orders where did = ?";//删除预约表中医师相关信息 String sql2 = "delete from History where did = ?";//病历表 String sql3 = "delete from Appointment where did = ?";//当前预约表 String sql4 = "delete from CurAppointment where did = ?";//最大预约表 String sql5 = "delete from Doctor where did = ?";//最后doctor /*本次操作的参数相同，所以用一个参数集合*/ List <String> param = new ArrayList<String>