JAVA课程设计-银行存取管理系统(所有代码)

ResultSet rs=stmt.executeQuery(\UserID='\+Integer.parseInt(a.Kahao.getText())+\);

if(rs.next()) {

name.setText(rs.getString(\)); sex.setText(rs.getString(\)); kahao.setText(rs.getString(\)); phone.setText(rs.getString(\)); rs.close(); stmt.close(); conn.close(); }

}

catch(Exception sqle){

System.err.println(sqle);

JOptionPane.showMessageDialog(Zhuye.z,\系统故障，请稍后在试！\);

public class BHandler implements ActionListener {

public void actionPerformed (ActionEvent event) {

System.out.println(x); if(x==1) int x;

if(event.getActionCommand()==\确定\) {

}

setVisible(true); }

x=Denlu.chagai(name.getText(),sex.getText(),phone.getText());

{ JOptionPane.showMessageDialog(Zhuye.z,\修改成功！\);dispose();}

else

{ JOptionPane.showMessageDialog(Zhuye.z,\修改出错！\);dispose();}

}

}

}

else if(event.getActionCommand()==\取消\) dispose();

9

}

类：Cunkuan.java

package zhuce;

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

public class Cunkuan extends JDialog { TextField jine=new TextField(10); public Cunkuan(JFrame m,String s){ super(m,s);

setDefaultCloseOperation(WindowConstants.HIDE_ON_CLOSE); setBounds(400,250,400,200); setVisible(true); setResizable(false); setLayout(null);

JLabel label1=new JLabel(\请输入存款的金额\ label1.setFont(new Font(\ JLabel label2=new JLabel(\金额：\

label2.setFont(new Font(\

JButton button1=new JButton(\确认\ BHandler h=new BHandler(); button1.addActionListener(h);

JPanel p1=new JPanel(); JPanel p2=new JPanel();

p1.setBounds(0,0,200,70); p1.add(label1);

p2.setBounds(25,70,400,50); p2.add(label2); p2.add(jine); p2.add(button1);

add(p1); add(p2);

setVisible(true); }

public class BHandler implements ActionListener {

10

public void actionPerformed (ActionEvent event) { if(!(jine.getText().equals(\ {

int i=0;

i=Denlu.cunkuan(Integer.parseInt(a.Kahao.getText()),Integer.parseInt(jine.getText()));

if(i==1) {

JOptionPane.showMessageDialog(Zhuye.z,\成功存款\元！\ dispose(); } else

JOptionPane.showMessageDialog(Zhuye.z,\系统故障，请稍后在试！\ }

else

JOptionPane.showMessageDialog(Zhuye.z,\请输入存款金额！\ } } }

类：Denlu.java

package zhuce; import java.sql.*; public class Denlu {

public Denlu(){ }

public static int shanchu(String id) {

long a=chaxun(); if(a==0) {

try{

Class.forName(\); Connection conn =

DriverManager.getConnection(\,\,\);

Statement stmt=conn.createStatement(); String sql=\ stmt.executeUpdate(sql); stmt.close();

UserID='\+Integer.parseInt(id)+\;

11

conn.close(); return 1; }

public static int zhucezh(String name,String sex,String kahao,String {try{

}

catch(Exception sqle){

System.err.println(sqle); return 3; } } else

return 2;

mima,String phone)

//1.注册驱动

String driverClassName = \; Class.forName(\); //2.连接数据库 Connection conn =

DriverManager.getConnection(\,\,\);

Statement stmt=conn.createStatement();

String sql=\;

PreparedStatement ps=(PreparedStatement) conn.prepareStatement(sql); ps.setString(1,kahao); ps.setString(2,name); ps.setString(3,mima); ps.setString(4,phone); ps.setString(5,sex); ps.setInt(6,0); ps.executeUpdate(); ps.close(); stmt.close(); conn.close(); return 1; }

catch(Exception sqle){

System.err.println(sqle); return 3; } }

public static int chagai(String name,String sex,String phone) {

try{

12