package servlet; 

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 java.sql.*;

import common.*;
/** 
 * @author 隋玉杰  E-mail: suiyj1158@hotmail.com
 * @version 創建時間：Nov 24, 2008 2:17:13 AM 
 * 類說明 
 */
public class AddFile extends HttpServlet {

	public AddFile() {
		super();
	}
	public void destroy() {
		super.destroy(); 
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("gbk");
		String c_id=request.getParameter("c_id");
		String bumen_id=request.getParameter("bumenid");
		String file_describe=request.getParameter("file_describe");//表單得到的軟件描述
		String file_name=request.getParameter("file_name");//表單得到的軟件名稱
		int type_id=Integer.parseInt(c_id);//把表單得到的String型的c_id轉換成int型
		Connection conn=DAO.getConnection();
		Statement stmt;
		try {
			stmt = conn.createStatement();
			int maxid=0;//一個int類型，為得到最大id作準備
			ResultSet rs=stmt.executeQuery("select max(c_id) from t_file");
			if(rs.next()){
				maxid=rs.getInt(1);
			}
			String sql="insert into t_file (c_id,c_name,c_describe,c_typeid,c_hits,c_jointime,c_lasttime,c_isdel,c_departid) values (?,?,?,?,0,getdate(),getdate(),1,?)";
			PreparedStatement ps=conn.prepareStatement(sql);
			ps.setInt(1,maxid+1);
			ps.setString(2,file_name);
			ps.setString(3,file_describe);
			ps.setInt(4,type_id);
			ps.setInt(5,Integer.parseInt(bumen_id));
			ps.executeUpdate();
			rs.close();
			ps.close();
			stmt.close();
			conn.close();
			response.sendRedirect("model/admin/adminindex.jsp?typeid="+type_id);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doGet(request, response);
	}

	
	public void init() throws ServletException {
	}

}