📄 bankmanager.java
字号:
{null, null, null, null, null, null, null, null, null},
{null, null, null, null, null, null, null, null, null},
{null, null, null, null, null, null, null, null, null},
{null, null, null, null, null, null, null, null, null},
{null, null, null, null, null, null, null, null, null},
{null, null, null, null, null, null, null, null, null}
},
new String [] {
"编号", "贷款人账号", "贷款人姓名", "贷款金额", "贷款日期", "还款日期", "贷款时间", "利率", "是否还款"
}
));
jScrollPane2.setViewportView(loanTable);
org.jdesktop.layout.GroupLayout loanPanelLayout = new org.jdesktop.layout.GroupLayout(loanPanel);
loanPanel.setLayout(loanPanelLayout);
loanPanelLayout.setHorizontalGroup(
loanPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(jScrollPane2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
);
loanPanelLayout.setVerticalGroup(
loanPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(loanPanelLayout.createSequentialGroup()
.add(jScrollPane2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 454, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
loanPanel.getAccessibleContext().setAccessibleParent(jScrollPane);
jScrollPane1.setViewportView(customerList);
org.jdesktop.layout.GroupLayout customerPanelLayout = new org.jdesktop.layout.GroupLayout(customerPanel);
customerPanel.setLayout(customerPanelLayout);
customerPanelLayout.setHorizontalGroup(
customerPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(customerPanelLayout.createSequentialGroup()
.add(customerPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 577, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(loanPanel, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
.addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
customerPanelLayout.setVerticalGroup(
customerPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(customerPanelLayout.createSequentialGroup()
.add(customerPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 527, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(loanPanel, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
.addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jScrollPane.setViewportView(customerPanel);
applyLoanBtn.setText("\u5ba1\u6279\u8d37\u6b3e");
applyLoanBtn.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
applyLoanBtnMouseClicked(evt);
}
});
jMenu1.setText("\u64cd\u4f5c");
customer.setText("\u7528\u6237\u53cd\u9988");
customer.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
customerActionPerformed(evt);
}
});
customer.addMouseListener(new java.awt.event.MouseAdapter() {
public void mousePressed(java.awt.event.MouseEvent evt) {
customerMousePressed(evt);
}
});
jMenu1.add(customer);
loanItem.setText("\u67e5\u770b\u8d37\u6b3e");
loanItem.addMouseListener(new java.awt.event.MouseAdapter() {
public void mousePressed(java.awt.event.MouseEvent evt) {
loanItemMousePressed(evt);
}
});
jMenu1.add(loanItem);
applyLoanItem.setText("\u5ba1\u6279\u8d37\u6b3e");
applyLoanItem.addMouseListener(new java.awt.event.MouseAdapter() {
public void mousePressed(java.awt.event.MouseEvent evt) {
applyLoanItemMousePressed(evt);
}
});
jMenu1.add(applyLoanItem);
staffItem.setText("\u804c\u5de5\u7ba1\u7406");
staffItem.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
staffItemActionPerformed(evt);
}
});
jMenu1.add(staffItem);
exitItem.setText("\u9000\u51fa");
exitItem.addMouseListener(new java.awt.event.MouseAdapter() {
public void mousePressed(java.awt.event.MouseEvent evt) {
exitItemMousePressed(evt);
}
});
jMenu1.add(exitItem);
jMenuBar1.add(jMenu1);
setJMenuBar(jMenuBar1);
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, false)
.add(exitBtn, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.add(staffBtn, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.add(loanBtn, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.add(customerBtn, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 95, Short.MAX_VALUE)
.add(applyLoanBtn, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.add(27, 27, 27)
.add(jScrollPane, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 594, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(layout.createSequentialGroup()
.add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(layout.createSequentialGroup()
.add(38, 38, 38)
.add(customerBtn)
.add(35, 35, 35)
.add(loanBtn)
.add(37, 37, 37)
.add(applyLoanBtn)
.add(41, 41, 41)
.add(staffBtn)
.add(44, 44, 44)
.add(exitBtn))
.add(jScrollPane, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 541, Short.MAX_VALUE))
.addContainerGap())
);
pack();
}// </editor-fold>//GEN-END:initComponents
private void adoptBtnMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_adoptBtnMouseClicked
int row=applyLoanTable.getSelectedRow();
String account=String.valueOf(applyLoanTable.getValueAt(row,0));
String name=String.valueOf(applyLoanTable.getValueAt(row,1));
double money=Double.parseDouble(String.valueOf(applyLoanTable.getValueAt(row,2)));
int time=Integer.parseInt(String.valueOf(applyLoanTable.getValueAt(row,4)));
double interest=Double.parseDouble(String.valueOf(applyLoanTable.getValueAt(row,5)));
String what=bank.loan(account,name,money,time,interest);
if(what.equals("exit")){
JOptionPane.showMessageDialog(this,"对不起，该用户已经贷款过不能再批准,本次视为拒绝处理");
}
else if(what.equals("fail")){
JOptionPane.showConfirmDialog(this,"操作失败，无法获得批准");
}
else{
JOptionPane.showMessageDialog(this,"该请求被成功审批，贷款成功");
}
try{
bank.connection();
PreparedStatement ps=bank.serverCon.prepareStatement("DELETE from ToLoan WHERE 贷款人账号 = ?");
ps.setString(1,String.valueOf(applyLoanTable.getValueAt(row,0)));
ps.executeUpdate();
ps.close();
bank.serverCon.close();
DefaultTableModel dm=(DefaultTableModel)applyLoanTable.getModel();
dm.removeRow(row);
applyLoanFresh();
}
catch(SQLException e){
System.out.println("SQLException:"+e.getMessage()+"\n"+"At bankManager class while adoptBtn is clicked.");
}
}//GEN-LAST:event_adoptBtnMouseClicked
private void refuseBtnMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_refuseBtnMouseClicked
bank.connection();
try{
int row=applyLoanTable.getSelectedRow();
PreparedStatement ps=bank.serverCon.prepareStatement("DELETE from ToLoan WHERE 贷款人账号 = ?");
ps.setString(1,String.valueOf(applyLoanTable.getValueAt(row,0)));
ps.executeUpdate();
ps.close();
bank.serverCon.close();
DefaultTableModel dm=(DefaultTableModel)applyLoanTable.getModel();
dm.removeRow(row);
applyLoanFresh();
JOptionPane.showMessageDialog(this,"拒绝该贷款成功");
}
catch(SQLException e){
System.out.println("SQLException:"+e.getMessage()+"\n"+"At bankManager class while refuseBtn is clicked.");
}
}//GEN-LAST:event_refuseBtnMouseClicked
/** 自定义
*/
private void applyLoanFresh()
{
adoptBtn.setEnabled(true);
refuseBtn.setEnabled(true);
bank.connection();
try{
Statement st=bank.serverCon.createStatement();
ResultSet rs=st.executeQuery("select * from ToLoan");
int row=0;
while(rs.next()){
applyLoanTable.setValueAt(rs.getString("贷款人账号"),row,0);
applyLoanTable.setValueAt(rs.getString("贷款人姓名"),row,1);
applyLoanTable.setValueAt(rs.getDouble("贷款金额"),row,2);
applyLoanTable.setValueAt(rs.getString("申请日期"),row,3);
applyLoanTable.setValueAt(rs.getInt("贷款时间"),row,4);
applyLoanTable.setValueAt(rs.getDouble("利率"),row,5);
row++;
}
///////////
System.out.println("this is in applyLoanFresh() method"+"row:"+row);
if(row==0){
adoptBtn.setEnabled(false);
refuseBtn.setEnabled(false);
}
bank.serverCon.close();
}
catch(SQLException e){
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -