学生管理系统JAVA.doc

使用JDBC技术，结合Swing图形用户界面技术，编写学生信息管理系统，实现通过图形用户界面来管理学生的学号、姓名和性别等信息，要求能够对这些信息进行添加、编辑、删除和检索操作。代码：package edu.lit.db.stuMis;import java.sql.ResultSet;import java.sql.SQLException;public class StuBean private String code;private String name;private int intGender;public StuBean() this.code = = null;Gender = -1;public StuBean(String code, String name, int gender) this.code = code; = name;Gender = gender;public String findStudentByCode(String code) throws SQLException,ClassNotFoundException String result = null;String sql = select * from student;if (null != code & code.trim().length() 0) sql += where code= + code + ;DatabaseConn conn = new DatabaseConn();ResultSet rs = conn.executeQuery(sql);int rows = 0;if (rs.last() rows = rs.getRow();if (rows 0) result = new Stringrows3;rs.first();rs.previous();int i = 0;while (rs.next() resulti0 = rs.getString(1);resulti1 = rs.getString(2);int temIntGender = rs.getInt(3);if (temIntGender = 0) resulti2 = 女; else resulti2 = 男;+i;return result;public void stuDel(String code) DatabaseConn conn = new DatabaseConn();this.code = code;String sql = DELETE FROM student WHERE code = + code + ;try conn.openConn();conn.executeUpdate(sql); catch (Exception e) System.out.println(e) finally conn.closeConn();public String getCode() return code;public void setCode(String code) this.code = code;public String getName() return name;public void setName(String name) = name;public int getIntGender() return intGender;public void setIntGender(int intGender) Gender = intGender;package edu.lit.db.stuMis;import java.awt.Container;import java.awt.FlowLayout;import java.awt.Font;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JTextField;public class StuDelFrame extends JFrame implements ActionListener private static final long serialVersionUID = 3373534924337194147L;Container c;JLabel codeLabel = new JLabel();JTextField codeField = new JTextField(10);JButton okButton = new JButton()public StuDelFrame() this.setTitle(请输入要删除学生的学号：);this.setResizable(false);this.init();private void init() this.setSize(300, 150);c = this.getContentPane();c.setLayout(new FlowLayout();codeLabel.setText(请输入要删除学生的学号：);codeLabel.setFont(new Font(Dialog, 0, 12);c.add(codeLabel);codeField.setText(null);codeField.setFont(new Font(Dialog, 0, 12);c.add(codeField);this.okButton.setText(确定);this.okButton.setFont(new Font(Dialog, 0, 12);this.okButton.addActionListener(this);c.add(okButton);public void actionPerformed(ActionEvent e) Object obj = e.getSource();StuBean stuBean = new StuBean();if (this.okButton = obj) stuBean.stuDel(this.codeField.getText(); JOptionPane.showMessageDialog(null, 成功删除一条新的记录！);this.dispose();elseJOptionPane.showMessageDialog(null, 删除失败,错误,JOptionPane.ERROR_MESSAGE);package edu.lit.db.stuMis;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;public class DatabaseConn public final static String defaultDriver = net.sourceforge.jtds.jdbc.Driver;public final static String defaultConnStr = jdbc:jtds:sqlserver:/:1433;DatabaseName=school;public final static String defaultUser = qq;public final static String defaultPass = 123456;private String driver = null;private String connStr = null;private String user = null;private String pass = null;private Connection conn = null;public DatabaseConn() driver = defaultDriver;connStr = defaultConnStr;user = defaultUser;pass = defaultPass;public void openConn() throws ClassNotFoundException, SQLException if (null = this.conn) Class.forName(this.driver);conn = DriverManager.getConnection(this.connStr, this.user,this.pass);public void closeConn() if (null != this.conn) try this.conn.close();this.conn = null; catch (SQLException e) e.printStackTrace(); finally if (null != this.conn) try this.conn.close(); catch (SQLException e) e.printStackTrace();this.conn = null;public Connection getConn() throws ClassNotFoundException, SQLException if (null = this.conn) this.openConn();return this.conn;public ResultSet executeQuery(String sql) throws SQLException,ClassNotFoundException return this.getConn().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY).executeQuery(sql);public void executeUpdate(String sql) throws SQLException,ClassNotFoundException this.getConn().createStatement().executeUpdate(sql);package edu.lit.db.stuMis;import java.awt.Container;import java.awt.FlowLayout;import java.awt.Font;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JTextField;public class StuSearchFram extends JFrame implements ActionListener private static final long serialVersionUID = 5942094774144739614L;Container c;JLabel codeLabel = new JLabel();JTextField codeField = new JTextField(10);JButton okButton = new JButton();public StuSearchFram() this.setTitle(按学号查询);this.setResizable(false);this.init();private void init() this.setSize(300, 150);c = this.getContentPane();c.setLayout(new FlowLayout();codeLabel.setText(请输入学号: );codeLabel.setFont(new Font(Dialog, 0, 12);c.add(codeLabel);codeField.setText(null);codeField.setFont(new Font(Dialog, 0, 12);c.add(codeField);this.okButton.setText(确定);this.okButton.setFont(new Font(Dialog, 0, 12);this.okButton.addActionListener(this);c.add(okButton);Overridepublic void actionPerformed(ActionEvent e) Object obj = e.getSource();if (this.okButton = obj) new ResultStudent(this.codeField.getText();this.dispose();package edu.lit.db.stuMis;import java.awt.AWTEvent;import java.awt.BorderLayout;import java.awt.Container;import java.awt.Font;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.WindowAdapter;import java.awt.event.WindowEvent; import javax.swing.JFrame;import javax.swing.JMenu;import javax.swing.JMenuBar;import javax.swing.JMenuItem;public class StuMain extends JFrame implements ActionListener private static final long serialVersionUID = -1114769811970010952L;JMenuBar mainMenu = new JMenuBar();JMenu menuSystem = new JMenu();JMenuItem itemExit = new JMenuItem();JMenu menuStu = new JMenu();JMenuItem itemAdd = new JMenuItem();JMenuItem itemEdit = new JMenuItem();JMenuItem itemDel = new JMenuItem();JMenuItem itemSelect = new JMenuItem();public StuMain() enableEvents(AWTEvent.WINDOW_EVENT_MASK);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.pack();this.setSize(800, 500);this.setTitle(学生管理系统主窗口);this.init();private void init() Container contentPane = this.getContentPane();contentPane.setLayout(new BorderLayout();this.menuSystem.setText(系统管理);this.menuSystem.setFont(new Font(Dialog, 0, 12);this.menuStu.setText(学生管理);this.menuStu.setFont(new Font(Dialog, 0, 12);this.itemExit.setText(退出);this.itemExit.setFont(new Font(Dialog, 0, 12);this.itemAdd.setText(增加);this.itemAdd.setFont(new Font(Dialog, 0, 12);this.itemEdit.setText(修改);this.itemEdit.setFont(new Font(Dialog, 0, 12);this.itemDel.setText(删除);this.itemDel.setFont(new Font(Dialog, 0, 12);this.itemSelect.setText(查询);this.itemSelect.setFont(new Font(Dialog, 0, 12);this.menuSystem.add(this.itemExit);this.menuStu.add(this.itemAdd);this.menuStu.add(this.itemEdit);this.menuStu.add(this.itemDel);this.menuStu.add(this.itemSelect);this.mainMenu.add(this.menuSystem);mainMenu.add(menuStu);setJMenuBar(mainMenu)this.itemExit.addActionListener(this);this.itemAdd.addActionListener(this);this.itemDel.addActionListener(this);this.itemEdit.addActionListener(this);this.itemSelect.addActionListener(this);this.setVisible(true);this.addWindowListener(new WindowAdapter() Overridepublic void windowClosing(WindowEvent e) System.exit(0););java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent)public void actionPerformed(ActionEvent e) Object obj = e.getSource();if (obj = itemExit) System.exit(0); else if (obj = itemSelect) StuSearchFram searchFram = new StuSearchFram();searchFram.pack();searchFram.setVisible(true); else if (obj = itemDel) StuDelFrame delFrame = new StuDelFrame();delFrame.pack();delFrame.setVisible(true);public static void main(String args) new StuMain();package edu.lit.db.stuMis;import java.awt.BorderLayout;import java.awt.Dimension;import java.awt.Toolkit;import java.sql.SQLException;import javax.swing.JFrame;import jav