超市系统的源代码.doc

/获得指定商品信息 public static String getRowStock(String id)String s=new String6;1.DBUtil_SM.class自定义了各种对数据操作的静态方法，包括对各个数据库的增删改查，其中对于user表中的删除仅能由权限2以上的管理人员执行，代码如下(手工编写)package paim;import java.sql.*;import java.util.*;import java.io.*;public class DBUtil_SM/获取用户信息public static List getVIPList()ArrayList vl=new ArrayList();try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=select id,name,age,sex,workuntil,tel,lvl,total from VIP_IM;ResultSet rs=st.executeQuery(sql);while(rs.next()String s=new String8;for(int i=0;is.length;i+)si=rs.getString(i+1);vl.add(s);rs.close();st.close();con.close();catch(Exception e)e.printStackTrace();return vl;/获取库存信息public static List getStockList()ArrayList sl=new ArrayList();try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=select id,name,price,count,vprice,type from stock order by type;ResultSet rs=st.executeQuery(sql);while(rs.next()String s=new String6;for(int i=0;is.length;i+)si=rs.getString(i+1); sl.add(s);rs.close();st.close();con.close();catch(Exception e)e.printStackTrace();return sl;/添加用户信息 public static void toInsertID(String s)try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=insert into VIP_IM values(+s0+,+s1+,+s2+,+s3+,+s4+,+s5+,+s6+,+s7+);st.executeUpdate(sql);st.close();con.close();catch(Exception e)e.printStackTrace();/删除用户信息 public static void toDelID(String id)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();st.executeUpdate(delete from VIP_IM where id=+id+);st.executeUpdate(delete from user where id=+id+);st.close();con.close();catch(Exception e)e.printStackTrace();/更新用户数据 public static void toUpdateID(String s)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=update VIP_IM set name=+s1+,age=+s2+,sex=+s3+,workuntil=+s4+,tel=+s5+,lvl=+s6+,total=+s7+ where id=+s0+;st.executeUpdate(sql);st.close();con.close();catch(Exception e)e.printStackTrace();/提取一个用户信息 public static String getRowID(String id)String s=new String8;tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();ResultSet rs=st.executeQuery(select id,name,age,sex,workuntil,tel,lvl,total from VIP_IM where id=+id+);if(rs.next()for(int i=0;is.length;i+)si=rs.getString(i+1);rs.close();st.close();con.close();catch(Exception e)e.printStackTrace();return s;/删除库存信息public static void toDelStock(String id)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();st.executeUpdate(delete from stock where id=+id+);st.close();con.close();catch(Exception e)e.printStackTrace();/添加库存信息public static void toInsertStock(String s)try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=insert into stock values(+s0+,+s1+,+s2+,+s3+,+s4+,+s5+);st.executeUpdate(sql);st.close();con.close();catch(Exception e)e.printStackTrace();/更新物品信息 public static void toUpdateStock(String s)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=update stock set name=+s1+,price=+s2+,count=+s3+,vprice=+s4+,type=+s5+ where id=+s0+;st.executeUpdate(sql);st.close();con.close();catch(Exception e)e.printStackTrace();tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();ResultSet rs=st.executeQuery(select id,name,price,count,vprice,type from stock where id=+id+);if(rs.next()for(int i=0;is.length;i+)si=rs.getString(i+1);rs.close();st.close();con.close();catch(Exception e)e.printStackTrace();return s;/用户登录 public static int getUser(String k)String s=new String4; int i=0;tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();ResultSet rs=st.executeQuery(select id,name,lit,psw from user where id=+k0+);if(rs.next()for(int j=0;js.length;j+)sj=rs.getString(j+1);i=5;elsereturn i;if(k1.equals(s3)if(s2.equals(1)i=1;elsei=2;elsei=3;rs.close();st.close();con.close();catch(Exception e)e.printStackTrace();return i;/修改密码public static void toUpdatePsw(String s)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=update user set psw=+s1+ where id=+s0+;st.executeUpdate(sql);st.close();con.close();catch(Exception e)e.printStackTrace();/获取积分列表 public static List getTotalList()ArrayList sl=new ArrayList();try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=select id,name,total from total order by total;ResultSet rs=st.executeQuery(sql);while(rs.next()String s=new String3;for(int i=0;is.length;i+) si=rs.getString(i+1); sl.add(s);rs.close();st.close();con.close();catch(Exception e)e.printStackTrace();return sl;/获取商品积分 public static int getTotalS(String id)int t=0;try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=select total from total where id=+id+;ResultSet rs=st.executeQuery(sql);if(rs.next()t=rs.getInt(1);rs.close();st.close();con.close();catch(Exception e)e.printStackTrace();return t;/获取用户积分 public static int getTotalV(String id)int t=0;try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=select total from VIP_IM where id=+id+;ResultSet rs=st.executeQuery(sql);if(rs.next()t=rs.getInt(1);rs.close();st.close();con.close();catch(Exception e)e.printStackTrace();return t;/获取积分商品名称 public static String getTotalName(String id)String t=;try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=select name from total where id=+id+;ResultSet rs=st.executeQuery(sql);if(rs.next()t=rs.getString(1);rs.close();st.close();con.close();catch(Exception e)e.printStackTrace();return t;/积分兑换表 public static void addList(String s)try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=insert into totallist(id,name,ltotal,tname,ttotal) values(+s0+,+s1+,+s2+,+s3+,+s4+);st.executeUpdate(sql);st.close();con.close();catch(Exception e)e.printStackTrace();/用户消费记录 public static List getIDTotal(String id)ArrayList sl=new ArrayList();try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=select id,name,ltotal,tname,ttotal from totallist where id=+id+;ResultSet rs=st.executeQuery(sql);while(rs.next()String s=new String5;for(int i=0;is.length;i+) si=rs.getString(i+1); sl.add(s);rs.close();st.close();con.close();catch(Exception e)e.printStackTrace();return sl;/用户账户插入 public static void toInsertUser(String s)try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=insert into user values(+s0+,+s1+,+s2+,+s3+);st.executeUpdate(sql);st.close();con.close();catch(Exception e)e.printStackTrace();/积分物品添加 public static void addTotal(String s)try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=insert into total values(+s0+,+s1+,+s2+);st.executeUpdate(sql);st.close();con.close();catch(Exception e)e.printStackTrace();/更新积分物品信息 public static void toUpdateTotal(String s)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=update total set name=+s1+,total=+s2+ where id=+s0+;st.executeUpdate(sql);st.close();con.close();catch(Exception e)e.printStackTrace();/删除积分物品信息 public static void toDelTotal(String id)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();st.executeUpdate(delete from total where id=+id+);st.close();con.close();catch(Exception e)e.printStackTrace();/获取积分列表 public static String getTotalListS(String id)String s=new String3;try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,);Statement st=con.createStatement();String sql=select id,name,total from total where id=+id+;ResultSet rs=st.executeQuery(sql);while(rs.next()for(int i=0;is.length;i+) si=rs.getString(i+1); rs.close();st.close();con.close();catch(Exception e)e.printStackTrace();return s;2.SMServlet.class用于响应jsp请求根据情况调用DBUtil_SM中的方法，返回结果，代码如下(手工编写)package paim;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;public class SMServlet extends HttpServletOverridepublic void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletExceptiondoPost(request,response);Overridepublic void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletExceptionString action=request.getParameter(action);if(action.equals(del_id)/删除用户String id=request.getParameter(id);DBUtil_SM.toDelID(id);request.getRequestDispatcher(/admin.jsp).include(request,response);if(action.equals(add_id)/添加用户 String s=new String9; if(request.getParameter(id)!=null) s0= new String(request.getParameter(id).getBytes(ISO8859_1), GB2312);if(request.getParameter(name)!=null) s1 = new String(request.getParameter(name).getBytes(ISO8859_1), GB2312);if(request.getParameter(age)!=null) s2 = new String(request.getParameter(age).getBytes(ISO8859_1), GB2312); if(request.getParameter(sex)!=null) s3 = new String(request.getParameter(sex).getBytes(ISO8859_1), GB2312); if(request.getParameter(workuntil)!=null) s4 = new String(request.getParameter(workuntil).getBytes(ISO8859_1), GB2312); if(request.getParameter(tel)!=null) s5= new String(request.getParameter(tel).getBytes(ISO8859_1), GB2312);if(request.getParameter(lvl)!=null) s6= new String(request.getParameter(lvl).getBytes(ISO8859_1), GB2312);if(request.getParameter(total)!=null) s7= new String(request.getParameter(total).getBytes(ISO8859_1), GB2312);if(request.getParameter(psw)!=null) s8= new String(request.getParameter(psw).getBytes(ISO8859_1), GB2312);String g=new String2;g0=s0;g1=s8;if(DBUtil_SM.getUser(g)!=0)/返回0即不存在用户request.getRequestDispatcher(/useradd.jsp?str=1). include(request,response);elseString user=new String4;user0=s0;user1=s1;user2=1;user3=s8;DBUtil_SM.toInsertID(s);DBUtil_SM.toInsertUser(user); request.getRequestDispatcher(/admin.jsp). include(request,response);if(action.equals(update_id)/修改用户信息String lit=request.getParameter(lim); String s=new String8; s0=request.getParameter(id);if(request.getParameter(name)!=null) s1 = new String(request.getParameter(name).getBytes(ISO8859_1), GB2312);if(request.getParameter(age)!=null) s2 = new String(request.getParameter(age).getBytes(ISO8859_1), GB2312); if(request.getParameter(sex)!=null) s3 = new String(request.getParameter(sex).getBytes(ISO8859_1), GB2312); if(request.getParameter(workuntil)!=null) s4 = new String(request.getParameter(workuntil).getBytes(ISO8859_1), GB2312); if(request.getParameter(tel)!=null) s5= new String(request.getParameter(tel).getBytes(ISO8859_1), GB2312);if(request.getParameter(lvl)!=null) s6= new String(request.getParameter(lvl).getBytes(ISO8859_1), GB2312); if(request.getParameter(total)!=null) s7= new String(request.getParameter(total).getBytes(ISO8859_1), GB2312); DBUtil_SM.toUpdateID(s);if(lit.equals(use)/根据用户权限显示页面request.getRequestDispatcher(/userlist.jsp?id=+s0). include(request,response);elserequest.getRequestDispatcher(/admin.jsp). include(request,response);if(action.equals(del_stock)/删除物品String id=request.getParameter(id);DBUtil_SM.toDelStock(id);request.getRequestDispatcher(/admin.jsp).include(request,response);if(action.equals(add_stock)/添加物品信息String s=new String6; if(request.getParameter(id)!=null) s0 = new String(request.getParameter(id).getBytes(ISO8859_1), GB2312);if(request.getParameter(name)!=null) s1 = new String(request.getParameter(name).getBytes(ISO8859_1), GB2312);if(request.getParameter(price)!=null) s2 = new String(request.getParameter(price).getBytes(ISO8859_1), GB2312); if(request.getParameter(count)!=null) s3= new String(request.getParameter(count).getBytes(ISO8859_1), GB2312); if(request.getParameter(vprice)!=null) s4 = new Str