JSP增删改查.docxVIP

将汉字转为可以识别的光标码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 pro