java管理员界面.doc

import java.awt.*;import java.awt.event.*;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Statement;import java.sql.*;import javax.swing.JOptionPane;public class guanliyuan extends Frame implements ActionListener Label name=new Label(姓名：); TextField t1=new TextField(); Label num=new Label(学号：); TextField t2=new TextField(); Label birthdate=new Label(出生日期：); TextField t3=new TextField(); Label grade=new Label(年级：); TextField t4=new TextField(); Label sex=new Label(性别：); TextField t5=new TextField(); Label score=new Label(总学分：); TextField t6=new TextField(); Button b1=new Button(添加); Button b2=new Button(查询); Button b3=new Button(修改); Button b4=new Button(删除); Button b5=new Button(关闭); public guanliyuan() this.setTitle(管理员操作界面);/设置窗口标题 this.setLayout(null); name.setBounds(50,40,60,20); this.add(name);/ 将姓名标签组件添加到容器 t1.setBounds(120,40,80,20);/ 设置文本框的初始位置 this.add(t1);/ 将文本框组件添加到容器 num.setBounds(50,100,60,20); this.add(num); t2.setBounds(120,100,80,20); this.add(t2); birthdate.setBounds(50,160,60,20); this.add(birthdate); t3.setBounds(120,160,80,20); this.add(t3); grade.setBounds(50,220,60,20); this.add(grade); t4.setBounds(120,220,80,20); this.add(t4); sex.setBounds(50,280,60,20); this.add(sex); t5.setBounds(120,280,80,20); this.add(t5); score.setBounds(50,340,60,20); this.add(score); t6.setBounds(120,340,80,20); this.add(t6); b1.setBounds(15,460,60,20);/设置添加按钮的初始位置 this.add(b1);/将登陆按钮组件添加到容器 b1.addActionListener(this);/给添加按钮添加监听器 b2.setBounds(85,460,60,20);/设置添加按钮的初始位置 this.add(b2);/将登陆按钮组件添加到容器 b2.addActionListener(this);/给添加按钮添加监听器 b3.setBounds(155,460,60,20);/设置添加按钮的初始位置 this.add(b3);/将登陆按钮组件添加到容器 b3.addActionListener(this);/给 b4.setBounds(225,460,60,20);/设置添加按钮的初始位置 this.add(b4);/将登陆按钮组件添加到容器 b4.addActionListener(this);/给 b5.setBounds(95,520,60,20);/设置添加按钮的初始位置 this.add(b5);/将登陆按钮组件添加到容器 b5.addActionListener(this);/给添加按钮添加监听器 this.setVisible(true);/设置窗口的可见性 this.setSize(300,600);/设置窗口的大小 addWindowListener(new WindowAdapter() public void windowClosing(WindowEvent e) System.exit(0); );/通过内部类重写关闭窗体的方法 public void actionPerformed(ActionEvent e) /0 if(e.getSource()=b1) /boolean b=true; String url=jdbc:odbc:shujuku; try Statement stmt; PreparedStatement psmt; ResultSet rs; Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con=DriverManager.getConnection(url); /con=DriverManager.getConnection(url); stmt=con.createStatement(); String name=t1.getText(); String number=t2.getText(); String birthdate=t3.getText(); String grade=t4.getText(); String sex=t5.getText(); String score=t6.getText(); psmt=con.prepareStatement(insert into 学生信息表 values(+name+,+number+,+birthdate+,+grade+,+sex+,+score+); rs=psmt.executeQuery(); con.close(); catch (Exception e1) e1.printStackTrace(); String warning=已录入！;/必须在try catch之后 JOptionPane.showMessageDialog(null,warning, 提示,JOptionPane.WARNING_MESSAGE); if(e.getSource()=b2)/1 /boolean b=true; try/3 String url=jdbc:odbc:shujuku; Statement stmt ; PreparedStatement psmt; ResultSet rs; Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con=DriverManager.getConnection(url); psmt=con.prepareStatement(select * from 学生信息表 where 学号=+t2.getText()+); rs=psmt.executeQuery(); rs.next(); t1.setText(rs.getString(1); t2.setText(rs.getString(2); t3.setText(rs.getString(3);t4.setText(rs.getString(4);t5.setText(rs.getString(5);t6.setText(rs.getString(6); catch (Exception e2) e2.printStackTrace(); if(e.getSource()=b3)/4 String xm=t1.getText(); String number=t2.getText(); String cs=t3.getText(); String nj=t4.getText(); String xb=t5.getText(); String score=t6.getText(); try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con = DriverManager.getConnection(jdbc:odbc:shujuku); Statement stmt = con.createStatement(); String sql=update 学生信息表 set 姓名=+xm+,出生日期=+cs+,年级=+nj+,性别=+xb+,总学分=+score+ where 学号=+number+; int n=stmt.executeUpdate(sql); catch(Exception e3) e3.printStackTrace(); String warning=已成功修改该生信息;/显示已成功删除 JOptionPane.showMessageDialog(null,warning,提示,JOptionPane.WARNING_MESSAGE); else if(e.getSource()=b4)/处理删除事件 try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con = DriverManager.getConnection(jdbc:odbc:shujuku); Statement stmt = con.createStatement(); String sql=delete from 学生信息表 where 学号=+t2.getText()+;/删除学生信息 int n=stmt.executeUpdate(sql); catch (Exception e4