Connection con; //声明SQL语句对象 Statement st;
//创建组件对象：标签、文本行、单选
JLabel jLabel1=new JLabel(\请输入职工的编号：\JTextField jTextField1=new JTextField(); JButton jButton1=new JButton(\查找该职工\JLabel jLabel2=new JLabel(\职工编号:\JTextField jTextField2=new JTextField(); JLabel jLabel3=new JLabel(\职工姓名:\JTextField jTextField3=new JTextField(); JLabel jLabel4=new JLabel(\职工性别:\JTextField jTextField4=new JTextField(); JLabel jLabel5=new JLabel(\职工年龄:\JTextField jTextField5=new JTextField(); JLabel jLabel6=new JLabel(\家庭住址:\JTextField jTextField6=new JTextField(); JLabel jLabel7=new JLabel(\联系电话:\JTextField jTextField7=new JTextField(); JButton jButton2=new JButton(\修改职工信息\//构造方法
public ModifyEmployee()
{ }
//面板初始化方法
private void jbInit() throws Exception {
//连接数据库
con=DBConnect.getConn(); st=con.createStatement(); //框架的布局 this.setLayout(null); //设置各组件的大小
jLabel1.setFont(new java.awt.Font(\楷体try{ }
catch(Exception exception){ }
exception.printStackTrace(); //调用初始化方法 jbInit();
\
jLabel1.setBounds(new Rectangle(40,15,140,30)); jTextField1.setBounds(new Rectangle(185,15,120,30));
jButton1.setBounds(new Rectangle(110,55,150,30)); jLabel2.setFont(new java.awt.Font(\楷体
\
jLabel2.setBounds(new Rectangle(20,105,80,30)); jTextField2.setBounds(new Rectangle(100,105,80,30)); jLabel3.setFont(new java.awt.Font(\楷体
\
jLabel3.setBounds(new Rectangle(190,105,80,30)); jTextField3.setBounds(new Rectangle(270,105,80,30)); jLabel4.setFont(new java.awt.Font(\楷体
\
jLabel4.setBounds(new Rectangle(20,145,80,30)); jTextField4.setBounds(new Rectangle(100,145,80,30)); jLabel5.setFont(new java.awt.Font(\楷体
\
jLabel5.setBounds(new Rectangle(190,145,80,30)); jTextField5.setBounds(new Rectangle(270,145,80,30)); jLabel6.setFont(new java.awt.Font(\楷体
\
jLabel6.setBounds(new Rectangle(20,185,80,30)); jTextField6.setBounds(new Rectangle(100,185,80,30)); jLabel7.setFont(new java.awt.Font(\楷体
\
jLabel7.setBounds(new Rectangle(190,185,80,30)); jTextField7.setBounds(new Rectangle(270,185,80,30)); jButton2.setBounds(new Rectangle(120,240,150,30)); //添加按钮动作事件
jButton1.addActionListener(this); jButton2.addActionListener(this); //添加组件到面板 this.add(jLabel1); this.add(jTextField1); this.add(jButton1); this.add(jLabel2); this.add(jTextField2); jTextField2.setEditable(false); this.add(jLabel3); this.add(jTextField3); this.add(jLabel4); this.add(jTextField4); this.add(jLabel5); this.add(jTextField5); this.add(jLabel6); this.add(jTextField6);
}
this.add(jLabel7); this.add(jTextField7); this.add(jButton2);
//点击按钮事件
public void actionPerformed(ActionEvent actionevent) {
//点击“查找该职工”按钮 if(actionevent.getSource()==jButton1) { try{
//利用st对象执行SQL语句，返回结果集对象 ResultSet rs=st.executeQuery(\
Employee where EmployeeID='\
//处理结果集 if(rs.next()) {
jTextField2.setText(rs.getString(\
jTextField3.setText(rs.getString(\