《学生管理系统JAVA》由会员分享,可在线阅读,更多相关《学生管理系统JAVA(8页珍藏版)》请在金锄头文库上搜索。
1、使用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 = this.name = nul
2、l;this.intGender = -1;public StuBean(String code, String name, int gender) this.code = code;this.name = name;this.intGender = gender;public String findStudentByCode(String code) throws SQLException,ClassNotFoundException String result = null;String sql = select * from student;if (null != code & code
3、.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 = r
4、s.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
5、(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) this.name = name;public int getIntGender() return intGender;public void
6、 setIntGender(int intGender) this.intGender = 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.J
7、Label;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 okButto
8、n = 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);codeFiel
9、d.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
10、();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 ja
11、va.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:/127.0.0.1:1433;DatabaseName=school;public final static String defaultUser = qq;public f
12、inal 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 v
13、oid 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.printStack
14、Trace(); 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,ClassNotFoundExc