package servlet; 

import java.io.IOException;
import java.sql.*;

import common.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/** 
 * @author 隋玉杰  E-mail: suiyj1158@hotmail.com
 * @version 創建時間：Nov 19, 2008 9:21:20 AM 
 * 加一個分類
 */
public class add_type extends HttpServlet {
	public add_type() {
		super();
	}
	public void destroy() {
		super.destroy(); 
	}
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("GBK");
		int fid = Integer.parseInt(request.getParameter("typeid"));
		String type_name = request.getParameter("type_name");
		String type_describe = request.getParameter("type_describe");
		int msg = 0;
		if (type_name != null) {
			int id = 0;
			Connection conn = DAO.getConnection();
			Statement stmt;
			try {
				stmt = conn.createStatement();
			java.sql.ResultSet rs = stmt
			.executeQuery("select max(c_id) from t_type");
			if (rs.next()) {
				id = rs.getInt(1);
			}
			String sql = "insert into t_type (c_id,c_type_name,c_fid,c_describe,c_isdel) values (?,?,?,?,1)";
			PreparedStatement ps = conn.prepareStatement(sql);
			ps.setInt(1, id + 1);
			ps.setString(2, type_name);
			ps.setInt(3, fid);
			ps.setString(4, type_describe);
			ps.executeUpdate();
			String realpath = request.getRealPath("/")
			+ GetUrl.geturl(id + 1);
			FileOperate fo = new FileOperate();
			if (!fo.checkFolder(realpath)) {
				sql = "delete from t_type where c_id=" + (id + 1);
				stmt.executeUpdate(sql);
				msg = 1;
			}
			ps.close();
			rs.close();
			stmt.close();
			conn.close();
			fo.createFolder(realpath);
			} catch (SQLException e) {
				e.printStackTrace();
			}
			if (msg == 1) {
				request.getSession().setAttribute("error", "aaa");
				response.sendRedirect("model/admin/add_type.jsp?typeid=" + fid);
			}else
				request.getSession().setAttribute("ok", "aaa");
			response.sendRedirect("model/admin/adminindex.jsp?typeid=" + fid);
		}
	}
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doGet(request, response);
	}
	public void init() throws ServletException {
	}

}