JAVA课程设计源程序.docxVIP

packagejavabigwork;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclassLoginFrmextendsJFrameimplementsActionListener{privateJLabellblTitle=newJLabel(欢迎进入家庭财务管理系统);privateJLabellblName=newJLabel(用户名);privateJLabellblPwd=newJLabel(密码);privateJTextFieldtxtName=newJTextField();privateJPasswordFieldtxtPwd=newJPasswordField();privateJButtonbtnOk=newJButton(用户登陆);privateJButtonbtnCancel=newJButton(退出系统);private String driver = sun.jdbc.odbc.JdbcOdbcDriver;private String url = jdbc:odbc:mydb;privateintrowcount=0;publicLoginFrm(){JPaneljp = (JPanel) this.getContentPane();jp.setLayout(null);jp.add(lblTitle);lblTitle.setBounds(300, 50, 200, 50);jp.add(lblName);lblName.setBounds(200, 100, 100, 20);jp.add(txtName);txtName.setBounds(500, 100, 100, 20);jp.add(lblPwd);lblPwd.setBounds(200, 150, 100, 20);jp.add(txtPwd);txtPwd.setBounds(500, 150, 100, 20);jp.add(btnOk);btnOk.setBounds(200, 220, 100, 20);jp.add(btnCancel);btnCancel.setBounds(500, 220, 100, 20);this.setTitle(家庭用户登陆);this.setSize(800,400);this.setVisible(true);this.setDefaultCloseOperation(EXIT_ON_CLOSE);btnOk.addActionListener(this);btnCancel.addActionListener(this);}publicvoidactionPerformed(ActionEvent e) {if(e.getSource() == btnOk){String [][] rows = this.queryCustomers();String s1=txtName.getText();String s2=txtPwd.getText();for(inti=0;irowcount;i++){if(s1.equals(rows[i][0])){if(s2.equals(rows[i][1])){JOptionPane.showMessageDialog(this, 用户名和密码正确);newCustomerFrm();}elseJOptionPane.showMessageDialog(this, 用户名或密码错误);}}}if(e.getSource() == btnCancel){System.exit(0);}}public String[][] queryCustomers() {String[][] rows = null;try {Class.forName(driver);Connection con = DriverManager.getConnection(url);Statement cmd = con.createStatement();String sql = select count(*) from admin;ResultSetrs = cmd.executeQuery(sql);rs.next();rowcount = rs.getInt(1);rows = new String[rowcount][2];sql = select * from admin;rs = cmd.executeQuery(sql);rowcount = 0;while (rs.next()) {for (inti = 1; i = 2; i+