java_student.txt

学生信息管理系统 学生信息管理系统 学生信息管理系统

JAVA项目源码（2）——学生信息管理系统2008-12-20 15:58//学生信息管理界面 
class InfoFrame extends JDialog implements   ActionListener 
{ 
public static final int WIDTH = 1100; 
public static final int HEIGHT = 650; 
int selIndex = 0;//用于获得选中的行，以备修改删除之用 
public JTable table = new JTable(); 
JPanel AddLeft,AlterRight,TableMid; 
DefaultTableModel mm ; 
JLabel addinfo,alterinfo; 
JLabel l_sno,l_sname,l_ssex,l_sage,l_sdorm,l_address;//上半部分文字域 
JTextField lt_sno,lt_sname,lt_ssex,lt_sage,lt_sdorm,lt_address;//上半部分文本域 
JPanel l_snopanel,l_snamepanel,l_ssexpanel,l_sagepanel,l_sdormpanel,l_addresspanel,l_btnpanel;//上半部分功能按钮Panel 
JButton l_Btn;//上半部分的添加按钮 
JPanel l_all;//上半部分Panel 

JLabel m_sno,m_sname,m_ssex,m_sage,m_sdorm,m_address;//下半部分修改删除文字域 
JTextField mt_sno,mt_sname,mt_ssex,mt_sage,mt_sdorm,mt_address;//下半部分修改删除文本域 
JPanel m_snopanel,m_snamepanel,m_ssexpanel,m_sagepanel,m_sdormpanel,m_addresspanel,m_btnpanel;//下半部分功能按钮Panel 
JButton m_AlterBtn,m_DelBtn;//下半部分的修改，删除按钮 
JPanel m_all;//下半部分删除修改Panel 

JLabel Search,n_select,n_selection;//查询条件Lable 
JTextField n_entersearch;//输入查询内容 
JComboBox nc_select;//查询条件ComboBox 
JButton n_searchBtn;//查询按钮 
JPanel n_all;//查询Panel 
String select[]={"学号","姓名","性别","年龄","宿舍","家庭住址"};//ComboBox中的选项 

String a_sno,a_sname,a_ssex,a_sage,a_sdorm,a_address;//接收添加信息文本框内容变量 
String s_combobox,s_content;//接收查询模块中ComboBox中内容和查询内容 
String d_sno,d_sname,d_ssex,d_sage,d_sdorm,d_address; //接收删除修改信息文本框内容 

JButton DispAllBtn,ClearTableBtn;//显示所有和清空列表按钮 
public InfoFrame() 
{ 
   setTitle("学生基本信息管理"); 
   setSize(WIDTH,HEIGHT); 
   setLocation(120,180); 
   setVisible(true); 
   ImageIcon ic = new ImageIcon("src/icon.JPG"); 
   setIconImage(ic.getImage()); 
   
   Container contentPane = getContentPane(); 
   contentPane.setLayout(new FlowLayout()); 
   //建立容纳添加区域和修改区域的文本区面板和JTable区域面板 
   AddLeft = new JPanel(); 
   addinfo = new JLabel("添加信息"); 
   addinfo.setHorizontalAlignment(SwingConstants.LEFT); 
   AddLeft.add(addinfo,BorderLayout.WEST);   
   AlterRight = new JPanel(); 
   alterinfo = new JLabel("删除修改信息"); 
   alterinfo.setHorizontalAlignment(SwingConstants.RIGHT); 
   AlterRight.add(alterinfo,BorderLayout.EAST); 
   TableMid = new JPanel(); 
   String[] col = {"学号","姓名","性别","年龄","宿舍","家庭住址"};//创建属性列名 
   mm= new DefaultTableModel(col,0); 
   if(!SelectInfoSQL()) //读取表信息到表格中 
     JOptionPane.showMessageDialog(null, "读取错误，请关闭该对话框重试 ", "提示", 1); 
   table.setModel(mm); 
   JScrollPane tableScrollPane = new JScrollPane(table); //添加滚动面板 
   TableMid.add(tableScrollPane); 
   
   //添加左半部分关于添加信息的面板信息； 
   l_sno = new JLabel("学号"); 
   l_sname = new JLabel("姓名"); 
   l_ssex = new JLabel("性别"); 
   l_sage = new JLabel("年龄"); 
   l_sdorm = new JLabel("宿舍"); 
   l_address = new JLabel("家庭住址"); 
   lt_sno = new JTextField(8); 
   lt_sname = new JTextField(5); 
   lt_ssex = new JTextField(2); 
   lt_sage = new JTextField(2); 
   lt_sdorm = new JTextField(5); 
   lt_address = new JTextField(20); 
   l_snopanel = new JPanel(); 
   l_snamepanel = new JPanel(); 
   l_ssexpanel = new JPanel(); 
   l_sagepanel = new JPanel(); 
   l_sdormpanel = new JPanel(); 
   l_addresspanel = new JPanel(); 
   l_btnpanel = new JPanel(); 
   l_all = new JPanel(); 
   l_Btn = new JButton("添加"); 
   l_snopanel.add(l_sno,BorderLayout.WEST); 
   l_snopanel.add(lt_sno,BorderLayout.EAST); 
   l_snamepanel.add(l_sname,BorderLayout.WEST); 
   l_snamepanel.add(lt_sname,BorderLayout.EAST); 
   l_ssexpanel.add(l_ssex,BorderLayout.WEST); 
   l_ssexpanel.add(lt_ssex,BorderLayout.EAST); 
   l_sagepanel.add(l_sage,BorderLayout.WEST); 
   l_sagepanel.add(lt_sage,BorderLayout.EAST); 
   l_sdormpanel.add(l_sdorm,BorderLayout.WEST); 
   l_sdormpanel.add(lt_sdorm,BorderLayout.EAST); 
   l_addresspanel.add(l_address,BorderLayout.WEST); 
   l_addresspanel.add(lt_address,BorderLayout.EAST); 
   l_btnpanel.add(l_Btn,BorderLayout.CENTER); 
   
   l_all.add(AddLeft,BorderLayout.WEST); 
   l_all.add(l_snopanel,BorderLayout.CENTER); 
   l_all.add(l_snamepanel,BorderLayout.CENTER); 
   l_all.add(l_ssexpanel,BorderLayout.CENTER); 
   l_all.add(l_sagepanel,BorderLayout.CENTER); 
   l_all.add(l_sdormpanel,BorderLayout.CENTER); 
   l_all.add(l_addresspanel,BorderLayout.CENTER); 
   l_all.add(l_btnpanel,BorderLayout.EAST); 
   
   
   //添加下半部分删除修改信息界面 
   m_all = new JPanel(); 
   m_sno = new JLabel("学号"); 
   m_sname = new JLabel("姓名"); 
   m_ssex = new JLabel("性别"); 
   m_sage = new JLabel("年龄"); 
   m_sdorm = new JLabel("宿舍"); 
   m_address = new JLabel("家庭住址"); 
   mt_sno = new JTextField(8); 
   mt_sname = new JTextField(5); 
   mt_ssex = new JTextField(2); 
   mt_sage = new JTextField(2); 
   mt_sdorm = new JTextField(5); 
   mt_address = new JTextField(20); 
   m_snopanel = new JPanel(); 
   m_snamepanel = new JPanel(); 
   m_ssexpanel = new JPanel(); 
   m_sagepanel = new JPanel(); 
   m_sdormpanel = new JPanel(); 
   m_addresspanel = new JPanel(); 
   m_btnpanel = new JPanel(); 
   m_all = new JPanel(); 
   m_AlterBtn = new JButton("修改"); 
   m_DelBtn = new JButton("删除"); 
   m_snopanel.add(m_sno,BorderLayout.WEST); 
   m_snopanel.add(mt_sno,BorderLayout.EAST); 
   m_snamepanel.add(m_sname,BorderLayout.WEST); 
   m_snamepanel.add(mt_sname,BorderLayout.EAST); 
   m_ssexpanel.add(m_ssex,BorderLayout.WEST); 
   m_ssexpanel.add(mt_ssex,BorderLayout.EAST); 
   m_sagepanel.add(m_sage,BorderLayout.WEST); 
   m_sagepanel.add(mt_sage,BorderLayout.EAST); 
   m_sdormpanel.add(m_sdorm,BorderLayout.WEST); 
   m_sdormpanel.add(mt_sdorm,BorderLayout.EAST); 
   m_addresspanel.add(m_address,BorderLayout.WEST); 
   m_addresspanel.add(mt_address,BorderLayout.EAST); 
   m_btnpanel.add(m_AlterBtn,BorderLayout.CENTER); 
   m_btnpanel.add(m_DelBtn,BorderLayout.CENTER); 
   mt_sno.setEditable(false);//修改信息的学号不允许修改 
   m_all.add(AlterRight,BorderLayout.WEST); 
   m_all.add(m_snopanel,BorderLayout.CENTER); 
   m_all.add(m_snamepanel,BorderLayout.CENTER); 
   m_all.add(m_ssexpanel,BorderLayout.CENTER); 
   m_all.add(m_sagepanel,BorderLayout.CENTER); 
   m_all.add(m_sdormpanel,BorderLayout.CENTER); 
   m_all.add(m_addresspanel,BorderLayout.CENTER); 
   m_all.add(m_btnpanel,BorderLayout.EAST); 
   
   //添加下半部分查询界面 
   n_all = new JPanel(); 
   Search = new JLabel("查询信息"); 
   n_select = new JLabel("请选择查询条件："); 
   n_selection = new JLabel("请输入查询内容"); 
   n_searchBtn = new JButton("强力搜索"); 
   DispAllBtn = new JButton("显示所有"); 
   ClearTableBtn = new JButton("清空列表"); 
   n_entersearch = new JTextField(10); 
   nc_select = new JComboBox(select); 
   nc_select.setSelectedIndex(0); 
   nc_select.setEditable(false); 
   n_all.add(Search,BorderLayout.WEST); 
   n_all.add(n_select,BorderLayout.CENTER); 
   n_all.add(nc_select,BorderLayout.CENTER); 
   n_all.add(n_selection,BorderLayout.CENTER); 
   n_all.add(n_entersearch,BorderLayout.CENTER); 
   n_all.add(n_searchBtn,BorderLayout.EAST); 
   n_all.add(DispAllBtn,BorderLayout.EAST); 
   n_all.add(ClearTableBtn,BorderLayout.EAST); 
   
     //设置列宽 
   TableColumn sno = table.getColumnModel().getColumn(0); 
   sno.setPreferredWidth(80); 
   sno.setMaxWidth(80); 
   sno.setMinWidth(80); 
   TableColumn sname = table.getColumnModel().getColumn(1); 
   sname.setPreferredWidth(50); 
   sname.setMaxWidth(50); 
   sname.setMinWidth(50); 
   TableColumn ssex = table.getColumnModel().getColumn(2); 
   ssex.setPreferredWidth(30); 
   ssex.setMaxWidth(30); 
   ssex.setMinWidth(30); 
   TableColumn sage = table.getColumnModel().getColumn(3); 
   sage.setPreferredWidth(30); 
   sage.setMaxWidth(30); 
   sage.setMinWidth(30); 
   TableColumn sdorm = table.getColumnModel().getColumn(4); 
   sdorm.setPreferredWidth(70); 
   sdorm.setMaxWidth(70); 
   sdorm.setMinWidth(70); 
   TableColumn saddr = table.getColumnModel().getColumn(5); 
   saddr.setPreferredWidth(220); 
   saddr.setMaxWidth(220); 
   saddr.setMinWidth(220); 
   //添加面板到界面 
   contentPane.add(l_all,FlowLayout.LEFT); 
   contentPane.add(TableMid,FlowLayout.CENTER); 
   contentPane.add(m_all,FlowLayout.RIGHT); 
   contentPane.add(n_all,FlowLayout.RIGHT); 
   
   //添加按钮监听器 
   l_Btn.addActionListener(this); 
   m_AlterBtn.addActionListener(this); 
   m_DelBtn.addActionListener(this); 
   n_searchBtn.addActionListener(this); 
   DispAllBtn.addActionListener(this); 
   ClearTableBtn.addActionListener(this); 
   table.addMouseListener(new MouseAdapter(){ 
   public void mouseClicked(MouseEvent e){ 
     setContent(); 
   } 
   }); 
} 

public void actionPerformed(ActionEvent e) 
{ 
   if(e.getSource() == l_Btn)   //添加按钮动作 
   { 
   if(!AddSQL()) 
   { 
     JOptionPane.showMessageDialog(null, "     添加失败!\n学号已存在或添加信息不完整，请重新输入！！ ", "提示", 1); 
     lt_sno.setText(""); 
     return; 
   } 
   else 
   { 
     JOptionPane.showMessageDialog(null, "     添加成功！！ ", "提示", 1); 
     lt_sno.setText(""); 
     lt_sname.setText(""); 
     lt_ssex.setText(""); 
     lt_sage.setText(""); 
     lt_sdorm.setText(""); 
     lt_address.setText(""); 
     String[] Added = {a_sno,a_sname,a_ssex,a_sage,a_sdorm,a_address}; 
     mm.addRow(Added); 
     return; 
   } 
     
   } 
   if(e.getSource() == m_AlterBtn)   //修改按钮动作 
   { 
   if(selIndex == 0) 
   { 
     JOptionPane.showMessageDialog(null, "     请选中要修改的学生信息所在行！！ ", "提示", 1); 
     return; 
   } 
   if(AlterSQL()) 
   { 
     JOptionPane.showMessageDialog(null, "     信息修改成功 ", "提示", 1); 
     mt_sno.setText("");//清空文本域 
     mt_sname.setText(""); 
     mt_ssex.setText(""); 
     mt_sage.setText(""); 
     mt_sdorm.setText(""); 
     mt_address.setText(""); 
     selIndex = 0;//选中标志清零，再删除时需选择行 
     return; 
   } 
   else 
   { 
     JOptionPane.showMessageDialog(null, "     修改失败，请重试！！ ", "提示", 1); 
     mt_sno.setText("");//清空文本域 
     mt_sname.setText(""); 
     mt_ssex.setText(""); 
     mt_sage.setText("");