学生管理系统——Swing窗体版本

用户10196776

发布于 2022-11-22 14:12:02

1.7K0

发布于 2022-11-22 14:12:02

文章被收录于专栏：SpringBoot+MyBatis前端

上一次一个小伙伴私聊我，说：有没有swing版本的学生管理系统让他参考一下。

这次给他安排上啦！

首先来看看有什么文件吧(得要有个适合自己的命名规则很重要，如果自己都看不懂，那么别人就更难懂啦！)

//我根据图片的信息来写文件内容吧！

这是dao方法

package com.zking.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import com.zking.entity.Student;
import com.zking.util.DBHelper;

public class StudentDao {
	
	/**
	 * 模糊查询
	 * @param col 字段名
	 * @param str 关键字
	 * @return 返回查询到的集合
	 */
	public ArrayList<Student> getByLike(String col,String str){
		ArrayList<Student> slist = new ArrayList<>();
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			con = DBHelper.getCon();
			ps = con.prepareStatement("select * from Student where "+col+" like '%"+str+"%'");
			rs = ps.executeQuery();
			//处理结果：集合/影响行数
			while(rs.next()) {
				int sid = rs.getInt(1);
				String sname = rs.getString(2);
				String ssex = rs.getString(3);
				int sage = rs.getInt(4);
				double score = rs.getDouble(5);
				String saddress = rs.getString(6);
				String slike = rs.getString(7);
				
				//实例化学生对象
				Student stu = new Student(sid, sname, ssex, sage, score, saddress, slike);
				//把学生对象放到集合中
				slist.add(stu);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.closeDB(con, ps, rs);
		}
		return slist;
	}
	public Student getById(int sid ){
		Student stu = null;
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			con = DBHelper.getCon();
			ps = con.prepareStatement("select * from Student where sid="+sid);
			rs = ps.executeQuery();
			//处理结果：集合/影响行数
			if(rs.next()) {
				String sname = rs.getString(2);
				String ssex = rs.getString(3);
				int sage = rs.getInt(4);
				double score = rs.getDouble(5);
				String saddress = rs.getString(6);
				String slike = rs.getString(7);
				String sgxqm = rs.getString(8);
				
				//实例化学生对象
				stu = new Student(sid, sname, ssex, sage, score, saddress, slike,sgxqm);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.closeDB(con, ps, rs);
		}
		return stu;
	}
	
	/**
	 * 添加学生
	 * @param stu 添加的学生对象
	 * @return 成功返回1，失败返回0
	 */
	public int addStu(Student stu){
		Connection con = null;
		PreparedStatement ps = null;
		int i = 0;
		try {
			con = DBHelper.getCon();
			ps = con.prepareStatement("insert into Student(sname,ssex,slike,saddress,sgxqm) values(?,?,?,?,?)");
			ps.setString(1, stu.getSname());
			ps.setString(2, stu.getSsex());
			ps.setString(3, stu.getSlike());
			ps.setString(4, stu.getSaddress());
			ps.setString(5, stu.getSgxqm());
			//处理结果：集合/影响行数
			i = ps.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.closeDB(con, ps, null);
		}
		return i;
	}
	
	/**
	 * 修改方法
	 * @param sid 要修改的学生学号
	 * @param stu 修改后的学生信息
	 * @return 成功返回1，失败返回0
	 */
	public int upStu(int sid,Student stu){
		Connection con = null;
		PreparedStatement ps = null;
		int i = 0;
		try {
			con = DBHelper.getCon();
			ps = con.prepareStatement("update Student set sname=?,ssex=?,slike=?,saddress=?,sgxqm=? where sid="+sid);
			ps.setString(1, stu.getSname());
			ps.setString(2, stu.getSsex());
			ps.setString(3, stu.getSlike());
			ps.setString(4, stu.getSaddress());
			ps.setString(5, stu.getSgxqm());
			//处理结果：集合/影响行数
			i = ps.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.closeDB(con, ps, null);
		}
		return i;
	}
	
	/**
	 * 删除学生
	 * @param sid 要删除的学生学号
	 * @return 成功就返回1
	 */
	public int delById(int sid){
		Connection con = null;
		PreparedStatement ps = null;
		int i = 0;
		try {
			con = DBHelper.getCon();
			ps = con.prepareStatement("delete student where sid="+sid);
			//处理结果：集合/影响行数
			i = ps.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.closeDB(con, ps, null);
		}
		return i;
	}



}

实体类来啦（根据自己所需要的字段来写哦！）

package com.zking.entity;

public class Student {
	private int sid;
	private String sname;
	private String ssex;
	private int sage;
	private double score;
	private String saddress;
	private String slike;
	private String sgxqm;
	public Student(int sid, String sname, String ssex, int sage, double score, String saddress, String slike,
			String sgxqm) {
		super();
		this.sid = sid;
		this.sname = sname;
		this.ssex = ssex;
		this.sage = sage;
		this.score = score;
		this.saddress = saddress;
		this.slike = slike;
		this.sgxqm = sgxqm;
	}
	public Student(String sname, String ssex, String saddress, String slike, String sgxqm) {
		super();
		this.sname = sname;
		this.ssex = ssex;
		this.saddress = saddress;
		this.slike = slike;
		this.sgxqm = sgxqm;
	}
	public String getSgxqm() {
		return sgxqm;
	}
	public void setSgxqm(String sgxqm) {
		this.sgxqm = sgxqm;
	}
	public Student() {
	}
	public Student(String sname, String ssex, int sage, double score, String saddress, String slike) {
		this.sname = sname;
		this.ssex = ssex;
		this.sage = sage;
		this.score = score;
		this.saddress = saddress;
		this.slike = slike;
	}
	public Student(int sid, String sname, String ssex, int sage, double score, String saddress, String slike) {
		this.sid = sid;
		this.sname = sname;
		this.ssex = ssex;
		this.sage = sage;
		this.score = score;
		this.saddress = saddress;
		this.slike = slike;
	}
	public int getSid() {
		return sid;
	}
	public void setSid(int sid) {
		this.sid = sid;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public String getSsex() {
		return ssex;
	}
	public void setSsex(String ssex) {
		this.ssex = ssex;
	}
	public int getSage() {
		return sage;
	}
	public void setSage(int sage) {
		this.sage = sage;
	}
	public double getScore() {
		return score;
	}
	public void setScore(double score) {
		this.score = score;
	}
	public String getSaddress() {
		return saddress;
	}
	public void setSaddress(String saddress) {
		this.saddress = saddress;
	}
	public String getSlike() {
		return slike;
	}
	public void setSlike(String slike) {
		this.slike = slike;
	}
	@Override
	public String toString() {
		return "Student [sid=" + sid + ", sname=" + sname + ", ssex=" + ssex + ", sage=" + sage + ", score=" + score
				+ ", saddress=" + saddress + ", slike=" + slike + "]";
	}

}

UI窗体类来啦！（这是主窗体！）

package com.zking.ui;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;

import com.zking.dao.StudentDao;
import com.zking.entity.Student;

public class Index_UI extends JFrame {
	//上
	JPanel topjp = new JPanel();
	//下拉框
	JComboBox<String> jcb = new JComboBox<>();
	//文本框
	JTextField jtf = new JTextField(10);
	//按钮
	JButton jbcx = new JButton("查询");
	
	//中
	JTable jt = new JTable();
	//表模式
	DefaultTableModel dtm = new DefaultTableModel();
	//滚动面板-给表格添加滚动面板
	JScrollPane jsp = new JScrollPane(jt);
	
	
	//下
	JPanel bottomjp = new JPanel();
	JButton jbadd = new JButton("添加");
	JButton jbdel = new JButton("删除");
	JButton jbup = new JButton("修改");
	JButton jbxq = new JButton("详情");
	JButton jbexit = new JButton("退出");
	
	
	
	
	public Index_UI() {
		this.setTitle("主窗体");
		this.setSize(500, 500);
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		this.setLocationRelativeTo(null);
		
		//上面的画布
		topjp.add(jcb);
		jcb.addItem("姓名");
		jcb.addItem("性别");
		jcb.addItem("地址");
		topjp.add(jtf);
		topjp.add(jbcx);

		//中间
		//设置表模式
		jt.setModel(dtm);
		//给表格添加标题
		dtm.addColumn("学号");
		dtm.addColumn("姓名");
		dtm.addColumn("性别");
		dtm.addColumn("年龄");
		dtm.addColumn("地址");
		
		
		//调用showInfo方法 给表格绑定数据
		showInfo("sname", "");
		
		
		//下面的画布
		bottomjp.add(jbadd);
		bottomjp.add(jbdel);
		bottomjp.add(jbup);
		bottomjp.add(jbxq);
		bottomjp.add(jbexit);
		
		
		
		
		//给查询按钮添加事件-匿名内部类
		jbcx.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				//获取下拉框中选中的选项
				String col = jcb.getSelectedItem()+"";
				if(col.equals("姓名")) {
					col = "sname";
				}else if(col.equals("性别")) {
					col = "ssex";
				}else {
					col = "saddress";
				}
				//获取关键字
				String str = jtf.getText();
				System.out.println("字段："+col);
				System.out.println("关键字:"+str);
				
				//调用showInfo方法给表格绑定数据
				showInfo(col, str);
				
			}
		});
		
		
		//给添加按钮添加事件
		jbadd.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				//打开添加窗体-同时把本窗体传过去
				new AddStu_UI(Index_UI.this);
			}
		});
		
		//给删除按钮添加事件
		jbdel.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				// 获取选中的行下标-未选中返回-1
				int row = jt.getSelectedRow();
				if (row >= 0) {
					// 获取选中行中的学生学号(第一列)
					String id = dtm.getValueAt(row, 0) + "";
					// 把字符串编号 转换为int
					int sid = Integer.valueOf(id);
					if (JOptionPane.showConfirmDialog(null, "确认要删除吗？") == 0) {
						// 调用删除方法
						int i = new StudentDao().delById(sid);
						if (i == 1) {
							JOptionPane.showMessageDialog(null, "删除成功");
							// 刷新本窗体数据
							showInfo("saddress", "");
						} else {
							JOptionPane.showMessageDialog(null, "删除失败");
						}
					} else {
						JOptionPane.showMessageDialog(null, "取消删除");
					}
				}else {
					JOptionPane.showMessageDialog(null, "请选中要删除的学生");
				}
			}
		});
		
		
		//给修改按钮添加事件
		jbup.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				//获取要修改的学生学号
				//获取选中的行
				int row = jt.getSelectedRow();
				//获取学号
				String id = dtm.getValueAt(row, 0)+"";
				int sid = Integer.valueOf(id);
				
				//根据学号查询到学生对象
				Student stu = new StudentDao().getById(sid);
				System.out.println(stu);
				//打开修改窗体
				new UpStu_UI(stu,Index_UI.this);
			}
		});
		
		
		//上边的画布
		this.getContentPane().add("North",topjp);
		this.getContentPane().add("Center",jsp);
		this.getContentPane().add("South",bottomjp);
		this.setVisible(true);
	}
	
	/**
	 * 给表格绑定数据
	 * @param col 字段名
	 * @param str 关键字
	 */
	public void showInfo(String col, String str) {
		//清空表格中的老数据
		int count = jt.getRowCount();//获取到表格中的所有数据的总行数
		System.out.println("数据行："+count);
		for(int i=0;i<count;i++) {
			dtm.removeRow(0);
		}
		// 实例化学生dao类
		StudentDao sd = new StudentDao();
		ArrayList<Student> slist = sd.getByLike(col, str);
		// 遍历集合
		for (Student s : slist) {
			// 创建一个集合，用来接收要往表格中添加的数据
			Vector<Object> v = new Vector<>();
			v.add(s.getSid());
			v.add(s.getSname());
			v.add(s.getSsex());
			v.add(s.getSage());
			v.add(s.getSaddress());
			// 行：row
			dtm.addRow(v);
		}
	}

//我就写一个修改的窗体啦（因为添加也差不多啦）

package com.zking.ui;

import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;

import com.zking.dao.StudentDao;
import com.zking.entity.Student;

/**
 * 添加学生
 * @author d
 *
 */
public class UpStu_UI extends JFrame {
	
	public UpStu_UI(Student stu,Index_UI index) {
		
		this.setTitle("修改学生");
		this.setSize(350, 500);
		this.setLocationRelativeTo(null);
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		//画布
		JPanel jp = new JPanel();
		//布局对象-网袋布局
		GridBagLayout gbl = new GridBagLayout();
		//约束对象
		GridBagConstraints gbc = new GridBagConstraints();
		//设置画布布局
		jp.setLayout(gbl);
		
		//用户名文本
		JLabel jlname = new JLabel("姓名：");
		//约束坐标位置
		gbc.gridx = 0;
		gbc.gridy = 0;
		//设置组件
		gbl.setConstraints(jlname, gbc);
		//把组件添加到画布上
		jp.add(jlname);
		
		//用户文本框
		JTextField jtname = new JTextField(10);
		gbc.gridx = 1;
		gbc.gridy = 0;
		//设置组件
		gbl.setConstraints(jtname, gbc);
		//把组件添加到画布上
		jp.add(jtname);
		
		//性别文本
		JLabel jlsex = new JLabel("性别：");
		//约束位置
		gbc.gridx = 0;
		gbc.gridy = 1;
		//设置组件位置
		gbl.setConstraints(jlsex, gbc);
		//添加到画布
		jp.add(jlsex);
		
		//单选按钮
		JRadioButton jrboy = new JRadioButton("女");
		gbc.insets = new Insets(0, -80, 0, 0);
		gbc.gridx = 1;
		gbc.gridy = 1;
		gbl.setConstraints(jrboy, gbc);
		jp.add(jrboy);
		
		JRadioButton jrgirl = new JRadioButton("男");
		//上左下右
		gbc.insets = new Insets(0, -180, 0, 0);
		gbc.gridx = 2;
		gbc.gridy = 1;
		gbl.setConstraints(jrgirl, gbc);
		jp.add(jrgirl);
		//单选按钮分组
		ButtonGroup bg = new ButtonGroup();
		bg.add(jrboy);
		bg.add(jrgirl);
		gbc.insets = new Insets(0, 0, 0, 0);
		//爱好文本-第四行、第一列
		JLabel jllike = new JLabel("爱好:");
		gbc.gridx = 0;
		gbc.gridy = 2;
		gbl.setConstraints(jllike, gbc);
		jp.add(jllike);
		
		//爱好多选框
		JCheckBox jcba = new JCheckBox("草莓袜子");
		gbc.insets = new Insets(0, -20, 0, 0);
		gbc.gridx = 1;
		gbc.gridy = 2;
		gbl.setConstraints(jcba, gbc);
		jp.add(jcba);
		
		JCheckBox jcbb = new JCheckBox("幽兰拿铁");
		
		gbc.gridx = 2;
		gbc.gridy = 2;
		gbl.setConstraints(jcbb, gbc);
		jp.add(jcbb);
		
		JCheckBox jcbc = new JCheckBox("蓝莓肚兜");
		gbc.gridx = 1;
		gbc.gridy = 3;
		gbl.setConstraints(jcbc, gbc);
		jp.add(jcbc);
		
		JCheckBox jcbd = new JCheckBox("小熊裤衩");
		gbc.gridx = 2;
		gbc.gridy = 3;
		gbl.setConstraints(jcbd, gbc);
		jp.add(jcbd);
		
		//地址文本-第六行，第一列
		JLabel jladdress = new JLabel("地址:");
		gbc.insets = new Insets(0, 0, 0, 0);
		gbc.gridx  = 0;
		gbc.gridy = 4;
		gbl.setConstraints(jladdress, gbc);
		jp.add(jladdress);
		
		//下拉框-第六行 第二列
		JComboBox<String> jc = new JComboBox<>();
		jc.addItem("长沙");
		jc.addItem("衡阳");
		jc.addItem("郴州");
		jc.addItem("娄底");
		jc.addItem("岳阳");
		jc.addItem("永州");
		jc.addItem("阜南");
		jc.addItem("张家界");
		jc.addItem("临湘");
		jc.addItem("平江");
		jc.addItem("等等");
		gbc.gridx = 1;
		gbc.gridy = 4;
		gbl.setConstraints(jc, gbc);
		jp.add(jc);
		
		//个人说明文本
		JLabel jlgrsm = new JLabel("个人说明:");
		gbc.gridx = 0;
		gbc.gridy = 5;
		gbl.setConstraints(jlgrsm, gbc);
		jp.add(jlgrsm);
		
		//文本域
		JTextArea jta = new JTextArea(5, 10);
		//滚动面板
		JScrollPane jsp = new JScrollPane(jta);
		gbc.insets = new Insets(10, 0, 10, 0);
		gbc.gridx = 1;
		gbc.gridy = 5;
		gbl.setConstraints(jsp, gbc);
		jp.add(jsp);
		
		//按钮
		JButton jbzc = new JButton("修改");
		gbc.gridx = 0;
		gbc.gridy = 6;
		gbl.setConstraints(jbzc, gbc);
		jp.add(jbzc);
		
		JButton jbqx = new JButton("取消");
		gbc.gridx = 1;
		gbc.gridy = 6;
		gbl.setConstraints(jbqx, gbc);
		jp.add(jbqx);
		
		
		//给组件赋值
		jtname.setText(stu.getSname());
		//性别
		//默认选中女
		jrboy.setSelected(true);
		if(stu.getSsex().equals("男")) {
			//如果性别为男，就设置男的单选按钮被选中
			jrgirl.setSelected(true);
		}
		//爱好
		String slike = stu.getSlike();
		if(slike.contains("草莓袜子")) {
			jcba.setSelected(true);//设置选中
		}
		if(slike.contains("幽兰拿铁")) {
			jcbb.setSelected(true);
		}
		if(slike.contains("蓝莓肚兜")) {
			jcbc.setSelected(true);
		}
		if(slike.contains("小熊裤衩")) {
			jcbd.setSelected(true);
		}
		
		//地址
		jc.setSelectedItem(stu.getSaddress());
		
		//个性签名
		jta.setText(stu.getSgxqm());
		
		
		//给修改按钮添加事件
		jbzc.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				// 获取组件的值
				String sname = jtname.getText();
				String ssex = "男";
				if (jrboy.isSelected()) {
					ssex = "女";
				}
				String slike = "";
				if (jcba.isSelected()) {
					slike += "草莓袜子";
				}
				if (jcbb.isSelected()) {
					slike += "幽兰拿铁";
				}
				if (jcbc.isSelected()) {
					slike += "蓝莓肚兜";
				}
				if (jcbd.isSelected()) {
					slike += "小熊裤衩";
				}
				String saddress = jc.getSelectedItem() + "";
				String sgxqm = jta.getText();
				// 实例化学生对象
				Student s = new Student(sname, ssex, saddress, slike, sgxqm);
				// 调用修改方法
				int i = new StudentDao().upStu(stu.getSid(), s);
				if (i == 1) {
					JOptionPane.showMessageDialog(null, "修改成功");
					// 刷新数据
					index.showInfo("ssex", "");
					// 释放本窗体资源
					UpStu_UI.this.dispose();
				} else {
					JOptionPane.showMessageDialog(null, "修改失败");
				}

			}
		});
		
		//给取消按钮添加事件
		jbqx.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				//释放本窗体资源
				UpStu_UI.this.dispose();
			}
		});
		
		
		
		this.getContentPane().add(jp);
		this.setVisible(true);
	}
	
	

}

接下来就是util帮助类啦！

package com.zking.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class DBHelper {
	private static String cname = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//注册驱动类的类的路径
	private static String url = "jdbc:sqlserver://localhost:1433;DatabaseName=T277";
	private static String uname = "sa";
	private static String upwd = "8023";
	
	static {
		try {
			Class.forName(cname);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	/**
	 * 连接数据库
	 * @return
	 */
	public static Connection getCon() {
		Connection con = null;
		try {
			con = DriverManager.getConnection(url, uname, upwd);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return con;
	}
	
	/**
	 * 关闭连接
	 * @param con Connection对象
	 * @param ps PreparedStatement对象
	 * @param rs ResultSet 对象
	 */
	public static void closeDB(Connection con,PreparedStatement ps,ResultSet rs) {
		try {
			if(con!=null) {
				con.close();
			}
			if(ps!=null) {
				ps.close();
			}
			if(rs!=null) {
				rs.close();
			}
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}

以上就是swing版本的学生管理系统啦！

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2022-05-18，如有侵权请联系 cloudcommunity@tencent.com 删除

java

本文分享自作者个人站点/博客前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

本文参与腾讯云自媒体同步曝光计划，欢迎热爱写作的你一起参与！

java

登录后参与评论

0 条评论

热度

学生管理系统——Swing窗体版本

学生管理系统——Swing窗体版本

上一次一个小伙伴私聊我，说：有没有swing版本的学生管理系统让他参考一下。

这次给他安排上啦！

首先来看看有什么文件吧(得要有个适合自己的命名规则很重要，如果自己都看不懂，那么别人就更难懂啦！)

实体类来啦（根据自己所需要的字段来写哦！）

UI窗体类来啦！（这是主窗体！）

//我就写一个修改的窗体啦（因为添加也差不多啦）

以上就是swing版本的学生管理系统啦！

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐