# 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<String> columNames = null;  //表的字段名称  
    Vector<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<String>();  //表的字段名称  
       rowDate = new Vector<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();//关闭对话框  
        }  
    }  
  

}