📄 maintainpersonalplanframe.java~51~
字号:
package homerealtysystem;
import com.borland.dbswing.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import com.borland.jbcl.layout.*;
import java.sql.*;
import com.borland.dx.sql.dataset.*;
import java.sql.ResultSet;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.*;
import javax.swing.border.*;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2005</p>
* <p>Company: </p>
* @author 刘庆
* @version 1.0
*/
public class MaintainPersonalPlanFrame extends JFrame {
JPanel jPanel1 = new JPanel();
JButton jButton2 = new JButton();
JButton jButton1 = new JButton();
XYLayout xYLayout1 = new XYLayout();
DBbean db=new DBbean(); //实例化dbBean
ResultSet rs=null; //定义一结果集
ErrorMessage em=new ErrorMessage(); //出错处理
JLabel jLabel1 = new JLabel();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JLabel jLabel4 = new JLabel();
JLabel jLabel5 = new JLabel();
JLabel jLabel6 = new JLabel();
JLabel jLabel7 = new JLabel();
JLabel jLabel8 = new JLabel();
JLabel jLabel9 = new JLabel();
JLabel jLabel10 = new JLabel();
JLabel jLabel11 = new JLabel();
JLabel jLabel12 = new JLabel();
JLabel jLabel13 = new JLabel();
// JLabel jLabel16 = new JLabel(new ImageIcon(".\\test.jpg"));
JTextField jTextField1 = new JTextField();
JTextField jTextField2 = new JTextField();
JTextField jTextField3 = new JTextField();
JTextField jTextField4 = new JTextField();
JTextField jTextField5 = new JTextField();
JTextField jTextField6 = new JTextField();
JPasswordField jPasswordField1 = new JPasswordField();
JTextField jTextField7 = new JTextField();
JTextField jTextField9 = new JTextField();
JTextField jTextField10 = new JTextField();
JTextArea jTextArea1 = new JTextArea();
JTextArea jTextArea2 = new JTextArea();
JTextArea jTextArea3 = new JTextArea();
JLabel jLabel16 = new JLabel(new ImageIcon(".\\test.jpg"));
String CurrentUser = new String();
public MaintainPersonalPlanFrame(String Username) throws HeadlessException {
CurrentUser = Username;
try {
jbInit();
}
catch(Exception e) {
e.printStackTrace();
}
}
private void jbInit() throws Exception {
this.getContentPane().setLayout(xYLayout1);
jPanel1.setFont(new java.awt.Font("Dialog", 0, 16));
jPanel1.setDebugGraphicsOptions(0);
jPanel1.setLayout(null);
jButton2.setBounds(new Rectangle(417, 421, 113, 31));
jButton2.setFont(new java.awt.Font("Dialog", 0, 16));
jButton2.setText("取消并返回");
jButton2.addActionListener(new MaintainPersonalPlanFrame_jButton2_actionAdapter(this));
jButton1.setBounds(new Rectangle(77, 421, 113, 31));
jButton1.setFont(new java.awt.Font("Dialog", 0, 16));
jButton1.setText("修改并保存");
jButton1.addActionListener(new MaintainPersonalPlanFrame_jButton1_actionAdapter(this));
this.setLocale(java.util.Locale.getDefault());
xYLayout1.setWidth(683);
xYLayout1.setHeight(480);
jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel1.setText("用户ID");
jLabel1.setBounds(new Rectangle(28, 25, 68, 23));
jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel2.setText("用户名字");
jLabel2.setBounds(new Rectangle(26, 57, 73, 17));
jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel3.setText("密码");
jLabel3.setBounds(new Rectangle(35, 83, 47, 17));
jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel4.setText("身份证号");
jLabel4.setBounds(new Rectangle(25, 108, 81, 22));
jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel5.setText("联系电话");
jLabel5.setBounds(new Rectangle(25, 139, 91, 18));
jLabel6.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel6.setText("地址");
jLabel6.setBounds(new Rectangle(25, 165, 81, 23));
jLabel7.setBounds(new Rectangle(25, 225, 81, 23));
jLabel7.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel7.setText("银行卡号码");
jLabel8.setBounds(new Rectangle(25, 196, 91, 18));
jLabel8.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel8.setText("信用等级");
jLabel9.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel9.setText("个人购房计划1");
jLabel9.setBounds(new Rectangle(307, 18, 146, 18));
jLabel10.setBounds(new Rectangle(46, 284, 61, 23));
jLabel10.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel10.setText("EMail");
jLabel11.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel11.setToolTipText("");
jLabel11.setText("个人购房计划2");
jLabel11.setBounds(new Rectangle(301, 106, 134, 23));
jLabel12.setBounds(new Rectangle(15, 258, 112, 18));
jLabel12.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel12.setText("查询参考条件");
jLabel13.setBounds(new Rectangle(301, 196, 141, 23));
jLabel13.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel13.setText("个人购房计划3");
jLabel16.setText("jLabel14");
jLabel16.setBounds(new Rectangle(257, 292, 253, 100));
jTextField1.setFont(new java.awt.Font("Dialog", 0, 16));
jTextField1.setPreferredSize(new Dimension(11, 28));
jTextField1.setEditable(false);
jTextField1.setScrollOffset(0);
jTextField1.setBounds(new Rectangle(115, 24, 133, 24));
jTextField2.setBounds(new Rectangle(114, 192, 133, 24));
jTextField2.setFont(new java.awt.Font("Dialog", 0, 16));
jTextField3.setBounds(new Rectangle(115, 51, 133, 24));
jTextField3.setFont(new java.awt.Font("Dialog", 0, 16));
jTextField4.setFont(new java.awt.Font("Dialog", 0, 16));
jTextField4.setBounds(new Rectangle(114, 160, 133, 24));
jTextField5.setBounds(new Rectangle(114, 107, 133, 24));
jTextField5.setFont(new java.awt.Font("Dialog", 0, 16));
jTextField6.setFont(new java.awt.Font("Dialog", 0, 16));
jTextField6.setBounds(new Rectangle(114, 134, 133, 24));
jPasswordField1.setFont(new java.awt.Font("Dialog", 0, 16));
jPasswordField1.setBounds(new Rectangle(114, 78, 134, 24));
jTextField7.setBounds(new Rectangle(113, 254, 133, 24));
jTextField7.setFont(new java.awt.Font("Dialog", 0, 16));
jTextField9.setFont(new java.awt.Font("Dialog", 0, 16));
jTextField9.setBounds(new Rectangle(113, 222, 133, 24));
jTextField10.setBounds(new Rectangle(113, 280, 133, 24));
jTextField10.setFont(new java.awt.Font("Dialog", 0, 16));
jTextArea1.setFont(new java.awt.Font("Dialog", 0, 16));
jTextArea1.setText("");
jTextArea1.setLineWrap(true);
jTextArea1.setBounds(new Rectangle(302, 41, 359, 57));
jTextArea2.setBounds(new Rectangle(301, 128, 359, 57));
jTextArea2.setFont(new java.awt.Font("Dialog", 0, 16));
jTextArea2.setText("");
jTextArea2.setLineWrap(true);
jTextArea3.setBounds(new Rectangle(298, 223, 359, 57));
jTextArea3.setFont(new java.awt.Font("Dialog", 0, 16));
jTextArea3.setText("");
jTextArea3.setLineWrap(true);
jLabel16.setText("jLabel14");
jLabel16.setBounds(new Rectangle(329, 334, 181, 70));
jPanel1.add(jButton1, null);
jPanel1.add(jButton2, null);
jPanel1.add(jLabel1, null);
jPanel1.add(jLabel2, null);
jPanel1.add(jLabel4, null);
jPanel1.add(jLabel5, null);
jPanel1.add(jLabel3, null);
jPanel1.add(jLabel6, null);
jPanel1.add(jLabel8, null);
jPanel1.add(jLabel7, null);
jPanel1.add(jLabel10, null);
jPanel1.add(jLabel16, null);
jPanel1.add(jLabel9, null);
jPanel1.add(jLabel13, null);
jPanel1.add(jTextField1, null);
jPanel1.add(jTextField3, null);
jPanel1.add(jTextField4, null);
jPanel1.add(jTextField6, null);
jPanel1.add(jTextField5, null);
jPanel1.add(jTextField2, null);
jPanel1.add(jPasswordField1, null);
jPanel1.add(jTextField9, null);
jPanel1.add(jLabel12, null);
jPanel1.add(jTextField10, null);
jPanel1.add(jTextField7, null);
jPanel1.add(jLabel11, null);
jPanel1.add(jTextArea1, null);
jPanel1.add(jTextArea2, null);
jPanel1.add(jTextArea3, null);
jPanel1.add(jLabel16, null);
this.getContentPane().add(jPanel1, new XYConstraints(4, 4, 664, 457));
pack();
getInfo();
}
void getInfo()
{
try {
rs = db.executeQuery("select * from 用户信息表 where 用户信息表.\"用户名字\"='" +
CurrentUser + "'");
if (!rs.next()) { //判断是否存在
JOptionPane.showMessageDialog(MaintainPersonalPlanFrame.this, "内部错误：用户名丢失",
"内部错误：用户名丢失", 1);
}
else {
rs.previous(); // 使指针返回到ResultSet对象的开始
ResultSetMetaData data = rs.getMetaData(); // 定义ResultSetMetaData对象data
int col = data.getColumnCount(); // 获取列数
while (rs.next()) { // 显示数据
for (int i = 1; i <= col; i++) {
switch(i)
{
case 1: jTextField1.setText(rs.getString(i));break;
case 2: jTextField3.setText(rs.getString(i));break;
case 3: jPasswordField1.setText(rs.getString(i));break;
case 4: jTextField5.setText(rs.getString(i));break;
case 5: jTextField6.setText(rs.getString(i));break;
case 6: jTextField4.setText(rs.getString(i));break;
case 7: jTextField2.setText(rs.getString(i));break;
case 8: jTextField9.setText(rs.getString(i));break;
case 9: jTextField7.setText(rs.getString(i));break;
case 10: jTextField10.setText(rs.getString(i));break;
case 11: jTextArea1.setText(rs.getString(i));break;
case 12: jTextArea2.setText(rs.getString(i));break;
case 13: jTextArea3.setText(rs.getString(i));break;
default:
JOptionPane.showMessageDialog(MaintainPersonalPlanFrame.this, "内部错误：多余的数据库信息 : " + rs.getString(i),
"内部错误：多余的数据库信息 : " + rs.getString(i), 1);
}
}
}
rs.close(); // 关闭结果集
}
}
catch (SQLException ex) { // 捕捉异常
System.out.println("\nERROR:----- SQLException -----\n");
while (ex != null) {
System.out.println("Message: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
ex = ex.getNextException();
}
}
}
void jButton2_actionPerformed(ActionEvent e) {
GetFrmLocation gfl=new GetFrmLocation();//实例化GetFrmLocatin
UserMainFrame frame=new UserMainFrame(CurrentUser);//实例化下一个frame
gfl.get_location(frame); //让frame显示在屏幕中心
frame.show(); //frame的显示
this.dispose(); //本窗体的退出
}
void jButton1_actionPerformed(ActionEvent e) {
try {
rs = db.executeQuery("select * from 用户信息表 where 用户信息表.\"用户ID\"=" + Long.valueOf(jTextField1.getText()));
if (!rs.next()) { //判断是否存在
JOptionPane.showMessageDialog(MaintainPersonalPlanFrame.this, "内部错误：用户ID错误 ：" + Long.valueOf(jTextField1.getText()),
"内部错误：用户ID错误 ：" + Long.valueOf(jTextField1.getText()), 1);
}
else {
rs.close(); // 关闭结果集
db.executeQuery("update 用户信息表 set 用户名字 = '" + jTextField3.getText() + "'," +
"密码 = '" + jPasswordField1.getText() + "'," +
"身份证号 = '" + jTextField5.getText() + "'," +
"联系电话 = '" + jTextField6.getText() + "'," +
"地址 = '" + jTextField4.getText() + "'," +
"信用等级 = '" + jTextField2.getText() + "'," +
"银行卡号码 = '" + jTextField9.getText() + "'," +
"查询参考条件 = '" + jTextField7.getText() + "'," +
"EMail = '" + jTextField10.getText() + "'," +
"个人购房计划1 = '" + jTextArea1.getText() + "'," +
"个人购房计划2 = '" + jTextArea2.getText() + "'," +
"个人购房计划3 = '" + jTextArea3.getText() + "'" +
"where 用户ID = " + Long.valueOf(jTextField1.getText()));
JOptionPane.showMessageDialog(MaintainPersonalPlanFrame.this, "修改成功!",
"修改成功!", 1);
}
}
catch (SQLException ex) { // 捕捉异常
System.out.println("\nERROR:----- SQLException -----\n");
while (ex != null) {
System.out.println("Message: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
ex = ex.getNextException();
}
}
GetFrmLocation gfl=new GetFrmLocation();//实例化GetFrmLocatin
UserMainFrame frame=new UserMainFrame(CurrentUser);//实例化下一个frame
gfl.get_location(frame); //让frame显示在屏幕中心
frame.show(); //frame的显示
this.dispose(); //本窗体的退出
}
}
class MaintainPersonalPlanFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
MaintainPersonalPlanFrame adaptee;
MaintainPersonalPlanFrame_jButton1_actionAdapter(MaintainPersonalPlanFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class MaintainPersonalPlanFrame_jButton2_actionAdapter implements java.awt.event.ActionListener {
MaintainPersonalPlanFrame adaptee;
MaintainPersonalPlanFrame_jButton2_actionAdapter(MaintainPersonalPlanFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -