Java语言课程设计.docx

1、Java语言课程设计2、Java语言课程设计报告参考格式如下：1、设计内容自学Swing图形界面设计和数据库程序设计。开发用于某超市的超市管理系统。该系统要求实现以下功能模块：商品信息管理、采购管理、销售管理、用户管理、权限管理。在系统的开发过程充分考虑系统的方便性、实用性、安全性和规范性2、设计方案3、实现方法我们采用swing图形界面设计以及mysql数据库，数据库连接使用java对mysql的jdbc驱动。四、主要代码连接数据库： public static final String DBURL = jdbc:mysql:/localhost:3306/market; / MySQL数据

2、库的连接用户名 public static final String DBUSER = root; / MySQL数据库的连接密码 public static final String DBPASS = 123456; Connection con; public Connection openDB() try con=DriverManager.getConnection(DBURL,DBUSER,DBPASS); return con; catch(Exception e) e.printStackTrace(); return null ; 登陆实现： private void logi

3、nMouseClicked(java.awt.event.MouseEvent evt) int power=0; try Connection con=openDB(); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(SELECT * FROM userinfo); int pianli=0; if(user.getText()=null) JOptionPane.showMessageDialog(this, 请输入用户名！); else if(password.getPassword()=null

4、) JOptionPane.showMessageDialog(this, 请输入密码！); else String userl=user.getText(); String passwordl=String.valueOf(password.getPassword(); while(rs.next() if(userl.equals(rs.getString(user) ) cook.user=userl; if(passwordl.equals(rs.getString(password) if(manager.isSelected() power=1; cook.power=1; if(

5、rs.getInt(power)= power) ControllerManager .mloginJFramecontroller.show(); this.dispose(); pianli=1; else JOptionPane.showMessageDialog(this, 用户名或密码有错，请核对后登录); else if(seller.isSelected() power=2; cook.power=2; if(rs.getInt(power)= power) new sell().setVisible(true); this.dispose(); pianli=1; else J

6、OptionPane.showMessageDialog(this, 用户名或密码有错，请核对后登录); else break; if(pianli=0) JOptionPane.showMessageDialog(this, 用户名或密码有错，请核对后登录); catch(Exception e) e.printStackTrace(); 信息修改： public infoChange() String DBsex=; String DBbirthday=; String DBjob=; String DBid=; String DBpersonnelId=; try initCompone

7、nts(); Connection con=openDB(); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(SELECT * FROM userinfo); while(rs.next() if(rs.getString(user).equals(cook.user) DBsex=rs.getString(sex); DBbirthday=rs.getString(birthday); DBjob=rs.getString(job); DBid=rs.getString(ID); DBpersonne

8、lId=rs.getString(personnelId); sex.setSelectedItem(DBsex) ; ID.setText(DBid); job.setText(DBjob); birthday.setText(DBbirthday); user.setText(cook.user); personnelId.setText(DBpersonnelId); if(cook.power=1) manager.setSelected(true); else sell.setSelected(true); catch (SQLException ex) Logger.getLogg

9、er(infoChange.class.getName().log(Level.SEVERE, null, ex); private void OKMouseClicked(java.awt.event.MouseEvent evt) try Connection con=openDB(); Statement stmt=con.createStatement(); String SEX=String.valueOf(sex.getSelectedItem(); String Birthday=birthday.getText(); String Job=job.getText(); Stri

10、ng Id=ID.getText(); String sql=SELECT * FROM userinfo WHERE user=+cook.user+; ResultSet rSet=stmt.executeQuery(sql); if(rSet.next()=false) JOptionPane.showMessageDialog(this, 修改的信息不存在！); else String str=UPDATE userinfo SET sex=+SEX+,birthday=+Birthday+,job=+Job+,ID=+Id+ WHERE user=+cook.user+; stmt.

11、executeUpdate(str); JOptionPane.showMessageDialog(this, 添加成功！); catch (SQLException ex) Logger.getLogger(infoChange.class.getName().log(Level.SEVERE, null, ex); 密码修改： private void jButton1MouseClicked(java.awt.event.MouseEvent evt) try Connection con=openDB(); Statement stmt=con.createStatement(); R

12、esultSet rs=stmt.executeQuery(SELECT * FROM userinfo); while(rs.next() if(rs.getString(user).equals(cook.user) if(rs.getString(password).equals(String.valueOf(oldPassword.getPassword() if(String.valueOf(newPassword.getPassword().equals(String.valueOf(newPassword1.getPassword() String sql=UPDATE user

13、info SET password=+String.valueOf(newPassword.getPassword()+ WHERE user=+cook.user+; stmt.executeUpdate(sql); JOptionPane.showMessageDialog(this, 密码修改成功，请牢记您的密码！); else JOptionPane.showMessageDialog(this, 两次输入的新密码不相同！); else JOptionPane.showMessageDialog(this, 原密码输入错误！); catch (SQLException ex) Logg

14、er.getLogger(Password.class.getName().log(Level.SEVERE, null, ex); 人员管理：private void jButton1MouseClicked(java.awt.event.MouseEvent evt) DefaultTableModel tableModel = (DefaultTableModel) myTable.getModel(); if(myTable.getSelectedRow()!= -1) try int row1= myTable.getSelectedRow(); String cellValue=(

15、String) tableModel.getValueAt(row1, 0); Connection con=openDB(); Statement stmt=con.createStatement(); String sql=DELETE FROM userinfo WHERE user=+cellValue+; stmt.executeUpdate(sql); tableModel.removeRow(row1); JOptionPane.showMessageDialog(this, 用户名:+cellValue+已从数据库删除！); catch (SQLException ex) Lo

16、gger.getLogger(management.class.getName().log(Level.SEVERE, null, ex); else JOptionPane.showMessageDialog(this, 请选中要删除的信息再点击删除！); 用户注册： private void okMouseClicked(java.awt.event.MouseEvent evt) try Connection con=openDB(); Statement stmt=con.createStatement(); Statement stmt1=con.createStatement();

17、 ResultSet rs=stmt.executeQuery(SELECT * FROM userinfo); String User=user.getText(); String Password= String.valueOf(password.getPassword(); String Password1= String.valueOf(password1.getPassword(); String personneID=String.valueOf(personnelId.getText(); String SEX=String.valueOf(sex.getSelectedItem

18、(); String Birthday=birthday.getText(); String Job=job.getText(); String Id=ID.getText(); int power=0; if(jRadioButton1.isSelected() power=1; else if(sell.isSelected() power=2; if(Password.equals(Password1) int sign=0; while(rs.next() if(User.equals(rs.getString(user) sign=1; JOptionPane.showMessage

19、Dialog(this, 用户名已存在！); if(sign=0) String str=INSERT INTO userinfo VALUES(+User+,+Password+,+power+,+personneID+,+SEX+,+Birthday+,+Job+,+Id+); stmt1.executeUpdate(str); JOptionPane.showMessageDialog(this, 用户名创建成功！); else JOptionPane.showMessageDialog(this, 两次输入的密码不同！); catch(Exception e) e.printStack

20、Trace(); / TODO add your handling code here: 销售管理：void acountnumber() DefaultTableModel tableModel = (DefaultTableModel) myTable.getModel(); int rows = myTable.getRowCount(); float acount=0; float price=0; float quantity=0; for(int i=0;irows;i+) price=Float.parseFloat(String.valueOf(tableModel.getVa

21、lueAt(i, 6); if(String.valueOf(tableModel.getValueAt(i,8).equals() quantity=0; else quantity=Float.parseFloat(String.valueOf(tableModel.getValueAt(i,8); acount=acount+price*quantity; all.setText(String.valueOf(acount); int chose() /判断商品是否已加入或者数量大于库存量 int y=0; float quantity=0; float addquantity=0; i

22、f(Quantity.getText().equals() addquantity=0; else addquantity=Float.parseFloat(Quantity.getText(); Jnumber.getText(); DefaultTableModel tableModel = (DefaultTableModel) myTable.getModel(); int rows = myTable.getRowCount(); try Connection con=openDB(); Statement stmt=con.createStatement(); ResultSet

23、rs=stmt.executeQuery(SELECT * FROM commodity); while(rs.next() if(rs.getString(number).equals(Jnumber.getText() if(rs.getFloat(fullNumber)addquantity) y=1; JOptionPane.showMessageDialog(this, 对不起,此商品库存仅剩+rs.getFloat(fullNumber); return y; catch (SQLException ex) Logger.getLogger(MSalesJFrame.class.g

24、etName().log(Level.SEVERE, null, ex); for(int i=0;i=size2) JOptionPane.showMessageDialog(this, 对不起，暂时没有这件商品，请联系管理员添加！); catch (SQLException ex) Logger.getLogger(MSalesJFrame.class.getName().log(Level.SEVERE, null, ex); acountnumber(); private void DeletejButton2MouseClicked(java.awt.event.MouseEvent evt) DefaultTableModel tableModel = (DefaultTableModel) myTable.getModel(); if(myTable.getSelectedRow()!= -1) int row1= myTable.getSelectedRow(); tableModel.removeRow(row1); else JOptionPane.showMessageDialog(this