山大_数据库课程设计_学生信息管理系统_源代码

package GWT; import java.sql.*; import javax.swing.*; import java.awt.*; import java.awt.event.*; public class Stu_inf_swing extends WindowAdapter implements ActionListener{ private JFrame frmStudent; private JTextField textField; private JTextField textField_1; private JTextField textField_2; private JTextField textField_3; private JTextField textField_4; private JTextField textField_5; JTextArea textArea; JButton button; JButton button_1; JButton button_2; JButton button_3; JButton button_4; JButton button_5; Connection conn=null; Statement stmt=null; ResultSet rs=null; int key=0; protected int recordCnt=0; public Stu_inf_swing() { initialize(); frmStudent.setVisible(true); connection(); } //关闭数据库 public void windowClosing(WindowEvent el){ try{ conn.close(); }catch(SQLException e){ e.printStackTrace(); }finally{ System.exit(0); } } //打开数据库 public void connection(){ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn=DriverManager.getConnection("jdbc:odbc:学生信息管理","junchao",""); stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); }catch(SQLException e){ JOptionPane.showMessageDialog(frmStudent,"数据库无法连接或没有记录"); }catch(ClassNotFoundException e){ JOptionPane.showMessageDialog(frmStudent,"无法加载ODBC驱动"); } } //显示数据到控件中 public void showDate(){ try{ textField.setText(rs.getString("student_ID")); textField_1.setText(rs.getString("student_Name")); textField_2.setText(rs.getString("student_Age")); textField_3.setText(rs.getString("student_Sex")); textField_4.setText(rs.getString("student_depart")); textField_5.setText(rs.getString("student_College")); }catch(SQLException e){ JOptionPane.showMessageDialog(frmStudent,"无法获取数据"); JOptionPane.showMessageDialog(frmStudent,e.getMessage()); } } //设置文本框的初始状态 protected void setTextState(boolean flag){ textField.setEditable(flag); textField_1.setEditable(flag); textField_2.setEditable(flag); textField_3.setEditable(flag); textField_4.setEditable(flag); textField_5.setEditable(flag); } //将所有文本框中的数据清除 protected void setTextEmpty(){ textField.setText(null); textField_1.setText(null); textField_2.setText(null); textField_3.setText(null); textField_4.setText(null); textField_5.setText(null); } //添加记录 protected void doAdd(){ setTextState(true);//将各个Text置为可写 setTextEmpty();//将各个Text置为空，准备编辑记录 key=1; JOptionPane.showMessageDialog(frmStudent,"请输入要插入的元组！！"); } //查询记录 protected void doQuery(){ try{ int num=1; String sql="select * from student where"; textArea.setText(null); String temp1=textField.getText(); if(!temp1.isEmpty()) { if(num==1){ sql=sql+" student_ID='"+temp1+"'"; } num++; } String temp2=textField_1.getText(); if(!temp2.isEmpty()) { if(num==1){ sql=sql+" student_Name='"+temp2+"'"; } else sql=sql+" and student_Name='"+temp2+"'"; num++; } String temp3=textField_2.getText(); if(!temp3.isEmpty()) { if(num==1){ sql=sql+" student_Age='"+temp3+"'"; } else sql=sql+" and student_Age='"+temp3+"'"; num++; } String temp4=textField_3.getText(); if(!temp4.isEmpty()) { if(num==1){ sql=sql+" student_Sex='"+temp4+"'"; } else sql=sql+" and student_Sex='"+temp4+"'"; num++; } String temp5=textField_4.getText(); if(!temp5.isEmpty()) { if(num==1){ sql=sql+" student_depart='"+temp5+"'"; } else sql=sql+" and student_depart='"+temp5+"'"; num++; } String temp6=textField_5.getText(); if(!temp6.isEmpty()) { if(num==1){ sql=sql+" student_College='"+temp6+"'"; } else sql=sql+" and student_College='"+temp6+"'"; num++; } if(temp1.isEmpty()&&temp2.isEmpty()&&temp3.isEmpty()&&temp4.isEmpty()&&temp5.isEmpty()&&temp6.isEmpty()) sql="select * from student"; rs=stmt.executeQuery(sql); //下面开始遍历结果集 while(rs.next()){ //游标向后移动 String student_ID=rs.getString("student_ID");//获取student_ID字段的内容 String student_Name=rs.getString("student_Name"); String student_Age=rs.getString("student_Age"); String student_Sex=rs.getString("student_Sex"); String student_depart=rs.getString("student_depart"); String student_College=rs.getString("student_College"); textArea.append(student_ID+" "); textArea.append(student_Name+" "); textArea.append(student_Age+" "); textArea.append(student_Sex+" "); textArea.append(student_depart+" "); textArea.append(student_College+"\n"); } }catch(SQLException e){ JOptionPane.showMessageDialog(frmStudent,"查询错误"); JOptionPane.showMessageDialog(frmStudent,e.getMessage()); } } //保存 protected boolean doSave(boolean goViewState){ try{ if(key==1) { String sql="insert into student" + " values('"+textField.getText()+"','"+textField_1.getText() +"','" +textField_2.getText()+"','"+textField_3.getText()+"','"+textField_4.getText() +"','"+textField_5.getText()+"')"; stmt.executeUpdate(sql); System.out.println("insert into student" + " values('"+textField.getText()+"','"+textField_1.getText() +"','" +textField_2.getText()+"','"+textField_3.getText()+"','"+textField_4.getText() +"','"+textField_5.getText()+"')"); recordCnt++; JOptionPane.showMessageDialog(frmStudent,"保存数据成功！"); setTextState(true);//将各个Text置为可写 setTextEmpty();//将各个Text置为空，准备编辑记录 } if(key==2) { String tempp=textField.getText(); String sql1="delete from student where student_ID='"+tempp+"'"; stmt.executeUpdate(sql1); String sql2="insert into student" + " values('"+textField.getText()+"','"+textField_1.getText() +"','" +textField_2.getText()+"','"+textField_3.getText()+"','"+textField_4.getText() +"','"+textField_5.getText()+"')"; stmt.executeUpdate(sql2); JOptionPane.showMessageDialog(frmStudent,"保存数据成功！"); } }catch(SQLException e){ JOptionPane.showMessageDialog(frmStudent,"保存数据不成功！"); JOptionPane.showMessageDialog(frmStudent,e.getMessage()); return false; } return true; } //修改记录 protected void doEdit(){ try{ String temp=textField.getText(); if(temp.isEmpty()) JOptionPane.showMessageDialog(frmStudent,"请在‘学号’中输入要修改的学生的学号！"); if(!temp.isEmpty()) { String sql="select * from student where student_ID='"+temp+"'"; System.out.println("select * from student where student_ID='"+temp+"'"); rs=stmt.executeQuery(sql); rs.next(); setTextEmpty(); showDate(); JOptionPane.showMessageDialog(frmStudent,"请输入修改信息后点‘保存’！"); key=2; } }catch(SQLException e){ JOptionPane.showMessageDialog(frmStudent,"修改数据不成功！"); JOptionPane.showMessageDialog(frmStudent,e.getMessage()); } } //删除记录 protected void doDelete(){ if(textField.getText().isEmpty()) JOptionPane.showMessageDialog(frmStudent,"请在‘学号’中输入要删除的学生的学号！"); if(!textField.getText().isEmpty()) { if (JOptionPane.showConfirmDialog(frmStudent,"删除后将不可恢复！确定要删除当前记录吗？","提示", JOptionPane.OK_CANCEL_OPTION)==JOptionPane.OK_OPTION) { String tempp=textField.getText(); try{ String s