yhcxglxt

学生信息管理系统源程序清单： //StuMange.java程序清单 package keshe; import java.awt.BorderLayout; import java.awt.Panel; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException;

import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField;

public class StuMange extends JFrame implements ActionListener{ //定义用户界面用到的组件
JLabel userName = null; //要查询的学生的名字
JTextField textField = null; //用户输入的文本框
JButton select = null; //查询按钮
JButton insert = null; //添加按钮
JButton update = null; //修改按钮
JButton delete = null; //删除按钮
JTable table = null; //用于显示数据库调出的数据的表
Panel panel1 = null;
Panel panel2 = null;
Panel panel3 = null;
JScrollPane jscrollPane = null;

StModel stModel = null;  //st表的模型  
private Object PreparedStatement;  
public StuMange()  
{  
    //窗口显示的上部的组件  
    userName = new JLabel("学生名：");  
    textField = new JTextField(10);   //用户输入文本框限定为最多输入10个字符  
    select = new JButton("查询");   //查询按钮  
    //添加到第一个面板中   
    panel1 = new Panel();  
    panel1.add(userName);  
    panel1.add(textField);  
    panel1.add(select);  
      
    //窗口下部的组件  
    insert = new JButton("添加");  
    delete = new JButton("删除");  
    update = new JButton("修改");  
    //添加到第三个个面板中  
    panel3 = new Panel();  
    panel3.add(insert);  
    panel3.add(delete);  
    panel3.add(update);  
      
    //窗口中部的组件  
      stModel = new StModel();  
      stModel.insertDatabase("select * from st");  
     table = new JTable(stModel);  
     jscrollPane = new JScrollPane(table);  
       
     //注册事件监听  
     select.addActionListener(this);  
     insert.addActionListener(this);  
     update.addActionListener(this);  
     delete.addActionListener(this);  
       
      
  //将各个组件添加到窗体中  
    this.add(panel1, BorderLayout.NORTH);  
    this.add(jscrollPane, BorderLayout.CENTER);  
    this.add(panel3, BorderLayout.SOUTH);  
      
    //设置窗体属性  
    this.setSize(400, 300);  //设置窗口大小  
    this.setLocation(200, 200); //设置窗口显示的位置  
    this.setTitle("学生信息管理系统");  //设置窗口标题  
    this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);  //设置窗口关闭之后其后台程序同时关闭  
    //设置窗口为可见  
    this.setVisible(true);  
      
}  
  
public void actionPerformed(ActionEvent e)  
{  
    //用户点击了查找按钮  
    if(e.getSource() == select)  
    {  
        String paras = textField.getText().trim();  
        stModel = new StModel();  
        stModel.insertDatabase("select * from st where stNname='"+paras+"'");  
        table.setModel(stModel);  
    }     
    //用户点击了添加按钮  
    else if(e.getSource() == insert)  
    {  
        InsertStudent insertStudent = new InsertStudent(this, "添加学生", true);  
          
        //刷新窗口表的数据  
        stModel = new StModel();  
        stModel.insertDatabase("select * from st");  
        table.setModel(stModel);  
    }  
    //用户点击了修改按钮  
    else if(e.getSource() == update)  
    {  
        int row = this.table.getSelectedRow();  //用户选择的行数  
        if(-1 == row) //如果用户没有选中行  
        {  
            JOptionPane.showMessageDialog(this, "请选择一行");  
        }  
        else  
        {  
            UpdateDatabase updateDatabase = new UpdateDatabase(this, "修改学生", true, stModel, row);  
            //刷新窗口表的数据  
            stModel =new StModel();  
            stModel.insertDatabase("select * from st");  
            table.setModel(stModel);  
        }  
    }     
    //用户点击了删除按钮  
    else if(e.getSource() == delete)  
    {  
        //数据库  
        Connection con = null;  
        PreparedStatement ps = null;  
        String driver = "com.mysql.jdbc.Driver"; //jdbc驱动  
        String url = "jdbc:mysql://localhost:3306/student";  //数据源  
        String user = "root";  //数据库用户密码  
        String passWord = "root"; //数据库用户sa的密码  
          
        int row = this.table.getSelectedRow();  //用户选择的行  
        if(-1 == row)   //用户没有选中行  
        {  
            JOptionPane.showMessageDialog(this, "请选择一行");  
        }  
        else  
        {  
            try  
            {  
                //加载jdbc驱动  
                Class.forName(driver);  
                //连接数据源  
                con = DriverManager.getConnection(url, user, passWord);  
                //执行sql  
                String sql = "delete from st where stId=?";  
                String id = (String)(stModel.getValueAt(row, 0));  //获得用户选择的行的学生的学号  
                ps = con.prepareStatement(sql);  
                ps.setString(1, id);  
                ps.executeUpdate();  
                  
                //刷新窗口  
                stModel = new StModel();  
                stModel.insertDatabase("select * from st");  
                table.setModel(stModel);  
                  
            }  
            catch(ClassNotFoundException e1)  
            {  
                e1.printStackTrace();  
            }  
            catch(SQLException e1)  
            {  
                e1.printStackTrace();  
            }  
            finally  
            {  
                //关闭资源  
                try  
                {  
                    if(null != ps)  
                    {  
                        ps.close();  
                    }  
                    if(null != con)  
                    {  
                        con.close();  
                    }  
                }  
                catch(SQLException e1)  
                {  
                    e1.printStackTrace();  
                }  
            }  
              
        }  
    }  
}  

} //------------------------------------------------------------------------------------------------ //StModel.java源程序清单 package keshe;

import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Vector;

import javax.swing.table.AbstractTableModel;

public class StModel extends AbstractTableModel{ Vector columNames = null; //表的字段名称
Vector rowDate = null; //表的数据

//数据库
private Connection con = null;
private PreparedStatement ps = null;
private ResultSet rs = null;
private final static String driver = "com.mysql.jdbc.Driver"; //加载的jdbc驱动
private final static String url = "jdbc:mysql://localhost:3306/student"; //数据源
private final static String user = "root"; //数据库的用户名
private final static String passWord = "root"; //数据库的用户名的密码

//对数据库进行查找
public void insertDatabase(String sql)
{
columNames = new Vector(); //表的字段名称
rowDate = new Vector(); //表的数据

   columNames.add("学号");  
   columNames.add("名字");  
   columNames.add("性别");  
   columNames.add("年龄");  
   columNames.add("籍贯");  
   columNames.add("系别");  
     
   try  
   {  
       //加载jdbc驱动  
       Class.forName(driver);  
       //连接数据源  
       con = DriverManager.getConnection(url,user,passWord);  
       //执行sql  
       ps = con.prepareStatement(sql);  
       rs = ps.executeQuery();  
       while(rs.next())  
       {     
           Vector<String> row = new Vector<String>();  
           row.add(rs.getString(1));  
           row.add(rs.getString(2));  
           row.add(rs.getString(3));  
           row.add(rs.getString(4));  
           row.add(rs.getString(5));  
           row.add(rs.getString(6));  
             
           rowDate.add(row);  //将学生的一条记录（row）添加到rowDate中  
       }         
   }  
   catch(ClassNotFoundException e)  
   {  
       e.printStackTrace();  
   }  
   catch(SQLException e)  
   {  
       e.printStackTrace();  
   }  
   finally  
   {  
       //关闭数据库资源  
       try  
       {  
           if(null != rs)  
           {  
               rs.close();  
           }  
           if(null != ps)  
           {  
               ps.close();  
           }  
           if(null != con)  
           {  
               con.close();  
           }  
       }  
       catch(SQLException e)  
       {  
           e.printStackTrace();  
       }  
   }  

}

@Override
//返回列数
public int getColumnCount() {
return this.columNames.size();
}

@Override
//返回表的行数
public int getRowCount() {
return this.rowDate.size();
}

@Override
//得到某行某列的数据
public Object getValueAt(int rowIndex, int columnIndex) {
return ((Vector)this.rowDate.get(rowIndex)).get(columnIndex);
}
//设置表的字段名
public String getColumnName(int column)
{
return (String)this.columNames.get(column);
}

} //--------------------------------------------------------------------------------------------------------- //Mannager.java源程序清单 package keshe;

public class Mannager { public static void main(String[] agrgs){ StuMange sm = new StuMange(); } } //----------------------------------------------------------------------------------------------------------- //InsertStudent.java源程序清单 package keshe;

import java.awt.BorderLayout; import java.awt.Frame; import java.awt.GridLayout; import java.awt.Panel; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException;

import javax.swing.JButton; import javax.swing.JDialog; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JTextField;

public class InsertStudent extends JDialog implements ActionListener{ private JLabel id, name, sex, age, address, dep; //分别代表学生的学号，名字，性别，年龄，籍贯，系别
private JTextField jtf1, jtf2, jtf3, jtf4, jtf5, jtf6; //用户输入的文本框，分别为学生的学号，名字，性别，年龄，籍贯，系别
private JButton add, canel; //分别为添加按钮和取消按钮
private Panel panel1, panel2, panel3;

public InsertStudent(Frame owner, String title, boolean model)  
{  
    super(owner, title, model);  //实现与父类窗口对话  
    System.out.println("我执行了");  
      
    //窗体的西部的组件  
    id = new JLabel("学号:");  
    name = new JLabel("姓名:");  
    sex = new JLabel("性别");  
    age = new JLabel("年龄");  
    address = new JLabel("籍贯");  
    dep = new JLabel("系别：");  
    //添加到panel1面板中  
    panel1 = new Panel(new GridLayout(6, 1));  
    panel1.add(id);  
    panel1.add(name);  
    panel1.add(sex);  
    panel1.add(age);  
    panel1.add(address);  
    panel1.add(dep);  
      
    //窗体的东部组件  
    jtf1 = new JTextField(10);  
    jtf2 = new JTextField(10);  
    jtf3 = new JTextField(10);  
    jtf4 = new JTextField(10);  
    jtf5 = new JTextField(10);  
    jtf6 = new JTextField(10);  
    //添加到第二个面板中  
    panel2 = new Panel(new GridLayout(6, 1));  
    panel2.add(jtf1);  
    panel2.add(jtf2);  
    panel2.add(jtf3);  
    panel2.add(jtf4);  
    panel2.add(jtf5);  
    panel2.add(jtf6);  
      
    //窗体北部的控件   
    add = new JButton("添加");  
    canel = new JButton("取消");  
      
    //注册事件监听  
    add.addActionListener(this);  
    canel.addActionListener(this);  
      
    //添加到panel3面板中  
    panel3 = new Panel();  
    panel3.add(add);  
    panel3.add(canel);  
      
    //将各个组件添加到窗体中  
    this.add(panel1, BorderLayout.WEST);  
    this.add(panel2, BorderLayout.CENTER);  
    this.add(panel3, BorderLayout.SOUTH);  
      
    //设置对话框属性  
    this.setSize(300, 200);  
    //设置对话框为可见  
    this.setVisible(true);  
}  
  
  
public void actionPerformed(ActionEvent e)  
{  
    //数据库  
    Connection con = null;  
    PreparedStatement ps = null;  
      
    boolean result = true; //记录添加学生是否成功  
      
    if(e.getSource() == add)  
    {  
        try  
        {  
            //加载jdbc驱动  
            Class.forName("com.mysql.jdbc.Driver");  
            //连接数据源  
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student", "root", "root");  
            //执行sql  
            String sql = "insert into st values(?,?,?,?,?,?)";  
            ps = con.prepareStatement(sql);  
              
            ps.setString(1, jtf1.getText());  
            ps.setString(2, jtf2.getText());  
            ps.setString(3, jtf3.getText());  
            ps.setString(4, jtf4.getText());  
            ps.setString(5, jtf5.getText());  
            ps.setString(6, jtf6.getText());  
              
            ps.executeUpdate();  
              
            //关闭对话框  
            this.dispose();  
        }  
        catch(ClassNotFoundException e1)  
        {  
            result = false; //添加学生记录失败  
            e1.printStackTrace();  
        }  
        catch(SQLException e1)  
        {  
            result = false;   //添加学生记录失败  
            e1.printStackTrace();  
        }  
        finally  
        {  
            //关闭资源  
            try  
            {  
                if(null != ps)  
                {  
                    ps.close();  
                }  
                if(null != con)  
                {  
                    con.close();  
                }  
            }  
            catch(SQLException e1)  
            {  
                e1.printStackTrace();  
            }         
        }     
          
        if(false == result)  
        {  
            JOptionPane.showMessageDialog(this, "失败信息：学号不能重复，性别只能为'男'或者'女',年龄大于0");  
        }  
    }  
      
    else if(e.getSource() == canel)  
    {  
        //关闭对话框  
        this.dispose();  
    }  
}  

} //--------------------------------------------------------------------------------------------------------- //UpdateDatabase.java源程序清单 package keshe;

import java.awt.BorderLayout; import java.awt.Frame; import java.awt.GridLayout; import java.awt.Panel; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException;

import javax.swing.JButton; import javax.swing.JDialog; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JTextField;

public class UpdateDatabase extends JDialog implements ActionListener{ JLabel id,name,sex,age,address,dep; //分别为学生的学号，学生的姓名，学生的性别，学生的年龄，学生的籍贯，学生的系别的标签
JTextField jtf1, jtf2, jtf3, jtf4,jtf5, jtf6; //分别为学生的学号，姓名，性别，年龄，籍贯，系列的输入文本框
JButton update,canel; //分别为修改和取消按钮
Panel panel1 ,panel2, panel3;

public UpdateDatabase(Frame own, String title, boolean model, StModel stModel, int row)  
{  
    super(own, title, model); //实现与父类窗口对话  
      
    //窗体西部的组件  
    id = new JLabel("学号");  
    name = new JLabel("名字");  
    sex = new JLabel("性别");  
    age = new JLabel("年龄");  
    address = new JLabel("地址");  
    dep = new JLabel("系别");  
    //添加到panel1中  
    panel1 = new Panel(new GridLayout(6, 1));  
    panel1.add(id);  
    panel1.add(name);  
    panel1.add(sex);  
    panel1.add(age);  
    panel1.add(address);  
    panel1.add(dep);  
      
    //添加到窗体的东部的组件  
    jtf1 = new JTextField(10);  
    jtf1.setText((String)(stModel.getValueAt(row, 0)));  
    jtf1.setEditable(false);//设置学号不可修改  
    jtf2 = new JTextField(10);  
    jtf2.setText((String)(stModel.getValueAt(row, 1)));  
    jtf3 = new JTextField(10);  
    jtf3.setText((String)(stModel.getValueAt(row, 2)));  
    jtf4 = new JTextField(10);  
    jtf4.setText((String)(stModel.getValueAt(row, 3)));  
    jtf5 = new JTextField(10);  
    jtf5.setText((String)(stModel.getValueAt(row, 4)));  
    jtf6 = new JTextField(10);  
    jtf6.setText((String)(stModel.getValueAt(row, 5)));  
    //添加到第二个面板中  
    panel2 = new Panel(new GridLayout(6, 1));  
    panel2.add(jtf1);  
    panel2.add(jtf2);  
    panel2.add(jtf3);  
    panel2.add(jtf4);  
    panel2.add(jtf5);  
    panel2.add(jtf6);  
      
    //窗体南部的组件  
    update = new JButton("确认");  
    canel = new JButton("取消");  
    panel3 = new Panel();  
    panel3.add(update);  
    panel3.add(canel);  
      
    //注册事件监听  
    update.addActionListener(this);  
    canel.addActionListener(this);  
      
    //添加组件到窗体中  
    this.add(panel1, BorderLayout.WEST);  
    this.add(panel2, BorderLayout.CENTER);  
    this.add(panel3, BorderLayout.SOUTH);  

    //设置窗体属性  
    this.setSize(300, 200);  
    //设置窗体为可见  
    this.setVisible(true);  
}  
  
//响应用户操作  
public void actionPerformed(ActionEvent e)  
{  
    //数据库  
    Connection con = null;  
    PreparedStatement ps = null;  
    String driver = "com.mysql.jdbc.Driver";  //jdbc驱动  
    String url = "jdbc:mysql://localhost:3306/student"; //连接数据源  
    String user = "root";  //数据库的用户  
    String passWord = "root"; //数据库的用户密码  
    boolean result = true;   //记录修改学生是否成功  
      
    if(e.getSource() == update)  
    {  
        try  
        {  
            //加载jdbc驱动  
            Class.forName(driver);  
            //连接数据源  
            con = DriverManager.getConnection(url,user,passWord);  
            //执行sql  
            String sql = "update st set stNname=?, stSex=?,stAge=?,stBorn=?,stDept=? where stId=? ";  
            ps = con.prepareStatement(sql);  
            //修改学生数据  
            ps.setString(1, jtf2.getText());  
            ps.setString(2, jtf3.getText());  
            ps.setString(3, jtf4.getText());  
            ps.setString(4, jtf5.getText());  
            ps.setString(5, jtf6.getText());  
            ps.setString(6, jtf1.getText());  
              
            ps.executeUpdate();  
            //关闭对话框  
            this.dispose();  
        }  
        catch(ClassNotFoundException e1)  
        {  
            result = false;  
            e1.printStackTrace();  
        }  
        catch(SQLException e1)  
        {  
            result = false;  
            e1.printStackTrace();  
        }  
        finally  
        {  
            //关闭资源  
            try  
            {  
                if(null != ps)  
                {  
                    ps.close();  
                }  
                if(null != con)  
                {  
                    con.close();  
                }  
            }  
            catch(SQLException e1)  
            {  
                e1.printStackTrace();  
            }  
            if(false == result)  
            {  
                JOptionPane.showMessageDialog(this, "失败信息：学号不能重复，性别只能为'男'或者'女',年龄大于0");  
            }  
              
        }  
    }  
    else if(e.getSource() == canel)  
    {  
        this.dispose();//关闭对话框  
    }  
}  

}