package com.supersky;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
public class Zhuan {
public Zhuan() {
final JFrame ff = new JFrame("转帐系统");
ff.setLayout(null);
ff.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
ff.setSize(320, 240);
ff.setLayout(new GridLayout(5, 1));
JPanel p1 = new JPanel();
JLabel lb1 = new JLabel("转帐暂不支持跨行操作!");
p1.add(lb1);
JPanel p2 = new JPanel();
JLabel lb2 = new JLabel("对方卡号:");
final JTextField jt1 = new JTextField("", 10);
p2.add(lb2);
p2.add(jt1);
JPanel p3 = new JPanel();
JLabel lb3 = new JLabel("对方帐户:");
final JTextField jt2 = new JTextField("", 10);
p3.add(lb3);
p3.add(jt2);
JPanel p4 = new JPanel();
JLabel lb4 = new JLabel("转帐金额:");
final JTextField jt3 = new JTextField("", 10);
p4.add(lb4);
p4.add(jt3);
JPanel p5 = new JPanel();
JButton b1 = new JButton("确认");
b1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
try {
int t1 = Integer.parseInt(jt1.getText());
String t2 = jt2.getText();
double t3 = Double.parseDouble(jt3.getText());
// System.out.println(t1+":"+t2+":"+t3);
Connection con = Db.getDb().getCon();
try {
String sql1 = "select money from users where id=? and Username=?";
PreparedStatement ps1 = con.prepareStatement(sql1);
ps1.setInt(1, t1);
ps1.setString(2, t2);
if (t1 != Awt1.getCard()
|| !t2.equals(Awt1.getUsername())) {
ResultSet rs1 = ps1.executeQuery();
rs1.next();
double muBiao = rs1.getDouble("money");
System.out.println(muBiao);
String sql3 = "update users set money=money-? where id=? and Username=?";
PreparedStatement ps3 = con.prepareStatement(sql3);
ps3.setDouble(1, t3);
ps3.setInt(2, Awt1.getCard());
ps3.setString(3, Awt1.getUsername());
ps3.executeUpdate();
String sql2 = "update users set money=? where id=? and Username=?";
PreparedStatement ps2 = con.prepareStatement(sql2);
ps2.setDouble(1, muBiao + t3);
ps2.setInt(2, t1);
ps2.setString(3, t2);
ps2.executeUpdate();
JOptionPane.showMessageDialog(ff, "转帐成功!");
Awt1.setQian(Awt1.getQian() - t3);
jt1.setText("");
jt2.setText("");
jt3.setText("");
} else {
JOptionPane.showMessageDialog(null, "还用给自己转帐吗?");
jt1.setText("");
jt2.setText("");
jt3.setText("");
}
} catch (Exception e) {
JOptionPane.showMessageDialog(ff, "帐户或卡号错误!");
jt1.setText("");
jt2.setText("");
jt3.setText("");
// e.printStackTrace();
}
} catch (Exception es) {
System.out.println("aaa");
JOptionPane.showMessageDialog(ff, "不合法的输入!");
jt1.setText("");
jt2.setText("");
jt3.setText("");
// es.printStackTrace();
}
}
});
JButton b2 = new JButton("返回");
b2.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
ff.dispose();
new ZhuYe();
}
});
p5.add(b1);
p5.add(b2);
ff.add(p1);
ff.add(p2);
ff.add(p3);
ff.add(p4);
ff.add(p5);
ff.setVisible(true);
}
}