package com.ata.shoping.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.Iterator;
import java.lang.Integer;
import java.lang.Double;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class DoAdd extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		response.setCharacterEncoding("gb2312");
		PrintWriter out = response.getWriter();
		try{
			Myjdbc mydb = new Myjdbc();
			ArrayList<Category> al = new ArrayList<Category>();
			al = mydb.Select(" select * from Category");
			Iterator<Category> it = al.iterator();
			out.print("新添商品類型成功");
			out.print("<table cellSpacing=0 cellPadding=0 width=1100  border=0 height=45 bgcolor=\"#00ff00|\"><tr><td>類型ID</td><td>類型名</td><td>類型描述</td>");
			while(it.hasNext())
			{   
				Category lo = (Category)it.next();
				out.print("<tr><td> "+lo.getCid()+"</td><td> "+
						lo.getCname()+"</td><td> "+lo.getDescription()+"</td></tr>");
			}
			}catch(Exception e){
				e.printStackTrace();
			}
			String ncid=request.getParameter("cid");
			String ncname=request.getParameter("cname");
			String ndescription=request.getParameter("description");
			out.println(ncid+"\t"+ncname+"\t"+ndescription+"\n");
			try{
				Myjdbc mydb2 = new Myjdbc();
				ArrayList<Category> np= new ArrayList<Category>();
				Category npro=new Category();
		        npro.setCid(ncid);
		        npro.setCname(ncname);
		        npro.setDescription(ndescription);

		        np.add(npro);
		        String sql="insert into Category (cid,cname,description)value(?,?,?)";
		        mydb2.Insert(np, sql);
			}catch(Exception e){
				e.printStackTrace();
			}
	}

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

	}

}