学生管理系统（三）

第三：主界面实现代码：

package com.sc.test3;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.*;/** * 学生管理的主界面 * @author ZhangShaoWen * */public class StuManage extends JFrame implements ActionListener{//定义控件JLabel jl1;JTextField jtf1;JButton jb1,jb2,jb3,jb4;JScrollPane jsp;JTable jt;JPanel jp1,jp2;StuModel sm;public static void main(String[] args) {StuManage s = new StuManage();}//构造函数public StuManage(){//构建第一个jpaneljp1 = new JPanel();jl1 = new JLabel("请输入名字");jtf1 = new JTextField(10);jb1 = new JButton("查询");jb1.addActionListener(this);//注册监听  //把控件加入到jp1jp1.add(jl1);jp1.add(jtf1);jp1.add(jb1);//构建第二个JPaneljp2 = new JPanel();jb2 = new JButton("添加");jb2.addActionListener(this);//添加按钮注册监听jb3 = new JButton("修改");jb3.addActionListener(this);//修改按钮注册监听jb4 = new JButton("删除");jb4.addActionListener(this);//删除按钮注册监听  //把控件加入到jp2jp2.add(jb2);jp2.add(jb3);jp2.add(jb4);//创建一个数据库模型对象sm = new StuModel();String paras[] = {"1"};sm.queryStu("select * from stu where 1=?", paras);//初始化jtjt = new JTable(sm);//初始化jspjsp = new JScrollPane(jt);this.add(jsp);this.add(jp1,"North");this.add(jp2,"South");this.setSize(400,300);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setVisible(true);}//监听器@Overridepublic void actionPerformed(ActionEvent e) {//判断点击的按钮//当点击查询按钮时if(e.getSource()==jb1){String name = jtf1.getText();String sql = "select * from stu where stuName=?";String paras[] = {name};sm = new StuModel();sm.queryStu(sql, paras);//jt.setModel(sm);}//当点击添加按钮时if(e.getSource()==jb2){StuAddDialog stua = new StuAddDialog(this,"添加学生",true);//创建新的数据模型，并更新sm = new StuModel();String[] paras = {"1"};sm.queryStu("select * from stu where 1=?", paras);//更新JTablejt.setModel(sm);}//当点击修改按钮时if(e.getSource()==jb3){StuModel temp = new StuModel();sm = new StuModel();//得到行号int rowNums = this.jt.getSelectedRow();if(rowNums==-1){JOptionPane.showMessageDialog(this,"请选择一行");}new StuUpDialog(this,"修改信息",true,sm,rowNums);String []paras = {"1"};sm.queryStu("select * from stu where 1=?", paras);jt.setModel(sm);}//当点击删除按钮时if(e.getSource()==jb4){//得到行号int rowNums = this.jt.getSelectedRow();if(rowNums==-1){JOptionPane.showMessageDialog(this,"请选择一行");return ;}//得到学生的学号String stuNo = (String)sm.getValueAt(rowNums, 0);String paras[]={stuNo,"1"};StuModel temp = new StuModel();temp.updStu("delete from stu where stuId=? and 1=?", paras);//创建新的数据模型sm = new StuModel();String[] paras2={"1"};sm.queryStu("select * from stu where 1=?", paras2);//更新JTablejt.setModel(sm);}}}