JSP增删改查.docx

将汉字转为可以识别的光标码 package com; import java.io.UnsupportedEncodingException; public class Change public static String changetoString(String str) String returnstr=null; try byte b=str.getBytes(ISO-8859-1); returnstr=new String(b,GBK); catch (UnsupportedEncodingException e) / TODO Auto-generated catch block e.printStackTrace(); return returnstr; 商品类 package com; public class Product private String product_id; private String product_name; private float product_price; public String getProduct_id() return product_id; public void setProduct_id(String product_id) duct_id = product_id; public String getProduct_name() return product_name; public void setProduct_name(String product_name) duct_name = product_name; public float getProduct_price() return product_price; public void setProduct_price(float product_price) duct_price = product_price; dao处理文件 package com; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; public class ProductDao public Connection conn() Connection conn=null; try Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); String URL=jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=chanpin;user=sa;password=sa; conn=DriverManager.getConnection(URL); catch (ClassNotFoundException e) e.printStackTrace(); catch(SQLException e) e.printStackTrace(); return conn; public List getUserList() List list=new ArrayList(); try Connection conn=this.conn(); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery(select * from product); while(rs.next() Product pro=new Product(); String product_id=rs.getString(product_id); pro.setProduct_id(product_id); String product_name=rs.getString(product_name); pro.setProduct_name(product_name); float product_price=rs.getFloat(product_price); pro.setProduct_price(product_price); list.add(pro); rs.close(); stmt.close(); this.close(conn); catch (SQLException e) e.printStackTrace(); return list; public Product selectone(String id) Product pro=new Product(); List list=new ArrayList(); try Connection conn=this.conn(); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery(select * from product where product_id=+id+); if(rs.next() pro.setProduct_name(rs.getString(2); pro.setProduct_price(rs.getFloat(3); rs.close(); stmt.close(); conn.close(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); return pro; public void delete(String product_id) Connection conn=this.conn(); try Statement stmt=conn.createStatement(); String sql=delete from product where product_id=+product_id+; stmt.executeUpdate(sql); stmt.close(); this.close(conn); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); public void insert(Product pro) String product_name=pro.getProduct_name(); float product_price=pro.getProduct_price(); Connection conn=this.conn(); try Statement stmt=conn.createStatement(); String sql=insert into product(product_name,product_price) values(+product_name+,+product_price+); stmt.executeUpdate(sql); stmt.close(); this.close(conn); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); public void update(Product pro) String product_id=pro.getProduct_id(); String product_name=pro.getProduct_name(); float product_price=pro.getProduct_price(); Connection conn=this.conn(); try Statement stmt=conn.createStatement(); String sql=update product set product_name=+product_name+,product_price=+product_price+ where product_id=+product_id+; stmt.executeUpdate(sql); stmt.close(); this.close(conn); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); public boolean search(String name) boolean i=false; Connection conn=this.conn(); try Statement stmt=conn.createStatement(); String sql=select * from product where product_name=+name+; ResultSet rs=stmt.executeQuery(sql); while(rs.next() i=true; rs.close(); stmt.close(); this.conn(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); return i; public List getnameList(String name) List list=new ArrayList(); try Connection conn=this.conn(); Statement stmt=conn.createStatement(); String sql=select * from product where product_name=+name+; ResultSet rs=stmt.executeQuery(sql); while(rs.next() Product pro=new Product(); String product_id=rs.getString(product_id); pro.setProduct_id(product_id); String product_name=rs.getString(product_name); pro.setProduct_name(product_name); float product_price=rs.getFloat(product_price); pro.setProduct_price(product_price); list.add(pro); rs.close(); stmt.close(); this.close(conn); catch (SQLException e) e.printStackTrace(); return list; public void close(Connection conn) try conn.close(); catch (SQLException e) e.printStackTrace(); servlet文件 package com; import java.io.IOException; import java.io.PrintWriter; import java.util.ArrayList; import java.util.List; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class Servlet extends HttpServlet public Servlet() super(); public void destroy() super.destroy(); public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException doPost(request,response); public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException String kind=request.getParameter(kind); /按条件查询 if(kind.equalsIgnoreCase(select) String product_name=Change.changetoString(request.getParameter(name); ProductDao pdao=new ProductDao(); boolean i=pdao.search(product_name); if(i=false) response.sendRedirect(./fit/notfind.jsp); else request.setAttribute(name123,product_name); RequestDispatcher rd = request.getRequestDispatcher(./fit/selectname.jsp); rd.forward(request,response); /插入信息 if(kind.equalsIgnoreCase(insert) String product_name =Change.changetoString(request.getParameter(name); float product_price = Float.valueOf(request.getParameter(price); List list = new ArrayList(); ProductDao pdao = new ProductDao(); list = pdao.getUserList(); Product pro = null; int i; for (i = 0; i list.size(); i+) pro = (Product) list.get(i); if (product_name.equalsIgnoreCase(pro.getProduct_name() response.sendRedirect(./fit/insert.jsp); break; else if(product_name=null) response.sendRedirect(./fit/insert.jsp); if(i=list.size() Product prod=new Product(); prod.setProduct_name(product_name); prod.setProduct_price(product_price); pdao.insert(prod); response.sendRedirect(./fit/select.jsp); /更新数据 if(kind.equalsIgnoreCase(update) Product pro = new Product(); pro.setProduct_id(request.getParameter(product_id); pro.setProduct_name(Change.changetoString(request.getParameter(product_name); pro.setProduct_price(Float.valueOf(request.getParameter(product_price); ProductDao pdao = new ProductDao(); pdao.update(pro); response.sendRedire