Java学生管理系统能够题目及简介

Java学生管理系统能够题目及简介在例12-3的基础上完善程序，做图形界面，在其中有多个选项“添加”、“修改”、“删除”、“查询”等，根据用户选择的功能再输入相应的数据并完成相关功能。

开发环境概述JAVA开发工具ECLIPSE，SQL SERVER 2005；一：描述1.主界面上直接显示数据库中的所有数据，有添加、删除、修改、查询各个按钮2.查询在主界面上实现。

根据学号和姓名查询。

没有新建类，代码在主界面类里。

3.修改和添加都新建了一个类（update和add），生成一个新的窗口，以实现功能。

删除的代码比较简单，也在主界面类里。

4.专门新建了一个连接类connectiondb，以实现与数据库的连接。

里面还包含了sql语句。

5.关于JTable 的实现，专门建了一个类model，完成对JTable的初始化。

二：界面截图1.主界面2.查询3.添加4.修改5.删除三：源代码：add类：import java.awt.BorderLayout; import java.awt.Frame;import java.awt.GridLayout;import java.awt.event.ActionEvent; import java.awt.event.ActionListener;import javax.swing.JButton;import javax.swing.JComboBox; import javax.swing.JDialog;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane; import javax.swing.JPanel;import javax.swing.JTextField;public class add extends JDialog implements ActionListener{//定义组件JPanel jp1,jp2,jp3;JLabel jl1,jl2,jl3,jl4,jl5;JButton jb1,jb2;JTextField jtf1,jtf2,jtf4;JComboBox jc3,jc5;//构造器public add(Frame owner,String title,boolean modal){ super(owner,title,modal);//定义jp1jp1 = new JPanel();jl1 = new JLabel("学号");jl2 = new JLabel("姓名");jl3 = new JLabel("性别");jl4 = new JLabel("出生年月");jl5 = new JLabel("专业");jp1.add(jl1);jp1.add(jl2);jp1.add(jl3);jp1.add(jl4);jp1.add(jl5);jp1.setLayout(new GridLayout(5,1)); //定义jp2jp2 = new JPanel();jtf1 = new JTextField(9);jtf2 = new JTextField(8);jtf4 = new JTextField(8);jc3 = new JComboBox();jc3.addItem("男");jc3.addItem("女");jc5 = new JComboBox();jc5.addItem("计算");jc5.addItem("信管");jc5.addItem("地信");jc5.addItem("日语");jp2.add(jtf1);jp2.add(jtf2);jp2.add(jc3);jp2.add(jtf4);jp2.add(jc5);jp2.setLayout(new GridLayout(5,1));//定义jp3jp3 = new JPanel();jb1 = new JButton("确定");jb2 = new JButton("取消");jp3.add(jb1);jp3.add(jb2);//注册监听jb1.addActionListener(this);jb2.addActionListener(this);this.add(jp1,BorderLayout.WEST);this.add(jp2,BorderLayout.CENTER);this.add(jp3,BorderLayout.SOUTH);//定义窗口this.setSize(300,300);this.setLocation(250, 250);this.setVisible(true);this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLO SE);}//响应函数public void actionPerformed(ActionEvent e) {if(e.getSource().equals(jb1)){String[] str = new String[5];str[0] = jtf1.getText();str[1] = jtf2.getText();str[2] = jc3.getSelectedItem().toString().trim();str[3] = jtf4.getText();str[4] = jc5.getSelectedItem().toString().trim();connectiondb c = new connectiondb();c.addSql(str);JOptionPane.showMessageDialog(this, "添加成功！");this.dispose();//关闭对话框}else if(e.getSource().equals(jb2)){this.dispose();}}}Connectiondb类package chapter12;import java.beans.Statement;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.SQLException;public class connectiondb{String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";String dbURL = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=student" ;Connection dbConn;Statement stmt;PreparedStatement pstmt=null;String userName = "sa";String userPwd = "123456";//返回连接数据public Connection getdbConn(){return dbConn;}public connectiondb(){try {Class.forName(driverName);dbConn = DriverManager.getConnection(dbURL,userName,userPwd );} catch (Exception e) {System.out.println("连接失败！");e.printStackTrace();}}//添加信息时，调用的方法public void addSql(String[] str){String strsql = "insert into st1 values(?,?,?,?,?)";try {pstmt = dbConn.prepareStatement(strsql);for (int i = 0; i < str.length; i++) {pstmt.setString(i+1, str[i]);}pstmt.executeUpdate();} catch (Exception e) {e.printStackTrace();}finally{//释放语句对象连接的对象allClose();}}//删除信息时，用到的方法public void delete(String str){try {pstmt=dbConn.prepareStatement("delete from st1 where sno=?");pstmt.setString(1, str);pstmt.executeUpdate();} catch (Exception e) {e.printStackTrace();}finally{allClose();}}//查询信息时，用到的方法// public void findSQL(String str){// try {// pstmt=dbConn.prepareStatement("select * from st1 where sname like '"+str+"%'");// pstmt.executeUpdate();// } catch (Exception e) {// e.printStackTrace();// }finally{// allClose();// }// }// public void findSQL1(String str){// try {// pstmt=dbConn.prepareStatement("select * from st1 where sno = '"+str+"' ");// pstmt.executeUpdate();// } catch (Exception e) {// e.printStackTrace();// }finally{// allClose();// }// }//修改信息时，用到的方法public void allClose(){try{if(pstmt!=null) pstmt.close();if(dbConn!=null) dbConn.close();}catch (Exception ex){ ex.printStackTrace();}}public void updateIt(String[] str) {String strsql = "update st1 set sname=? ,ssex=?,birthday=?,speciality=? where sno=?";try {pstmt = dbConn.prepareStatement(strsql);for (int i = 0; i < str.length; i++) {pstmt.setString(i+1, str[i]);}pstmt.executeUpdate();} catch (Exception e) {e.printStackTrace();}finally{//释放语句对象连接的对象allClose();}}}Model类package chapter12;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import java.util.List;import javax.swing.table.AbstractTableModel;public class model extends AbstractTableModel { List rowData, columnNames;PreparedStatement ps = null;Connection ct = null;ResultSet rs = null;String sql ;public void way(String sql) {if (sql.equals("")) {sql = "select * from st1";}columnNames = new ArrayList();columnNames.add("学号");columnNames.add("姓名");columnNames.add("性别");columnNames.add("生日");columnNames.add("专业");rowData = new ArrayList(); connectiondb c = new connectiondb();try {ct = c.getdbConn();ps = ct.prepareStatement(sql);rs = ps.executeQuery();while (rs.next()) {// rowData可以存放多行String s = rs.toString();List hang = new ArrayList();hang.add(rs.getString(1));hang.add(rs.getString(2));hang.add(rs.getString(3));hang.add(rs.getString(4));hang.add(rs.getString(5));// 加入到rowDatarowData.add(hang);}} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}// rowData = new ArrayList();// rowData.add(columnNames);}public model(){this.way("");}public model(String str){this.way(str);}@Overridepublic int getColumnCount() {// TODO Auto-generated method stubreturn this.columnNames.size();}@Overridepublic int getRowCount() {// TODO Auto-generated method stubreturn this.rowData.size();}@Overridepublic Object getValueAt(int rowIndex, int columnIndex) { // TODO Auto-generated method stubreturn ((ArrayList) this.rowData.get(rowIndex)).get(columnIndex);}@Overridepublic String getColumnName(int arg0) {// TODO Auto-generated method stubreturn (String) this.columnNames.get(arg0);}}Update类package chapter12;import java.awt.Frame;import java.awt.GridLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JTextField;public class update extends JDialog implements ActionListener{JLabel jl1,jl2,jl3,jl4,jl5;JTextField jtf1,jtf2,jtf3,jtf4,jtf5;JButton jb1,jb2;JPanel jp1,jp2,jp3;public update(Frame owner,String title,boolean modal,model m,int rowNum){super(owner,title,modal);jp1 = new JPanel();jl1 = new JLabel("学号");jl2 = new JLabel("姓名");jl3 = new JLabel("性别");jl4 = new JLabel("出生年月");jl5 = new JLabel("专业");jp1.setLayout(new GridLayout(5,1)); jp1.add(jl1);jp1.add(jl2);jp1.add(jl3);jp1.add(jl4);jp1.add(jl5);jp2 = new JPanel();jtf1 = new JTextField(9);jtf1.setEditable(false);jtf2 = new JTextField(8);jtf3 = new JTextField(2);jtf4 = new JTextField(8);jtf5 = new JTextField(10);jtf1.setText((String)m.getValueAt(rowNum, 0)); jtf2.setText((String)m.getValueAt(rowNum, 1)); jtf3.setText((String)m.getValueAt(rowNum, 2)); jtf4.setText((String)m.getValueAt(rowNum, 3)); jtf5.setText((String)m.getValueAt(rowNum, 4)); jp2.setLayout(new GridLayout(5,1));jp2.add(jtf1);jp2.add(jtf2);jp2.add(jtf3);jp2.add(jtf4);jp2.add(jtf5);jp3 = new JPanel();jb1 = new JButton("修改");jb2 = new JButton("取消");jb1.addActionListener(this);jb2.addActionListener(this);jp3.add(jb1);jp3.add(jb2);this.add(jp1,"Center");this.add(jp2,"East");this.add(jp3,"South");this.setSize(200,300);this.setLocation(250, 250);this.setVisible(true);this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLO SE);}public void actionPerformed(ActionEvent e) {if(e.getSource().equals(jb1)){String[] str = new String[5];str[4] = jtf1.getText();str[0] = jtf2.getText();str[1] = jtf3.getText();str[2] = jtf4.getText();str[3] = jtf5.getText();connectiondb c = new connectiondb();c.updateIt(str);JOptionPane.showMessageDialog(this, "修改成功！");this.dispose();//关闭对话框}else if(e.getSource().equals(jb2)){ this.dispose();}}}Zhujiemian类package chapter12;import java.awt.GridBagConstraints; import java.awt.GridBagLayout; import java.awt.GridLayout;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.JPanel;import javax.swing.JScrollPane; import javax.swing.JTable;import javax.swing.JTextField;public class zhujiemian extends JFrame implements ActionListener{//定义组件JLabel jl1,jl2;JTextField jtf1,jtf2 ;JPanel jp,jp2;JTable jt;JButton jb1,jb2,jb3,jb4;JScrollPane jsp;model m;//主函数public static void main(String[] args) {zhujiemian z = new zhujiemian();}//定义构造器zhujiemian(){super("主界面");jp2 = new JPanel();jtf1 = new JTextField(9);jtf2 = new JTextField(8);jl1 = new JLabel(" 学号");jl2 = new JLabel(" 姓名");jb4=new JButton("查询");jb4.addActionListener(this);GridBagLayout gb = new GridBagLayout();jp2.setLayout(gb);GridBagConstraints c = new GridBagConstraints(); c.fill =new GridBagConstraints().BOTH;c.weightx = 1.0;gb.setConstraints(jl1, c);jp2.add(jl1);c.weightx = 1.0;gb.setConstraints(jtf1, c);jp2.add(jtf1);c.gridwidth = GridBagConstraints.REMAINDER; // c.gridheight = 2;c.gridheight = GridBagConstraints.VERTICAL;gb.setConstraints(jb4, c);jp2.add(jb4);c.gridx = 0;c.gridy = 1;gb.setConstraints(jl2, c);jp2.add(jl2);c.gridx = 1;c.gridy = 1;c.gridwidth= 1;gb.setConstraints(jtf2, c);jp2.add(jtf2);jp = new JPanel();//定义按钮jb1=new JButton("添加");jb2=new JButton("修改");jb3=new JButton("删除");//为按钮添加响应机制jb1.addActionListener(this);jb2.addActionListener(this);jb3.addActionListener(this);//为JPanel添加组件jp.add(jb1);jp.add(jb2);jp.add(jb3);// jp.add(jb4);m = new model();jt = new JTable(m);jsp = new JScrollPane(jt);this.add(jsp);this.add(jp2,"North");this.add(jp, "South");//定义窗口属性this.setSize(500,300);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setVisible(true);this.setLocation(450,200);}//响应函数public void actionPerformed(ActionEvent e) {//判断用户点击哪个按钮//当点击“添加”时if(e.getSource().equals(jb1)){add a = new add(this,"添加信息",true);m = new model();jt.setModel(m);//当点击“修改”时}else if(e.getSource().equals(jb2)){int rowNum = this.jt.getSelectedRow();if(rowNum == -1){JOptionPane.showMessageDialog(this, "请选择一行");return;}new update(this,"修改",true,m,rowNum);m = new model();jt.setModel(m);//当点击“删除”时}else if(e.getSource().equals(jb3)){int rowNum = this.jt.getSelectedRow();if(rowNum == -1){JOptionPane.showMessageDialog(this, "请选择一行");return;}String sno = (String) m.getValueAt(rowNum, 0);connectiondb c = new connectiondb();c.delete(sno);JOptionPane.showMessageDialog(this, "删除成功！");m = new model();jt.setModel(m);//当点击“查询”时}else if(e.getSource().equals(jb4)){String s1 = jtf1.getText();String s2 = jtf2.getText();String s;if(s1.equals("")&& s2.equals("")){s = "";JOptionPane.showMessageDialog(this, "请输入要查询的内容！");}else if(s2.equals("")){s = "select * from st1 where sno = '"+s1+"'";}else if(s1.equals("")){s = "select * from st1 where sname like '"+s2+"%'";}else{s = "select * from st1 where sno = '"+s1+"'and sname like '"+s2+"%'";}m = new model(s);jt.setModel(m);}}}。