JSP+servlet二手书交易系统

package servlet; import java.io.IOException; import java.io.PrintWriter; import javax.mail.Session; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.ServletRequest; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import java.sql.Connection; import java.sql.PreparedStatement; import java.util.Calendar; import com.DB; import com.jspsmart.upload.*; public class UploadServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); PreparedStatement pstmt=null; Connection conn=null; String ext="", url="upload/"; SmartUpload su=new SmartUpload(); //创建新的上传对象 long maxsize=200*1024; //设置每个上传文件最大为200KB DB db=new DB(); try{ su.initialize(this.getServletConfig(), request, response); //初始化 su.setMaxFileSize(maxsize); //限制上传文件的大小 su.setAllowedFilesList("jpg,JPG,gif,GIF"); //设定允许上传的格式 su.upload(); //上传文件 Request req=su.getRequest(); //创建Request对象 String bookname=req.getParameter("bookname"); String pcount=req.getParameter("pcount"); String pinfo=req.getParameter("pinfo"); String price=req.getParameter("pprice"); //获取上传的文件，因为只上传了一个文件，所以可直接获取 com.jspsmart.upload.File myfile=su.getFiles().getFile(0); HttpSession session = request.getSession(); session.getAttribute("UserName");//获得session中的用户名 String Name=(String)session.getAttribute("UserName"); if(!myfile.isMissing()){ ext=myfile.getFileExt(); //取得扩展名 Calendar cal=Calendar.getInstance(); String filename=String.valueOf(cal.getTimeInMillis()); String saveurl=request.getRealPath("/")+url; saveurl+=filename+"."+ext; //saveurl为保存图片的绝对路径 //设置存到数据库中的路径 String cimage=url+filename+"."+ext; int cmark=0; String sql="insert into book_info(bkname,bk_price,bk_count,bk_info,bk_photos,username) values (?,?,?,?,?,?)"; conn=db.createConn(); conn.setAutoCommit(true); pstmt=conn.prepareStatement(sql); pstmt.setString(1,bookname); pstmt.setString(2,price); pstmt.setString(3,pcount); pstmt.setString(4,pinfo); pstmt.setString(5,cimage); pstmt.setString(6,Name); cmark=pstmt.executeUpdate(); if(cmark==1){ //将文件保存到指定目录中 myfile.saveAs(saveurl,SmartUpload.SAVE_PHYSICAL); /*session.setAttribute("msg1","添加成功！");*/ }else{ /*session.setAttribute("msg1","添加失败！");*/ } } }catch(Exception e){ e.printStackTrace(); response.setContentType("text/html"); PrintWriter out = response.getWriter(); out.println("图片不能大于200KB！"); }finally{ db.close(); try {pstmt.close();}catch(Exception e){} try {conn.close();}catch(Exception e){} } /*RequestDispatcher rd=request.getRequestDispatcher("bookmanage.jsp"); rd.forward(request,response);*/ response.setContentType("text/html;charset=UTF-8"); response.getWriter().write("3秒钟跳到主页"); //设置3秒钟跳转 response.setHeader("refresh", "3;url=bookmanage.jsp"); } }