数据库应用-java+sqlserver(十二）TeaInfo

TeaInfo：

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

public class TeaInfo extends JPanel implements ActionListener
{
    static JLabel jid,jname,jsex,jbirth,jpost,jdepart;
    JButton b;
    //ModifyPassword modify;
    TeaInfo(MyFrame f)
    {
        setLayout(new BorderLayout());
        //modify=new ModifyPassword(f,"修改密码",true);
        
        jid=new JLabel();
        jname=new JLabel();
        jsex=new JLabel();
        jbirth=new JLabel();
        jpost=new JLabel();
        jdepart=new JLabel();
        
        JPanel p=new JPanel();
        b=new JButton("修改密码");
        b.addActionListener(this);
        p.add(b);
        add(p,BorderLayout.SOUTH);
        initInstance(this);
    }
    private void initInstance(Object obj)
    {
        Box base=Box.createHorizontalBox();
        Box left=Box.createVerticalBox();
        Box right=Box.createVerticalBox();
        JPanel p11=new JPanel(),
               p12=new JPanel(),
               p13=new JPanel(),
               p14=new JPanel(),
               p15=new JPanel();
               
        JPanel p21=new JPanel(),
               p22=new JPanel(),
               p23=new JPanel(),
               p24=new JPanel(),
               p25=new JPanel();
        
        p11.add(new JLabel("教师编号："));
        p21.add(jid);
        p12.add(new JLabel("教师姓名："));
        p22.add(jname);
        p13.add(new JLabel("教师性别："));
        p23.add(jsex);
        p14.add(new JLabel("教师生日："));
        p24.add(jbirth);
        p15.add(new JLabel("教师职称："));
        p25.add(jpost);
        
        
        left.add(Box.createVerticalStrut(30));
        left.add(p11);
        left.add(Box.createVerticalStrut(10));
        left.add(p12);
        left.add(Box.createVerticalStrut(10));
        left.add(p13);
        left.add(Box.createVerticalStrut(10));
        left.add(p14);
        left.add(Box.createVerticalStrut(10));
        left.add(p15);
        left.add(Box.createVerticalStrut(10));
        
        right.add(Box.createVerticalStrut(30));
        right.add(p21);
        right.add(Box.createVerticalStrut(10));
        right.add(p22);
        right.add(Box.createVerticalStrut(10));
        right.add(p23);
        right.add(Box.createVerticalStrut(10));
        right.add(p24);
        right.add(Box.createVerticalStrut(10));
        right.add(p25);
        right.add(Box.createVerticalStrut(10));
        
        base.add(new JPanel());
        base.add(new JPanel());
        base.add(new JPanel());
        base.add(new JPanel());
        base.add(new JPanel());
        base.add(left);
        base.add(right);
        base.add(new JPanel());
        base.add(new JPanel());
        base.add(new JPanel());
        base.add(new JPanel());
        base.add(new JPanel());
        this.add(base,BorderLayout.CENTER);
    }
    public void actionPerformed(ActionEvent e)
    {
        //modify.setVisible(true);
    }
    public static void saveTea(String id)
    {
        SqlManager DBm=SqlManager.createInstance();
        DBm.connectDB();
        String sql="exec ProcTeacher'"+id+"'";
        ResultSet rs=DBm.executeQuery(sql);
        System.out.println(sql);
        try{
            rs.next();
            System.out.println(rs.getString(1)+"是是是 是");
            jid.setText(rs.getString(1));
            jname.setText(rs.getString(2));
            jsex.setText(rs.getString(3));
            jbirth.setText(rs.getString(4));
            jpost.setText(rs.getString(5));
            jdepart.setText(rs.getString(6));
            
        }catch(SQLException e){
            e.printStackTrace();
        }
    }
}

转载于:https://www.cnblogs.com/1997Ff/p/7365208.html