Struts2+Hibernate学生成绩管理系统

import java.util.*; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import java.sql.Blob; import java.sql.SQLException; import oracle.sql.BLOB; import org.apache.struts2.ServletActionContext; import org.hibernate.Hibernate; import org.hibernate.LockMode; import hibernate.*; import com.opensymphony.oscache.web.filter.ResponseContent; import com.opensymphony.xwork2.Action; import com.opensymphony.xwork2.ActionSupport; import java.io.*; import jxl.Workbook; import jxl.write.*; import jxl.write.biff.RowsExceededException; public class showInfoAction extends ActionSupport { String stuid; String phostuid; Student s=new Student(); StudentDAO sdao=new StudentDAO(); Stuphoto sphoto = new Stuphoto(); StuphotoDAO sphotodao = new StuphotoDAO(); File photofordis=new File("E:\\123.jpg"); InputStream ips; InputStream excelStream; File upload; private String uploadContentType; private String uploadFileName; private String inputPathexp = new String(); private String fileNameexp = new String(); public String getStuid() { return stuid; } public void setStuid(String stuid) { this.stuid = stuid; } public Student getS() { return s; } public void setS(Student s) { this.s = s; } public String delStudent() throws Exception { // TODO Auto-generated method stub //s = sdao.findById(id); sdao.delete(sdao.findById( stuid )); sdao.getSession().beginTransaction().commit(); System.out.println("删除学生信息（除照片）成功"); try { if (sphotodao.findById(stuid)!=null) { sphotodao.delete(sphotodao.findById(stuid)); } sphotodao.getSession().beginTransaction().commit(); System.out.println("删除照片成功"); } catch (Exception e) { e.printStackTrace(); } System.out.println("删除成功"); this.addActionMessage("<script>alert('删除成功');</script>"); return "success"; } public String updateStudent() throws Exception { // TODO Auto-generated method stub s = sdao.findById(stuid); System.out.println("输出2"); System.out.println("输出2"); System.out.println("输出2"); System.out.println("输出2"); System.out.println(stuid); return "success"; } public String realUpdateStudent() throws Exception { // TODO Auto-generated method stub //sinfo = sinfodao.findById(id); System.out.println("真正更新输出"); System.out.println("真正更新输出"); System.out.println("真正更新输出"); System.out.println(stuid); System.out.println(s.getNameword()); System.out.println(s.getStuid()); s.setStuid(stuid); System.out.println(s.getStuid()); System.out.println(s.getNameword()); //sinfo = sinfodao.findById(id); System.out.println(s.getName()); //sinfodao.findb //System.out.println(sinfo.getId()); sdao.merge(s); sdao.getSession().beginTransaction().commit(); System.out.println("真正更新学生信息成功（除了照片）"); if(upload!=null) { // System.out.println("更新照片的类型和路径："+uploadContentType); // System.out.println(uploadFileName); // // //sphoto=new Stuphoto(); // // System.out.println(sphoto.getStuid()); // sphoto.setStuid(stuid); // System.out.println(sphoto.getStuid()); // if(sphoto.getPhoto()==null) // { // System.out.println("sphoto.getPhoto为空！"); // } // else // { // System.out.println("sphoto.getPhoto不为空！"); // } // // sphoto.setPhoto(Hibernate.createBlob( new byte[1] )); // sphotodao.getSession().flush(); // sphotodao.getSession().refresh ( sphoto, LockMode.UPGRADE ); // sphotodao.merge(sphoto); //// sphotodao.getSession().close(); // // System.out.println("更新前sphoto清空了"); // //// BLOB blo=(BLOB) sphoto.getPhoto(); // //// System.out.println("获得sphoto的blob"); // // try { // //// sphoto.setPhoto(Hibernate.createBlob( new byte[65535] )); // if(sphoto.getPhoto()==null) // { // System.out.println("sphoto.getPhoto为空！"); // } // else // { // System.out.println("sphoto.getPhoto不为空！"); // } // if (sphoto.getPhoto().getBinaryStream()==null) { // System.out.println("sphoto.getPhoto().getBinaryStream()为空"); // } // else // { // System.out.println("sphoto.getPhoto.getBinaryStream()不为空！"); // } //// OutputStream out =sphoto.getPhoto().setBinaryStream(0); // FileInputStream in = new FileInputStream(getUpload()); // Blob bl=sphoto.getPhoto(); // System.out.println(bl.length()); // OutputStream out =bl.setBinaryStream(0); // // byte[] b = new byte[1024]; // int len; // // if(in!=null) // { // System.out.println("更新前in不为空"); // } // if(out!=null) // { // System.out.println("更新前out不为空"); // } // // while ( ( len = in.read ( b ) ) > 0 ) // { // out.write ( b, 0, len ); // } // // in.close(); // out.close(); // // sphotodao.merge(sphoto); // sphotodao.getSession().beginTransaction().commit(); // // System.out.println("更新后的照片存入数据库成功！"); // } catch (Exception e) { // e.printStackTrace(); // System.out.println("更新后的照片存入数据库失败！"); // } if (sphotodao.findById(stuid)!=null) { sphotodao.delete(sphotodao.findById(stuid)); sphotodao.getSession().beginTransaction().commit(); System.out.println("更新时删除照片成功"); } sphoto.setStuid(this.getStuid()); sphoto.setPhoto(Hibernate.createBlob( new byte[1] )); sphotodao.save(sphoto); sphotodao.getSession().flush(); sphotodao.getSession().refresh ( sphoto, LockMode.UPGRADE ); // sphotodao.getSession().close(); System.out.println("更新时sphoto清空了"); // BLOB blo=(BLOB) sphoto.getPhoto(); // System.out.println("获得sphoto的blob"); try { OutputStream out =sphoto.getPhoto().setBinaryStream(0); FileInputStream in = new FileInputStream(getUpload()); byte[] b = new byte[1024]; int len; if(in!=null) { System.out.println("in不为空"); } if(out!=null) { System.out.println("out不为空"); } while ( ( len = in.read ( b ) ) > 0 ) { out.write ( b, 0, len ); } in.close(); out.close(); sphotodao.getSession().save(sphoto); sphotodao.getSession().beginTransaction().commit(); System.out.println("更新时照片存入数据库成功！"); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("更新时照片存入数据库失败！"); } } else { System.out.println("照片未更新！"); } this.addActionMessage("<script>alert('更新成功');</script>"); return "success"; } // public InputStream getImg() throws Exception { // // // sphoto=sphotodao.findById(phostuid); // // byte[] bs = sphoto.getPhoto().getBytes(0, (int) sphoto.getPhoto().length()); // // return sphoto.getPhoto().getBinaryStream(); // // } public String getInputStream() { // Photo photo = new Photo(); // // try // { // photo = pdi.getPhoto ( filename );//注入spring获取数据库图片对象 // } // catch ( RuntimeException e ) // { // e.printStackTrace(); // } // // //System.out.println("FileName:"+photo.getOrdernum()); // if ( photo == null || photo.getPhoto() == null ) // { // return null; // } // else // { // // System.out.println(photo.getOrdernum()); // // System.out.println(photo.getPhoto()); // return new ByteArrayInputStream ( photo.getPhoto() ); // } System.out.println("显示图片前！"); System.out.println(stuid); sphoto=sphotodao.findById(stuid); try { System.out.println("获得InputStream前"); ips=sphoto.getPhoto().getBinaryStream(); if (ips!=null) { Syste