这是关于java的毕业设计
源代码在线查看： jdbc.java
/*
* @(#)JDBC.java 1.0 03/07/17
*
* Author:weidl
*
* 简易的JAVA连接数据库的例子
*/
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.net.URL;
import java.sql.*;
public class JDBC extends WindowAdapter
{
Frame win1;
MenuBar myMenu;
Menu fileMenu;
Menu helpMenu;
MenuItem fileMenuItem1;
MenuItem helpMenuItem1;
MyDialog dialog1;
TextField tx1;
TextField tx2;
Panel myP=new Panel();
Panel myP2=new Panel();
//Panel myP3=new Panel();
Label logo;
Button btn1;
Button btn2;
Button btn3;
Button btn4;
Button btn5;
Button btn6;
String username;
int password;
boolean flag=false;
String url="jdbc:odbc:account";
JDBC()
{
win1=new Frame("简易ATM系统测试版");
win1.setLayout(new BorderLayout());
//设置菜单
myMenu=new MenuBar();
fileMenu=new Menu("File");
helpMenu=new Menu("Help");
myMenu.add(fileMenu);
myMenu.add(helpMenu);
fileMenuItem1=new MenuItem("Exit");
helpMenuItem1=new MenuItem("Version");
myMenu.add(fileMenu);
myMenu.add(helpMenu);
fileMenu.add(fileMenuItem1);
helpMenu.add(helpMenuItem1);
fileMenuItem1.addActionListener(new ActionListener1());
helpMenuItem1.addActionListener(new ActionListener1());
win1.setMenuBar(myMenu);
//设置对话框（help菜单)
dialog1=new MyDialog(win1,"关于简易ATM系统测试版",true);
dialog1.addWindowListener(this);
//用户名及密码
tx1=new TextField(10);
tx2=new TextField(10);
//设置各个Button
win1.add(myP,BorderLayout.CENTER);
myP.setLayout(new FlowLayout());
myP.add(new Label("username:"));
myP.add(tx1);
myP.add(new Label("password:"));
myP.add(tx2);
btn1=new Button("登陆");
btn2=new Button("清除");
btn1.addActionListener(new ActionListener1());
btn2.addActionListener(new ActionListener1());
btn3=new Button("账户余额");
btn3.setForeground(Color.black);
btn3.setBackground(Color.WHITE);
btn3.addActionListener(new ActionListener1());
btn4=new Button("我要取款");
btn4.setForeground(Color.black);
btn4.setBackground(Color.WHITE);
btn4.addActionListener(new ActionListener1());
btn5=new Button("修改密码");
btn5.setForeground(Color.black);
btn5.setBackground(Color.WHITE);
btn5.addActionListener(new ActionListener1());
btn6=new Button("退出系统");
btn6.setForeground(Color.black);
btn6.setBackground(Color.WHITE);
btn6.addActionListener(new ActionListener1());
myP.add(btn1);
myP.add(btn2);
win1.add(myP2,BorderLayout.EAST);
myP2.setLayout(new GridLayout(4,1));
myP2.add(btn3);
myP2.add(btn4);
myP2.add(btn5);
myP2.add(btn6);
logo=new Label("欢迎来到本系统！");
logo.setFont(new Font("Serif",Font.PLAIN,15));
win1.add(logo,BorderLayout.NORTH);
win1.setSize(600,400);
win1.setVisible(true);
win1.addWindowListener(this);
}
public static void main(String args[])
{
new JDBC();
//显示logo图片
Thread thread;
Logo lg=new Logo("LOGO.GIF");
thread=new Thread(lg);
thread.start();
}
public void windowClosing(WindowEvent e)
{
if(e.getSource()==win1)
{
System.exit(0);
}
if(e.getSource()==dialog1)
{
dialog1.dispose();
}
}
//登陆
public void login(String name,int pword)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
CallableStatement cs=con.prepareCall("{call query1(?)}");
cs.setString(1,name);
ResultSet rs=cs.executeQuery();
while(rs.next())
{
long i=rs.getLong("password");
//int balance=rs.getInt("balance");
//System.out.println(balance);
if(pword==i)
{
flag=true;
myP.removeAll();
Label login=new Label("恭喜你，你已经登陆，可使用右面的按钮");
myP.add(login);
win1.setVisible(true);
}
else
{
tx2.setText("密码错误");
}
}
cs.close();
con.close();
}
catch(SQLException e)
{
System.out.println("SQLException caught");
}
catch(ClassNotFoundException ex)
{
System.out.println("error");
}
}
public void balance()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
CallableStatement cs=con.prepareCall("{call query1(?)}");
cs.setString(1,username);
ResultSet rs=cs.executeQuery();
while(rs.next())
{
int balance=rs.getInt("balance");
//System.out.println(balance);
myP.removeAll();
Label account=new Label("你的余额为:");
TextField tx3=new TextField(15);
tx3.setText(""+balance);
myP.add(account);
myP.add(tx3);
win1.setVisible(true);
}
cs.close();
con.close();
}
catch(SQLException e)
{
System.out.println("SQLException caught");
}
catch(ClassNotFoundException ex)
{
System.out.println("error");
}
}
public void takeMoney(int money)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
CallableStatement cs=con.prepareCall("{call query1(?)}");
cs.setString(1,username);
ResultSet rs=cs.executeQuery();
while(rs.next())
{
int balance=rs.getInt("balance");
if(money {
CallableStatement cs1=con.prepareCall("{call query2(?)}");
cs1.setInt(1,money);
cs1.executeUpdate();
cs1.close();
myP.removeAll();
Label money1=new Label("交易成功");
myP.add(money1);
win1.setVisible(true);
}
}
//cs1.close();
cs.close();
con.close();
}
catch(SQLException e)
{
balance();
}
catch(ClassNotFoundException ex)
{
System.out.println("error");
}
}
public void updatePassword(int pass)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
CallableStatement cs=con.prepareCall("{call query1(?)}");
cs.setString(1,username);
ResultSet rs=cs.executeQuery();
while(rs.next())
{
CallableStatement cs2=con.prepareCall("{call query3(?)}");
cs2.setInt(1,pass);
cs2.executeUpdate();
cs2.close();
myP.removeAll();
Label pass1=new Label("密码修改成功");
myP.add(pass1);
win1.setVisible(true);
}
//cs1.close();
cs.close();
con.close();
}
catch(SQLException e)
{
balance();
}
catch(ClassNotFoundException ex)
{
System.out.println("error");
}
}
class ActionListener1 implements ActionListener
{
int money3,password1;
Button btn7,btn8;
String x,y;
TextField tx5,tx6;
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==fileMenuItem1)
{
System.exit(0);
}
if(e.getSource()==helpMenuItem1)
{
dialog1.setSize(200,100);
dialog1.setVisible(true);
//dialog1.addWindowListener(new WindowListener2());
}
if(e.getSource()==btn6)
{
if(flag==true)
{
myP.removeAll();
win1.dispose();
new JDBC();
}
}
if(e.getSource()==btn2)
{
tx1.setText("");
tx2.setText("");
}
if(e.getSource()==btn1)
{
username=tx1.getText();
password=Integer.parseInt(tx2.getText());
login(username,password);
}
if(e.getSource()==btn3)
{
if(flag==true)
{
myP.removeAll();
balance();
}
}
if(e.getSource()==btn4)
{
if(flag==true)
{
myP.removeAll();
Label money2=new Label("输入多少钱:");
tx5=new TextField(10);
myP.add(money2);
myP.add(tx5);
btn7=new Button("OK");
btn7.addActionListener(new ActionListener2());
myP.add(btn7);
win1.setVisible(true);
//System.out.println(money3);
//Integer i2=new Integer(i2);
//int money3=i2.intValue();
//takeMoney(60);
}
}
if(e.getSource()==btn5)
{
if(flag==true)
{
myP.removeAll();
Label pass3=new Label("输入新密码:");
tx6=new TextField(10);
myP.add(pass3);
myP.add(tx6);
btn8=new Button("OK");
btn8.addActionListener(new ActionListener2());
myP.add(btn8);
win1.setVisible(true);
}
}
}
class ActionListener2 implements ActionListener
{
public void actionPerformed(ActionEvent ee)
{
//System.out.println(money3);
if(ee.getSource()==btn7)
{
x=tx5.getText();
money3=Integer.parseInt(x);
takeMoney(money3);
}
if(ee.getSource()==btn8)
{
y=tx6.getText();
password1=Integer.parseInt(y);
updatePassword(password1);
}
}
}
}
class MyDialog extends Dialog
{
Label label1=new Label("ATM简易测试版");
Label label2=new Label("Author:weidl Version: 1.0");
MyDialog(Frame frame1,String title,boolean bool)
{
super(frame1,title,bool);
BorderLayout layout=new BorderLayout();
setLayout(layout);
add(label1,BorderLayout.NORTH);
add(label2,BorderLayout.SOUTH);
}
}
}
//-----------------------------------------------------------
class Logo extends JWindow implements Runnable
{
String filename;
public Logo(String name)
{
filename=name;
}
public Logo()
{
}
public void run()
{
URL imgURL = getClass().getResource(filename);
ImageIcon ig=new ImageIcon(imgURL);
JButton btn=new JButton(ig);
getContentPane().add(btn);
Toolkit kit=Toolkit.getDefaultToolkit();
Dimension screenSize=kit.getScreenSize();
setLocation(screenSize.width/8,screenSize.height/8);
setSize(ig.getIconWidth(),ig.getIconHeight());
toFront();
thread1 thread2=new thread1();
thread2.start();
//setVisible(false);
}
public void setNotVisible()
{
setVisible(false);
}
class thread1 extends Thread
{
public void run()
{
try
{
setVisible(true);
sleep(4000);
setNotVisible();
}
catch(InterruptedException e)
{
System.out.print("error occours");
}
}
}
}
