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

上一次一个小伙伴私聊我，说：有没有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.se