Java程序设计——商品销售客户管理.doc

java程序设计商品销售客户管理iijava程序设计报告年级专业 信息管理与信息系统 学 号 学生姓名 指导教师 二一四年六月 一、所用到的表的结构及数据类型 customer顾客表表名customer顾客说明此表记录顾客基本信息列名说明数据类型约束cno顾客编号char(10)主码cname顾客姓名char(10)cage年龄intcsex性别char(2)取值为男或女，默认女ctelephone顾客联系方式char(15)非空操作人员表表名操作人员说明此表记录操作人员信息列名说明数据类型约束用户名用户登录名nchar(10)主码密码登录密码nchar(3)非空职位担任职务nchar(10)二、程序的功能及实现结果截图1、 登录功能打开java文件login.java运行后输入错误的用户名后出现：输入用户名lucy 密码：123点击登录进入操作界面：2、 添加功能下拉顾客信息系统菜单，选择添加客户信息添加信息前数据库客户表的内容：没有编号0000013添加客户0000013：张蔷，29，女，0000013据库内表变为：注：0000015号是截图之前添加进去的3、 查询功能下拉客户信息系统菜单，选择查询客户信息，输入客户编码0000013后点击确定查询此顾客：4、 修改功能下拉菜单客户信息系统，选择修改客户信息，重新输入相应的正确信息，将错误的覆盖掉，此处将0000013张蔷年龄改为32：数据库表内内容:5、 删除功能下拉菜单客户信息系统，选择删除客户信息，输入客户编码0000013点击确认：数据库信息变为：0000013号信息已经删除6、 退出系统功能下拉菜单客户信息管理选择退出：然后就退出了界面。三、 程序源代码package loginsystem;import java.sql.*;import java.io.*;import javax.swing.*;import java.awt.*;import java.awt.event.*;import javax.swing.event.*; /登录界面public class login extends jframeprivate textfield namefield = new textfield(10);private jpasswordfield passwordfield = new jpasswordfield(15);private jbutton loginbutton = new jbutton(登 录);private jbutton exitbutton = new jbutton(退 出);private jlabel titlelabel = new jlabel(梦之路时尚天堂商品管理系统);private jlabel userlabel = new jlabel(用户名);private jlabel pwdlabel = new jlabel(密 码);private string user = null;private char pwd = null;public static void main(string args)login frame = new login();frame.settitle(系统登录);frame.setdefaultcloseoperation(jframe.do_nothing_on_close);frame.setresizable(false);frame.setlocation(600,300);frame.pack();frame.setvisible(true);public login()jpanel titlepanels = new jpanel();titlepanels.add(titlelabel);titlelabel.setfont(new java.awt.font(dialog,1,28);titlelabel.setforeground(color.red);jpanel labelpanels = new jpanel();labelpanels.setlayout(new gridlayout(2,1,10,40);labelpanels.add(userlabel);labelpanels.add(pwdlabel);jpanel textfieldpanels = new jpanel();textfieldpanels.setlayout(new gridlayout(2,1,10,40);textfieldpanels.add(namefield);textfieldpanels.add(passwordfield);jpanel buttonpanels = new jpanel();buttonpanels.add(loginbutton);buttonpanels.add(exitbutton);jpanel picturepanels = new jpanel();jlabel lb = new jlabel(new imageicon(a.png); picturepanels.add(lb);jpanel dialogpanels = new jpanel();dialogpanels.setlayout(new borderlayout();dialogpanels.add(titlepanels,borderlayout.north);dialogpanels.add(labelpanels,borderlayout.west);dialogpanels.add(textfieldpanels,borderlayout.center);dialogpanels.add(buttonpanels,borderlayout.south);dialogpanels.add(picturepanels,borderlayout.east);add(dialogpanels);exitbutton.addactionlistener(new actionlistener()public void actionperformed(actionevent event)system.exit(0););loginbutton.addactionlistener(new actionlistener()public void actionperformed(actionevent event)connection con=login.getconnection();trystatement state=con.createstatement();user = namefield.gettext();pwd = passwordfield.getpassword();string pwds = new string(pwd);string sql = select 密码 from 操作人员 where 用户名 =+user+;resultset rs = state.executequery(sql);rs.next();if(pwds.equals()|user.equals()joptionpane.showmessagedialog(null,用户名或密码不能为空！,错误,joptionpane.error_message);else if(!(rs.getstring(密码).equals(pwds)joptionpane.showmessagedialog(null,用户名或密码错误！,错误,joptionpane.error_message);elsenew goods();dispose();login.closeconn(con);login.closestate(state);login.closers(rs);catch(sqlexception e)joptionpane.showmessagedialog(null,用户名或密码错误！,错误,joptionpane.error_message););public static void closeconn(connection conn)try if(conn != null)conn.close(); catch (sqlexception e) e.printstacktrace();public static void closestate(statement state) try if(state != null)state.close(); catch (sqlexception e) e.printstacktrace();public static void closers(resultset rs) try if(rs != null)rs.close(); catch (sqlexception e) e.printstacktrace();/连接数据库public static connection getconnection()string drivername = com.microsoft.sqlserver.jdbc.sqlserverdriver;string dburl = jdbc:sqlserver:/localhost:1433;databasename=梦之路时尚天堂商品管理系统; string username = sa; string userpwd = 123; connection conn=null; try class.forname(drivername); conn = drivermanager.getconnection(dburl, username, userpwd); catch (exception e) e.printstacktrace(); return conn;/菜单界面class goodsprivate static final long serialversionuid=1l;static final int width=760;static final int height=510;jpopupmenu pop;jmenuitem item2;jframe f;jmenuitem item1;jpanel p;jtabbedpane tp;public goods()f=new jframe(梦之路时尚天堂商品管理系统);jmenubar menubar1=new jmenubar();tp=new jtabbedpane();p=new jpanel();f.setjmenubar(menubar1);f.add(p);p.add(tp);jmenu menu1=new jmenu(顾客信息系统);menu1.setmnemonic(z);menubar1.add(menu1); jmenuitem item1=new jmenuitem(添加客户信息); jmenuitem item2=new jmenuitem(修改客户信息); jmenuitem item3=new jmenuitem(查询客户信息); jmenuitem item4=new jmenuitem(删除客户信息); jmenuitem item5=new jmenuitem(退出); item1.setaccelerator(keystroke.getkeystroke(a,java.awt.event.ctrl_mask,false); item2.setaccelerator(keystroke.getkeystroke(u,java.awt.event.ctrl_mask,false); item3.setaccelerator(keystroke.getkeystroke(s,java.awt.event.ctrl_mask,false); item4.setaccelerator(keystroke.getkeystroke(d,java.awt.event.ctrl_mask,false); item5.setaccelerator(keystroke.getkeystroke(e,java.awt.event.ctrl_mask,false); menu1.add(item1); menu1.add(item2); menu1.add(item3); menu1.add(item4); menu1.add(item5); f.add(p); jlabel lb = new jlabel(new imageicon(sc.jpg); p.add(lb); f.setvisible(true); f.setsize(width,height); toolkit kit=toolkit.getdefaulttoolkit(); dimension screensize=kit.getscreensize(); int width=screensize.width; int height=screensize.height; int x=(width-width)/2; int y=(height-height)/2; f.setlocation(x,y); item1.addactionlistener(new actionlistener() public void actionperformed(actionevent event) add con1=new add(); tp.addtab(添加客户信息,con1); tp.setenabledat(0,true); tp.settitleat(0,添加客户信息); tp.setpreferredsize(new dimension(500,200); tp.settabplacement(jtabbedpane.top); tp.settablayoutpolicy(jtabbedpane.scroll_tab_layout); ); item2.addactionlistener(new actionlistener() public void actionperformed(actionevent event) update con2=new update(); tp.addtab(修改客户信息,con2); tp.setenabledat(0,true); tp.settitleat(0,修改客户信息); tp.setpreferredsize(new dimension(500,200); tp.settabplacement(jtabbedpane.top); tp.settablayoutpolicy(jtabbedpane.scroll_tab_layout); ); item3.addactionlistener(new actionlistener() public void actionperformed(actionevent event) select con3=new select(); tp.addtab(查询客户信息,con3); tp.setenabledat(0,true); tp.settitleat(0,查询客户信息); tp.setpreferredsize(new dimension(500,200); tp.settabplacement(jtabbedpane.top); tp.settablayoutpolicy(jtabbedpane.scroll_tab_layout); ); item4.addactionlistener(new actionlistener() public void actionperformed(actionevent event) delect con4=new delect(); tp.addtab(删除客户信息,con4); tp.setenabledat(0,true); tp.settitleat(0,删除客户信息); tp.setpreferredsize(new dimension(500,200); tp.settabplacement(jtabbedpane.top); tp.settablayoutpolicy(jtabbedpane.scroll_tab_layout); ); item5.addactionlistener(new actionlistener() public void actionperformed(actionevent e) system.exit(0); ); menu1.addmenulistener(new menulistener() public void menuselected(menuevent event) item2.setenabled(!item1.isselected(); public void menudeselected(menuevent event) public void menucanceled(menuevent event) ); /信息添加 class add extends jpanel public void add(component c,gridbagconstraints constraints,int x,int y,int w,int h) constraints.gridx=x; constraints.gridy=y; constraints.gridwidth=w; constraints.gridheight=h; add(c,constraints); add() gridbaglayout lay=new gridbaglayout(); setlayout(lay); jbutton ok=new jbutton(确 定); jbutton clear=new jbutton(清 空); jbutton c=new jbutton(关闭); jlabel name=new jlabel(姓名); jlabel phone=new jlabel(电话号码); jlabel sex=new jlabel(性别); jlabel num=new jlabel(客户编码); jlabel years=new jlabel(年龄); font font=new font(serief, font.bold, 22); final jtextfield nameinput=new jtextfield(10); final jtextfield phoneinput=new jtextfield(10); final jtextfield sexinput=new jtextfield(10); final jtextfield numinput=new jtextfield(10); final jtextfield yearsinput=new jtextfield(10); jlabel title=new jlabel(顾客基本信息); title.setfont(font); title.setforeground(color.blue); jbutton additionbutton=new jbutton(添加); gridbagconstraints constraints=new gridbagconstraints(); constraints.fill=gridbagconstraints.none; constraints.weightx=4; constraints.weighty=7; add(title,constraints,0,0,4,1); add(num,constraints,0,4,1,1); add(name,constraints,0,1,1,1); add(phone,constraints,0,5,1,1); add(sex,constraints,0,3,1,1); add(years,constraints,0,2,1,1); add(nameinput,constraints,1,1,1,1); add(phoneinput,constraints,1,5,1,1); add(sexinput,constraints,1,3,1,1); add(numinput,constraints,1,4,1,1); add(yearsinput,constraints,1,2,1,1); add(ok,constraints,3,1,1,1); add(clear,constraints,3,3,1,1); add(c,constraints,3,5,1,1); c.addactionlistener(new actionlistener() public void actionperformed(actionevent event) removeall(); ); ok.addactionlistener(new actionlistener() public void actionperformed(actionevent event) try class.forname(com.microsoft.sqlserver.jdbc.sqlserverdriver); catch(classnotfoundexception ex) string url=jdbc:sqlserver:/localhost:1433; databasename=梦之路时尚天堂商品管理系统;string user=sa;string password=123; statement stmt; resultset rs; preparedstatement prestmt;string nametext=nameinput.gettext(); string phonetext=phoneinput.gettext(); string sextext=sexinput.gettext(); string numtext=numinput.gettext(); string yearstext=yearsinput.gettext(); tryconnection con= drivermanager.getconnection(url,user,password);prestmt=con.preparestatement(insert into customer顾客 values(?,?,?,?,?) );prestmt.setstring(5,phonetext);prestmt.setstring(2,nametext);prestmt.setstring(4,sextext);prestmt.setstring(1,numtext);prestmt.setstring(3,yearstext);prestmt.executeupdate();con.close();joptionpane.showmessagedialog(null,信息添加成功,ok,joptionpane.information_message); catch(sqlexception ex) ); clear.addactionlistener(new actionlistener() public void actionperformed(actionevent event) nameinput.settext(); phoneinput.settext(); sexinput.settext(); numinput.settext(); yearsinput.settext(); ); /信息修改 class update extends jpanel public void add(component c,gridbagconstraints constraints,int x,int y,int w,int h) constraints.gridx=x; constraints.gridy=y; constraints.gridwidth=w; constraints.gridheight=h; add(c,constraints); update() gridbaglayout lay=new gridbaglayout(); setlayout(lay); jbutton ok=new jbutton(确 定); jbutton clear=new jbutton(清 空); jbutton c=new jbutton(关闭); jlabel name=new jlabel(姓名); jlabel phone=new jlabel(电话号码); jlabel sex=new jlabel(性别); jlabel num=new jlabel(客户编码); jlabel years=new jlabel(年龄); final jtextfield nameinput=new jtextfield(10); final jtextfield phoneinput=new jtextfield(10); final jtextfield sexinput=new jtextfield(10); final jtextfield numinput=new jtextfield(10); final jtextfield yearsinput=new jtextfield(10); jlabel title=new jlabel(修改基本信息); font font=new font(serief, font.bold, 22); title.setfont(font); title.setforeground(color.blue);/设置标签前景色 jbutton additionbutton=new jbutton(添加); gridbagconstraints constraints=new gridbagconstraints(); constraints.fill=gridbagconstraints.none; constraints.weightx=4; constraints.weighty=7; add(title,constraints,0,0,4,1); add(name,constraints,0,1,1,1); add(phone,constraints,0,5,1,1); add(sex,constraints,0,3,1,1); add(num,constraints,0,4,1,1); add(nameinput,constraints,1,1,1,1); add(phoneinput,constraints,1,5,1,1); add(sexinput,constraints,1,3,1,1);add(numinput,constraints,1,4,1,1); add(years,constraints,0,2,1,1); add(yearsinput,constraints,1,2,1,1); add(ok,constraints,3,1,1,1); add(clear,constraints,3,3,1,1); add(c,constraints,3,5,1,1); c.addactionlistener(new actionlistener() public void actionperformed(actionevent e) removeall(); ); ok.addactionlistener(new actionlistener() public void actionperformed(actionevent event) try class.forname(com.microsoft.sqlserver.jdbc.sqlserverdriver); catch(classnotfoundexception ex) string url=jdbc:sqlserver:/localhost:1433; databasename=梦之路时尚天堂商品管理系统;string user=sa;string password=123; statement stmt; resultset rs; preparedstatement prestmt;string nametext=nameinput.gettext(); string phonetext=phoneinput.gettext(); string sextext=sexinput.gettext(); string numtext=numinput.gettext(); string yearstext=yearsinput.gettext(); tryconnection conn= drivermanager.getconnection(url,user,password);prestmt=conn.preparestatement(update customer顾客 set cname=?,csex=?,ctelephone=?,cage=? where cno=?);prestmt.setstring(1,nametext);prestmt.setstring(2,sextext);prestmt.setstring(5,numtext);prestmt.setstring(4,yearstext);prestmt.setstring(3,phonetext);prestmt.executeupdate();prestmt.close();conn.close();joptionpane.showmessagedialog(null,信息修改成功,ok,joptionpane.information_message);catch(sqlexception ex) ex.printstacktrace(); ); clear.addactionlistener(new actionlistener() public void actionperformed(actionevent event) nameinput.settext(); phoneinput.settext(); sexinput.settext(); numinput.settext(); yearsinput.settext(); ); /信息删除 class delect extends jpanel public void add(component c,gridbagconstraints constraints,int x,int y,int w,int h) constraints.gridx=x; constraints.gridy=y; constraints.gridwidth=w; con