?? doadd.java
字號:
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);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -