超系统的源代码

1、 /获得指定商品信息 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 getV

2、IPList() 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.

3、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); Con

4、nection 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)

5、; 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(); VIP_IM String sq

6、l=insert into 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) try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con=DriverManager.getConnection(jdbc:odbc:d

7、bsm,); 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) try Class.forName(sun.jdbc.odbc.JdbcOdbcDr

8、iver); Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,); Statement st=con.createStatement(); set String sql=update VIP_IM 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.printStackT

9、race(); /提取一个用户信息 public static String getRowID(String id) String s=new String8; try Class.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,tot

10、al 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) try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con=DriverMa

11、nager.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

12、 con=DriverManager.getConnection(jdbc:odbc:dbsm,); Statement st=con.createStatement(); stock String sql=insert into 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) try Cl

13、ass.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,); Statement st=con.createStatement(); String sql=update stock name=+s1+,price=+s2+,count=+s3+,vprice=+s4+,type=+s5+ where id=+s0+; st.executeUpdate(sql); st.close(); con.close(); catch(Exception e)

14、e.printStackTrace(); try Class.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 id=+id+); if(rs.next() for(int i=0;is.length;i+) si=rs

15、.getString(i+1); rs.close(); st.close(); con.close(); set where catch(Exception e) e.printStackTrace(); return s; /用户登录 public static int getUser(String k) String s=new String4; int i=0; try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,); Sta

16、tement 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; else return i; if(k1.equals(s3) if(s2.equals(1) i=1; else i=2; else i=3; rs.close(); st.close(); con.close(); catch(Excepti

17、on e) e.printStackTrace(); return i; /修改密码 public static void toUpdatePsw(String s) try Class.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(sq

18、l); 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=se

19、lect 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 get

20、TotalS(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

21、.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 f

22、rom 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); C

23、onnection 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; /

24、积分兑换表 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.executeUpdat

25、e(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(); St

26、ring 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; /用户账户插

27、入 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

28、(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

29、); st.close(); con.close(); catch(Exception e) e.printStackTrace(); / 更 新 积 分 物 品 信 息 public static void toUpdateTotal(String s) try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,); Statement st=con.createStatement(); String sql=update total s

30、et 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) try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con=DriverManager.getConnection(jdbc:odbc:dbsm,); Statement st

31、=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.getCon

32、nection(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(); retu

33、rn s; 2.SMServlet.class 用于响应 jsp 请求根据情况调用 DBUtil_SM 中的方法，返回结果， 代码如下 ( 手工编写 ) package paim; import javax.servlet.*; import javax.servlet.http.*; import java.io.*; public class SMServlet extends HttpServlet Override public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOEx

34、ception,ServletException doPost(request,response); Override public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException String action=request.getParameter(action); if(action.equals(del_id)/ 删除用户 String id=request.getParameter(id); DBUtil_SM.toDelID

35、(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.getPara

36、meter(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)

37、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(reque

38、st.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.getRe

39、questDispatcher(/useradd.jsp?str=1). include(request,response); else String 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

40、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);

41、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(

42、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)/ 根据

43、用户权限显示页面 request.getRequestDispatcher(/userlist.jsp?id=+s0). include(request,response); else request.getRequestDispatcher(/admin.jsp). include(request,response); if(action.equals(del_stock)/ 删除物品 String id=request.getParameter(id); DBUtil_SM.toDelStock(id); request.getRequestDispatcher(/admin.jsp).i

44、nclude(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);

45、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 String(request.getParameter(v

46、price).getBytes(ISO8859_1), GB2312); if(request.getParameter(type)!=null) s5= new String(request.getParameter(type).getBytes(ISO8859_1), GB2312); DBUtil_SM.toInsertStock(s); request.getRequestDispatcher(/admin.jsp). include(request,response); if(action.equals(update_stock)/ 修改物品信息 String s=new Strin

47、g6; 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

48、).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 String(request.getParameter(vprice).getBytes(ISO8859_1), GB2312); if(request.getParameter(type)!=null) s5= ne

49、w String(request.getParameter(type).getBytes(ISO8859_1), GB2312); DBUtil_SM.toUpdateStock(s); request.getRequestDispatcher(/admin.jsp). include(request,response); if(action.equals(login)/ 登陆验证 String k=new String2; k0=request.getParameter(id); k1=request.getParameter(psw); int i=DBUtil_SM.getUser(k)

50、; if(i=1)/ 判断是否为用户 request.getRequestDispatcher(/userlist.jsp?id=+k0+ if(i=0|i=5|i=3)/ 用户名不存在 密码错误 request.getRequestDispatcher(/login.jsp?str=9). include(request,response); if(i=2)/ 管理员跳转 request.getRequestDispatcher(/admin.jsp). include(request,response); if(action.equals(password)/ 密码修改 String k=

51、new String2; k0=request.getParameter(id); k1=request.getParameter(opsw); String s=new String2; s0=k0; s1=request.getParameter(npsw1); int i=DBUtil_SM.getUser(k); if(i=1) DBUtil_SM.toUpdatePsw(s); request.getRequestDispatcher(/userlist.jsp?id=+s0+ if(i=0|i=5|i=3) request.getRequestDispatcher(/update.

52、jsp?id=+s0+ if(i=2) DBUtil_SM.toUpdatePsw(s); request.getRequestDispatcher(/admin.jsp). include(request,response); if(action.equals(total)/ 兑换积分 积分余额 积分消费判断操作 String id=new String2; id0=request.getParameter(id); id1=request.getParameter(tid); int t=new int5; t0=DBUtil_SM.getTotalV(id0); t1=DBUtil_SM

53、.getTotalS(id1); t3=t0-t1; String tname=DBUtil_SM.getTotalName(id1); String sl=DBUtil_SM.getRowID(id0); String ll=new String6; if(t30) request.getRequestDispatcher(/total.jsp?id=+id0+ else sl7=Integer.toString(t3); ll0=sl0; ll1=sl1; ll2=Integer.toString(t3); ll3=DBUtil_SM.getTotalName(id1); ll4=Inte

54、ger.toString(t1); DBUtil_SM.addList(ll); DBUtil_SM.toUpdateID(sl); request.getRequestDispatcher(/total.jsp?id=+id0). forward(request,response); if(action.equals(addtotal)/ 添加积分物品 String s=new String3; if(request.getParameter(id)!=null) s0 = new String(request.getParameter(id).getBytes(ISO8859_1), GB

55、2312); if(request.getParameter(name)!=null) s1 = new String(request.getParameter(name).getBytes(ISO8859_1), GB2312); if(request.getParameter(total)!=null) s2 = new String(request.getParameter(total).getBytes(ISO8859_1), GB2312); DBUtil_SM.addTotal(s); request.getRequestDispatcher(/admin.jsp). include(request,