📄 currentfetch.java
字号:
/*
* CurrentFetch.java
*
* Created on 2007年1月19日, 下午4:09
*/
package javaapplication1;
import java.awt.Toolkit;
import java.sql.*;
import javax.swing.JOptionPane;
/**
*
* @author zzz
*/
public class CurrentFetch extends javax.swing.JFrame {
String staffID = "";
/** Creates new form CurrentFetch */
public CurrentFetch(String ID) {
this.staffID = ID;
connectDB();
initComponents();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
//-------设置窗口位置居中---------------------------------------------------------------
int locationX=(int)(Toolkit.getDefaultToolkit().getScreenSize().getWidth()-getSize().getWidth())/2;
int locationY=(int)(Toolkit.getDefaultToolkit().getScreenSize().getHeight()-getSize().getHeight())/2;
setLocation(locationX,locationY);
//--------------------------------------------------------------------------------------
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
// <editor-fold defaultstate="collapsed" desc=" 生成的代码 ">//GEN-BEGIN:initComponents
private void initComponents() {
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
accountField = new javax.swing.JTextField();
passwordField = new javax.swing.JPasswordField();
nameField = new javax.swing.JTextField();
jLabel5 = new javax.swing.JLabel();
sumField = new javax.swing.JTextField();
confirmButton = new javax.swing.JButton();
resetButton = new javax.swing.JButton();
cancelButton = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setText("\u6d3b\u671f\u53d6\u6b3e");
jLabel2.setText("\u5e10\u53f7");
jLabel3.setText("\u5bc6\u7801");
jLabel4.setText("\u59d3\u540d");
jLabel5.setText("\u91d1\u989d");
confirmButton.setText("\u786e\u8ba4");
confirmButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
confirmButtonActionPerformed(evt);
}
});
resetButton.setText("\u91cd\u7f6e");
resetButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
resetButtonActionPerformed(evt);
}
});
cancelButton.setText("\u53d6\u6d88");
cancelButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cancelButtonActionPerformed(evt);
}
});
org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(layout.createSequentialGroup()
.add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(layout.createSequentialGroup()
.add(109, 109, 109)
.add(jLabel1))
.add(layout.createSequentialGroup()
.addContainerGap()
.add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(jLabel2)
.add(jLabel3)
.add(jLabel4)
.add(jLabel5))
.add(14, 14, 14)
.add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
.add(org.jdesktop.layout.GroupLayout.LEADING, layout.createSequentialGroup()
.add(confirmButton)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(resetButton)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(cancelButton))
.add(org.jdesktop.layout.GroupLayout.LEADING, passwordField, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 192, Short.MAX_VALUE)
.add(org.jdesktop.layout.GroupLayout.LEADING, nameField, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 192, Short.MAX_VALUE)
.add(org.jdesktop.layout.GroupLayout.LEADING, sumField, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 192, Short.MAX_VALUE)
.add(org.jdesktop.layout.GroupLayout.LEADING, accountField, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 192, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))))
.addContainerGap(34, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(layout.createSequentialGroup()
.addContainerGap()
.add(jLabel1)
.add(14, 14, 14)
.add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(jLabel2)
.add(accountField, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
.add(jLabel3)
.add(passwordField, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
.add(17, 17, 17)
.add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(jLabel4)
.add(nameField, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
.add(14, 14, 14)
.add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(jLabel5)
.add(sumField, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
.add(22, 22, 22)
.add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(confirmButton)
.add(resetButton)
.add(cancelButton))
.addContainerGap(53, Short.MAX_VALUE))
);
pack();
}// </editor-fold>//GEN-END:initComponents
//活期取款
private void confirmButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_confirmButtonActionPerformed
// TODO 将在此处添加您的处理代码：
String accountID = " "+accountField.getText();
String password = passwordField.getText();
String name = nameField.getText();
int sum = Integer.parseInt(sumField.getText());
CallableStatement proc = null;
try
{
String sql = "select * from deAccount where accountID = '"+accountID+"' and accountType='CU'";
// String sql = "select * from deAccount where state='EF' and accountID = '"+accountID+"' and accountType='CU' and accountPassword='"+password+"'";
Statement stat = currentFetch.createStatement();
ResultSet result = stat.executeQuery(sql);
if(!result.next())
{
JOptionPane.showMessageDialog(null,"您输入的活期帐号不存在，请确认后重新输入！","出错",JOptionPane.ERROR_MESSAGE);
accountField.setText("");
passwordField.setText("");
}
else
{
String sql1 = "select * from deAccount where accountID = '"+accountID+"' and accountType='CU' and accountPassword='"+password+"'";
// String sql = "select * from deAccount where state='EF' and accountID = '"+accountID+"' and accountType='CU' and accountPassword='"+password+"'";
ResultSet result1 = stat.executeQuery(sql1);
if(!result1.next())
{
JOptionPane.showMessageDialog(null,"您输入的密码，请确认后重新输入！","出错",JOptionPane.ERROR_MESSAGE);
accountField.setText("");
passwordField.setText("");
}
else
{
String sql2 = "select * from deAccount where state='EF' and accountID = '"+accountID+"' and accountType='CU' and accountPassword='"+password+"'";
ResultSet result2 = stat.executeQuery(sql2);
if(!result2.next())
{
JOptionPane.showMessageDialog(null,"您输入的帐号被挂失了，请确认后重新输入！","出错",JOptionPane.ERROR_MESSAGE);
passwordField.setText("");
}
else
{
String sql3 = "select * from deAccount where state='EF' and accountID = '"+accountID+"' and accountType='CU' and accountPassword='"+password+"' and accountSum >"+sum;
ResultSet result3 = stat.executeQuery(sql3);
if(!result3.next())
{
JOptionPane.showMessageDialog(null,"您输入的帐户余额不足，请确认后重新输入！","出错",JOptionPane.ERROR_MESSAGE);
sumField.setText("");
}
else
{
proc = currentFetch.prepareCall("{ call CurrentFetchMoney(?,?,?,?) }");
proc.setString(1, staffID);
proc.setString(2, accountID);
proc.setString(3, name);
proc.setInt(4, sum);
proc.execute();
this.dispose();
proc.close();
currentFetch.close();
}
}
}
}
}
catch(Exception insertAccountException)
{
insertAccountException.printStackTrace();
}
}//GEN-LAST:event_confirmButtonActionPerformed
//重置事件代码
private void resetButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_resetButtonActionPerformed
// TODO 将在此处添加您的处理代码：
accountField.setText("");
passwordField.setText("");
nameField.setText("");
sumField.setText("");
}//GEN-LAST:event_resetButtonActionPerformed
//取消事件代码
private void cancelButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cancelButtonActionPerformed
// TODO 将在此处添加您的处理代码：
this.dispose();
try
{
currentFetch.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}//GEN-LAST:event_cancelButtonActionPerformed
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new CurrentFetch(" 00007").setVisible(true);
}
});
}
//连接数据库操作－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
private void connectDB()
{
String dbUrl = "jdbc:odbc:afei";
String user = "scott";
String password = "tiger";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
currentFetch = DriverManager.getConnection(dbUrl,user,password);
}
catch(Exception connectException)
{
connectException.printStackTrace();
}
}
// 变量声明 - 不进行修改//GEN-BEGIN:variables
private javax.swing.JTextField accountField;
private javax.swing.JButton cancelButton;
private javax.swing.JButton confirmButton;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JTextField nameField;
private javax.swing.JPasswordField passwordField;
private javax.swing.JButton resetButton;
private javax.swing.JTextField sumField;
// 变量声明结束//GEN-END:variables
private Connection currentFetch;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -