albumservlet.java

仿校内网站

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package servlet;

import com.smartupload.SmartUpload;
import com.smartupload.SmartUploadException;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import myTools.DataBase;
import java.sql.*;
import java.util.Calendar;

import javax.servlet.ServletConfig;
import myTools.TimeMaker;
/**
 *
 * @author Administrator
 */
public class AlbumServlet extends HttpServlet {
    private ServletConfig config;
    final public void init(ServletConfig config) throws ServletException {
            this.config = config;
    }
    
    /** 
    * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
    * @param request servlet request
    * @param response servlet response
    */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        PrintWriter out = response.getWriter();
        String operation = request.getParameter("operation");
        System.out.println(operation);
        DataBase db = new DataBase();
        ResultSet rs = null;
        db.connectToDB();
        try {
            if(operation == null){
                System.out.println("The Albums Control Is Wrong");
            }else if(operation.equals("create_album")){
                String user_id = (String) request.getParameter("user_id");
                Calendar calCurrent=Calendar.getInstance(); 
                calCurrent.add(Calendar.HOUR_OF_DAY, 8);
                int intDay=calCurrent.get(Calendar.DATE); 
                int intMonth=calCurrent.get(Calendar.MONTH)+1; 
                int intYear=calCurrent.get(Calendar.YEAR); 
                int inthour = calCurrent.get(Calendar.HOUR_OF_DAY);
                int intmin = calCurrent.get(Calendar.MINUTE);
                int intsec = calCurrent.get(Calendar.SECOND);
                String time = intYear+"-"+intMonth+"-"+intDay+"-"+inthour+"-"+intmin+"-"+intsec;
                String album_name = new String(request.getParameter("album_name").getBytes("ISO-8859-1"),"gb2312");
                String sql = "insert into albums (user_id, album_name, album_date) values ('" + user_id + "', '" + album_name + "', '" + time + "')";
                db.executeUpdate(sql);
                response.sendRedirect("albums.jsp");
            }else if(operation.equals("add_photoes")){ 
                SmartUpload mySmartUpload = new SmartUpload();
                mySmartUpload.initialize(config, request, response);
		mySmartUpload.setMaxFileSize(1000000);
		mySmartUpload.setTotalMaxFileSize(2000000);
		mySmartUpload.setAllowedFilesList("jpg,JPG,bmp,BMP,gif,GIF");
		try {
			mySmartUpload.setDeniedFilesList("exe , bat ,jsp ,htm ,html");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			mySmartUpload.upload();
		} catch (SmartUploadException e) {
			e.printStackTrace();
		}
		String time = TimeMaker.getTime();
                String photo_description = mySmartUpload.getRequest().getParameter("photo_description");
                String album_id = mySmartUpload.getRequest().getParameter("album_id");
                String album_number = mySmartUpload.getRequest().getParameter("album_number");
                
                int number = Integer.parseInt(album_number);
                int image_num = 0;
                for(int j=0;j<mySmartUpload.getFiles().getCount();j++){
                    String imageName = mySmartUpload.getFiles().getFile(j).getFileName();
                    System.out.println(imageName);
                    image_num ++;
		    if(!imageName.equals("")){
                        String path = "photoes/"+ album_id + time + j + imageName;	
                        try {
                            mySmartUpload.getFiles().getFile(j).saveAs(path, mySmartUpload.SAVE_VIRTUAL);
                        } catch (SmartUploadException e) {
                            e.printStackTrace();
                        }
                        String sql_photo = "insert into photos(album_id, photo_date, photo_description, photo_path) values('" + album_id + "', '" + time + "', '" + photo_description+ "', '" + path + "')";
                        db.executeUpdate(sql_photo);
                    }
		}
                number += image_num;
                String sql_album = "update albums set album_number = " + number + " where album_id = " + album_id;
                db.executeUpdate(sql_album);
                response.sendRedirect("albums.jsp");
            }else if(operation.equals("delete_photo")){
                String photo_id = request.getParameter("photo_id");
                String album_id = request.getParameter("album_id");
                String album_number = request.getParameter("album_number");
                int number = Integer.parseInt(album_number)-1;
                String sql = "delete from photos where photo_id = " + photo_id;
                String sql1 = "update albums set album_number = " + number + " where album_id = " + album_id;
                db.executeUpdate(sql1);
                db.executeUpdate(sql);
                response.sendRedirect("albums.jsp");
            }
        } finally {
            db.close();
            out.close();
        }
    } 

    // <editor-fold defaultstate="collapsed" desc="HttpServlet 方法。单击左侧的 + 号以编辑代码。">
    /** 
    * Handles the HTTP <code>GET</code> method.
    * @param request servlet request
    * @param response servlet response
    */
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
    * Handles the HTTP <code>POST</code> method.
    * @param request servlet request
    * @param response servlet response
    */
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

    /** 
    * Returns a short description of the servlet.
    */
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}