目录
一.程序结构设计
二.项目图片展示
1.登录界面
2.注册界面
3.管理后台主界面
（1）查询所有学生
（2）通过学号查询单个学生
（3）删除单个学生
4.添加学生界面
5.修改学生界面
三.项目代码
一.在数据库中建表
（1）学生信息表
（2）登录用户表
二.Data对象(Pojo)
(1)学生类
(2)用户类
三.mapper代理层
(1)StudentMapper
(2)UserMapper(sql语句比较短用的注解开发)
四.service层
（1）studentService
（2）userService
五.图形界面GUI层
（1）LoginView（登录界面）
（2）RegisterVie（注册界面）
（3）UserListView（系统主界面）
（4）UpdateView（修改信息界面）
（5）AddView（添加学生界面）
六.工具类
七.配置文件
（1）pom文件
（2）mybatis-config.xml
（3）StudentMapper.xml
（4）UserMapper.xml
四.待优化处及gitee仓库地址
一.程序结构设计
利用maven对项目进行管理简化了手动jar包导入的过程。采用了类似三层架构的思想将业务逻辑层，数据访问层和表现层分包编写。在数据访问层用Mybatis简化了JDBC代码的书写，采取mapper代理开发让Mybatis更加简单。在业务逻辑层编写了增删改查注册登录方法可以供表现层单独调用。在表现层以图形界面形式展示各个功能，捕获用户操作对数据库进行处理。
二.项目图片展示
1.登录界面
用户可以填写账号密码进行注册，注册时会检测数据库中是否存在相同账号，如果已存在则会拦截注册并跳出提醒窗口，反之注册成功。登录和注册窗口可以相互跳转。
2.注册界面
可拦截重复注册数据库中已存在的账号，密码不检查。按注册未输入账号密码会跳出相应提醒对话框，如果输入账号在数据库已存在也会跳出相应提醒对话框。按重置会清空输入的账号和密码，按返回会跳转回登录界面。
3.管理后台主界面
（1）查询所有学生
登录进去后默认展示数据库中已添加的全部学生
（2）通过学号查询单个学生
可以输入学号查询存在的学生，如果查询的学生不存在则跳出提醒对话框，点击重置可以查看全部学生。
（3）删除单个学生
可以单击选中某条数据再按删除按钮删除学生
4.添加学生界面
点击添加学生按钮可弹出新窗口录入学生数据，可检查学号是否已存在，如果存在则会拦截本次添加，否则将录入的数据存入数据库中。
5.修改学生界面
需要在主界面单击选中某条学生然后点击修改按钮，可跳出一个修改界面，在界面中会回显该学生所有数据
三.项目代码
一.在数据库中建表
（1）学生信息表
CREATE database studentMessage;
create table studentall
(
id int auto_increment primary key,
sid varchar(32) null,
name varchar(16) null,
age int null,
major varchar(16) null,
grade varchar(16) null,
loveSubj varchar(16) null
);（2）登录用户表
CREATE TABLE tb_user(
id INT PRIMARY KEY,
username VARCHAR(20),
password varchar(20)
);
SELECT * from tb_user;二.Data对象(Pojo)
(1)学生类
package guanzhi.pojo;
/**
* @author CSDN 观止study
*/
public class Student {
private int id;
private String sid;
private String name;
private int age;
private String major;
private String grade;
private String loveSubj;
public Student() {
}
public Student(String sid, String name, int age, String major, String grade, String loveSubj) {
this.sid = sid;
this.name = name;
this.age = age;
this.major = major;
this.grade = grade;
this.loveSubj = loveSubj;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getSid() {
return sid;
}
public void setSid(String sid) {
this.sid = sid;
}
public String getLoveSubj() {
return loveSubj;
}
public void setLoveSubj(String loveSubj) {
this.loveSubj = loveSubj;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getMajor() {
return major;
}
public void setMajor(String major) {
this.major = major;
}
public String getGrade() {
return grade;
}
public void setGrade(String grade) {
this.grade = grade;
}
@Override
public String toString() {
return "Student{" +
"sid=" + sid +
", name='" + name + '\'' +
", age=" + age +
", major='" + major + '\'' +
", grade='" + grade + '\'' +
", loveSubj='" + loveSubj + '\'' +
'}';
}
}(2)用户类
package guanzhi.pojo;
/**
* @author 观止
*/
public class User {
private Integer id;
private String username;
private String password;
public User() {
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}三.mapper代理层
(1)StudentMapper
package guanzhi.mapper;
import guanzhi.pojo.Student;
import java.util.List;
/**
* @author CSDN 观止study
*/
public interface StudentMapper {
//查询所有学生
List<Student> selectAll();
//添加学生
void add(Student student);
//验证学号和姓名删除学生
void delete(int id);
//修改学生信息
void update(Student student);
// 根据学号查询单个学生
Student selectBySid(String sid);
// 根据id查询单个学生
Student selectById(int id);
}(2)UserMapper(sql语句比较短用的注解开发)
package guanzhi.mapper;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import guanzhi.pojo.User;
/**
* @author CSDN 观止study
*/
public interface UserMapper {
@Select("select * from tb_user where username=#{username} and password=#{password}")
User select(@Param("username") String username, @Param("password") String password);
@Insert("insert into tb_user (id,username,password) values(null,#{username},#{password})")
void insert(User user);
@Select("select * from tb_user where username=#{username}")
User selectByUsername(String username);
}四.service层
（1）studentService
package guanzhi.service;
import guanzhi.mapper.StudentMapper;
import org.apache.ibatis.session.SqlSession;
import guanzhi.pojo.Student;
import guanzhi.util.SqlSessionFactoryUtils;
import java.util.List;
/**
* @author CSDN 观止study
*/
public class StudentService {
public List<Student> selectAll() {
try (SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSession()) {
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
return mapper.selectAll();
}
}
public void add(Student student) {
try (SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSession()) {
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
mapper.add(student);
sqlSession.commit();
}
}
public void delete(int sid) {
try (SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSession()) {
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
mapper.delete(sid);
sqlSession.commit();
}
}
public void update(Student student) {
try (SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSession()) {
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
mapper.update(student);
sqlSession.commit();
}
}
public Student selectBySid(String sid) {
try (SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSession()) {
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
return mapper.selectBySid(sid);
}
}
public Student selectByid(int id) {
try (SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSession()) {
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
return mapper.selectById(id);
}
}
}（2）userService
package guanzhi.service;
import guanzhi.mapper.UserMapper;
import org.apache.ibatis.session.SqlSession;
import guanzhi.pojo.User;
import guanzhi.util.SqlSessionFactoryUtils;
/**
* @author CSDN 观止study
*/
public class UserService {
public boolean check(String username) {
try (SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSession()) {
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User user = mapper.selectByUsername(username);
return user == null;
}
}
public void regiser(User user) {
try (SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSession()) {
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
mapper.insert(user);
sqlSession.commit();
}
}
public Boolean login(String username, String password) {
try (SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSession()) {
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User user = mapper.select(username, password);
return user != null;
}
}
}五.图形界面GUI层
（1）LoginView（登录界面）
package guanzhi.GUITest;
import guanzhi.service.UserService;
import javax.swing.*;
import javax.swing.border.EmptyBorder;
import java.awt.*;
/**
* @author CSDN 观止study
*/
public class LoginView extends JFrame {
private JPanel contentPane;
private JTextField usernameText;
private JTextField passwordText;
private UserService userservice = new UserService();
/**
* 右键启动该界面
*
* @param args
*/
public static void main(String[] args) {
EventQueue.invokeLater(() -> {
try {
LoginView frame = new LoginView();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
});
}
public LoginView() {
setTitle("欢迎登录");
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setBounds(100, 100, 380, 250);
setLocationRelativeTo(null);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
JLabel lblNewLabel = new JLabel("账号：");
lblNewLabel.setBounds(92, 50, 50, 15);
contentPane.add(lblNewLabel);
usernameText = new JTextField();
usernameText.setBounds(131, 47, 160, 21);
contentPane.add(usernameText);
usernameText.setColumns(10);
JLabel lblNewLabel_1 = new JLabel("密码：");
lblNewLabel_1.setBounds(92, 93, 43, 15);
contentPane.add(lblNewLabel_1);
passwordText = new JTextField();
passwordText.setBounds(131, 90, 160, 21);
contentPane.add(passwordText);
passwordText.setColumns(10);
//跳转注册
JButton registerBtn = new JButton("注册");
registerBtn.addActionListener(e -> {
RegisterView view = new RegisterView();
view.setVisible(true);
dispose();
});
registerBtn.setBounds(210, 150, 74, 23);
contentPane.add(registerBtn);
//登录
JButton LoginBtn = new JButton("登录");
LoginBtn.addActionListener(e -> {
stulogin();
});
LoginBtn.setBounds(115, 150, 74, 23);
contentPane.add(LoginBtn);
}
//登录逻辑判断
public void stulogin() {
//调用服务层逻辑验证账号密码
if (userservice.login(usernameText.getText(), passwordText.getText())) {
JOptionPane.showMessageDialog(null, "登录成功！", "提示消息", JOptionPane.WARNING_MESSAGE);
//关闭当前界面
dispose();
//登录成功跳出新界面
UserListView view = new UserListView();
view.setVisible(true);
} else if (usernameText.getText().isEmpty() && passwordText.getText().isEmpty()) {
JOptionPane.showMessageDialog(null, "请输入用户名和密码！", "提示消息", JOptionPane.WARNING_MESSAGE);
} else if (usernameText.getText().isEmpty()) {
JOptionPane.showMessageDialog(null, "请输入用户名！", "提示消息", JOptionPane.WARNING_MESSAGE);
} else if (passwordText.getText().isEmpty()) {
JOptionPane.showMessageDialog(null, "请输入密码！", "提示消息", JOptionPane.WARNING_MESSAGE);
} else {
JOptionPane.showMessageDialog(null, "用户名或者密码错误！\n请重新输入", "提示消息", JOptionPane.ERROR_MESSAGE);
usernameText.setText("");
passwordText.setText("");
}
}
}（2）RegisterVie（注册界面）
package guanzhi.GUITest;
import guanzhi.pojo.User;
import guanzhi.service.UserService;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.border.EmptyBorder;
/**
* @author CSDN 观止study
*/
public class RegisterView extends JFrame {
private JPanel contentPane;
private JTextField usernameText;
private JTextField passwordText;
private UserService userservice = new UserService();
public RegisterView() {
setTitle("欢迎注册");
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setBounds(100, 100, 380, 250);
setLocationRelativeTo(null);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
JLabel lblNewLabel = new JLabel("账号：");
lblNewLabel.setBounds(92, 50, 50, 15);
contentPane.add(lblNewLabel);
usernameText = new JTextField();
usernameText.setBounds(131, 47, 160, 21);
contentPane.add(usernameText);
usernameText.setColumns(10);
JLabel lblNewLabel_1 = new JLabel("密码：");
lblNewLabel_1.setBounds(92, 93, 43, 15);
contentPane.add(lblNewLabel_1);
passwordText = new JTextField();
passwordText.setBounds(131, 90, 160, 21);
contentPane.add(passwordText);
passwordText.setColumns(10);
//注册
JButton registerBtn = new JButton("注册");
registerBtn.addActionListener(e -> {
String username = usernameText.getText();
String password = passwordText.getText();
if (username == null || "".equals(username)) {
JOptionPane.showMessageDialog(contentPane, "请输入账号", "系统提示", JOptionPane.WARNING_MESSAGE);
} else if (password == null || "".equals(password)) {
JOptionPane.showMessageDialog(contentPane, "请输入密码", "系统提示", JOptionPane.WARNING_MESSAGE);
//检查用户名是否重复
} else if (userservice.check(username)) {
if (username.isEmpty() && password.isEmpty()) {
JOptionPane.showMessageDialog(null, "请输入用户名和密码！", "提示消息", JOptionPane.WARNING_MESSAGE);
} else {
User user = new User();
user.setUsername(username);
user.setPassword(password);
//调用方法在数据库中存入数据
userservice.regiser(user);
JOptionPane.showMessageDialog(null, "注册成功！", "提示消息", JOptionPane.WARNING_MESSAGE);
LoginView view = new LoginView();
view.setVisible(true);
dispose();
}
} else {
JOptionPane.showMessageDialog(contentPane, "用户名已存在", "系统提示", JOptionPane.WARNING_MESSAGE);
usernameText.setText("");
passwordText.setText("");
}
});
registerBtn.setBounds(115, 150, 74, 23);
contentPane.add(registerBtn);
//重置
JButton LoginBtn = new JButton("重置");
LoginBtn.addActionListener(e -> {
usernameText.setText("");
passwordText.setText("");
});
LoginBtn.setBounds(210, 150, 74, 23);
contentPane.add(LoginBtn);
//返回
JButton returnBtn = new JButton("返回");
returnBtn.addActionListener(e -> {
LoginView view = new LoginView();
view.setVisible(true);
dispose();
});
returnBtn.setBounds(160, 180, 74, 23);
contentPane.add(returnBtn);
}
}（3）UserListView（系统主界面）
package guanzhi.GUITest;
import guanzhi.pojo.Student;
import guanzhi.service.StudentService;
import javax.swing.*;
import javax.swing.border.EmptyBorder;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;
import java.util.List;
/**
* @author CSDN 观止study
*/
public class UserListView extends JFrame {
private JPanel contentPane;
private JTable table;
private JTextField sidText;
private StudentService service = new StudentService();
public UserListView() {
setTitle("学生信息管理系统");
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 600, 337);
setLocationRelativeTo(null);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
JScrollPane scrollPane = new JScrollPane();
scrollPane.setBounds(10, 39, 564, 232);
contentPane.add(scrollPane);
Object[] columns = {"序号", "学号", "名字", "年龄", "专业", "班级", "偏爱学科", "唯一标识"};
DefaultTableModel model = new DefaultTableModel(null, columns);
table = new JTable(model);
// 隐藏唯一标识
TableColumn emailColumn = table.getColumnModel().getColumn(7);
// 将该列的最小宽度设置为0，从而隐藏该列
emailColumn.setMinWidth(0);
emailColumn.setMaxWidth(0);
emailColumn.setWidth(0);
emailColumn.setPreferredWidth(0);
//加载学生数据
load(null);
scrollPane.setViewportView(table);
// 搜索学生
JLabel lblNewLabel = new JLabel("学号");
lblNewLabel.setBounds(10, 10, 42, 15);
contentPane.add(lblNewLabel);
sidText = new JTextField();
sidText.setBounds(44, 8, 115, 21);
contentPane.add(sidText);
sidText.setColumns(10);
//查看按钮
JButton searchBtn = new JButton("重置");
searchBtn.addActionListener(e -> load(sidText.getText()));
searchBtn.setBounds(300, 8, 63, 23);
contentPane.add(searchBtn);
//搜索学生
JButton searchBtn1 = new JButton("搜索");
searchBtn1.addActionListener(e -> search(sidText.getText()));
searchBtn1.setBounds(169, 8, 63, 23);
contentPane.add(searchBtn1);
//添加按钮
JButton addBtn = new JButton("添加");
addBtn.addActionListener(e -> {
AddView view = new AddView(this);
view.setVisible(true);
});
addBtn.setBounds(365, 8, 63, 23);
contentPane.add(addBtn);
//修改按钮
JButton updateBtn = new JButton("修改");
updateBtn.addActionListener(e -> {
// 获取选中行
int row = table.getSelectedRow();
if (row < 0) {
JOptionPane.showMessageDialog(contentPane, "请选择一条记录", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
int id = Integer.parseInt((String) table.getValueAt(row, 7));
UpdateView view = new UpdateView(id, this);
view.setVisible(true);
});
updateBtn.setBounds(438, 8, 63, 23);
//删除按钮
JButton deleteBtn = new JButton("删除");
deleteBtn.addActionListener(e -> {
// 获取选中行
int row = table.getSelectedRow();
if (row < 0) {
JOptionPane.showMessageDialog(contentPane, "请选择一条记录", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
int result = JOptionPane.showConfirmDialog(contentPane, "确认删除该学生吗？", "提示",
JOptionPane.YES_NO_OPTION);
if (result == 0) {
int sid = Integer.parseInt(table.getValueAt(row, 7).toString());
//删除数据库中的记录
service.delete(sid);
JOptionPane.showMessageDialog(contentPane, "删除成功!");
load(null);
}
});
deleteBtn.setBounds(511, 8, 63, 23);
contentPane.add(deleteBtn);
contentPane.add(updateBtn);
}
// 加载全部数据
public void load(String sid) {
List<Student> list = service.selectAll();
DefaultTableModel tableModel = (DefaultTableModel) table.getModel();
tableModel.setRowCount(0);
// 填充数据
for (int i = 0; i < list.size(); i++) {
Student student = list.get(i);
String[] arr = getCol(student);
arr[0] = String.valueOf(i + 1);
// 添加数据到表格
tableModel.addRow(arr);
}
}
public void search(String sid) {
//通过学号查找单个学生
Student student = service.selectBySid(sid);
if (student != null) {
DefaultTableModel tableModel = (DefaultTableModel) table.getModel();
// 清除原有行
tableModel.setRowCount(0);
// 添加数据到表格
tableModel.addRow(getCol(student));
} else {
JOptionPane.showMessageDialog(contentPane, "不存在该学生", "系统提示", JOptionPane.WARNING_MESSAGE);
}
}
public String[] getCol(Student student) {
String[] arr = new String[8];
arr[0] = String.valueOf(0);
arr[1] = student.getSid();
arr[2] = student.getName();
arr[3] = String.valueOf(student.getAge());
arr[4] = student.getMajor();
arr[5] = student.getGrade();
arr[6] = student.getLoveSubj();
arr[7] = String.valueOf(student.getId());
return arr;
}
}（4）UpdateView（修改信息界面）
package guanzhi.GUITest;
import guanzhi.pojo.Student;
import guanzhi.service.StudentService;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.border.EmptyBorder;
/**
* @author CSDN 观止study
*/
public class UpdateView extends JFrame {
private JPanel contentPane;
private JTextField sidText;
private JTextField nameText;
private JTextField ageText;
private JTextField majorText;
private JTextField gradeText;
private JTextField loveSubjText;
private StudentService service = new StudentService();
public UpdateView(final int id,UserListView userListView) {
setTitle("学生编辑");
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setBounds(100, 100, 443, 450);
setLocationRelativeTo(null);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
JLabel lblNewLabel = new JLabel("学号：");
lblNewLabel.setBounds(112, 50, 43, 15);
contentPane.add(lblNewLabel);
sidText = new JTextField();
sidText.setBounds(151, 47, 160, 21);
contentPane.add(sidText);
sidText.setColumns(10);
JLabel lblNewLabel_1 = new JLabel("姓名：");
lblNewLabel_1.setBounds(112, 93, 43, 15);
contentPane.add(lblNewLabel_1);
nameText = new JTextField();
nameText.setBounds(151, 90, 160, 21);
contentPane.add(nameText);
nameText.setColumns(10);
JLabel lblNewLabel_2 = new JLabel("年龄：");
lblNewLabel_2.setBounds(112, 134, 43, 15);
contentPane.add(lblNewLabel_2);
ageText = new JTextField();
ageText.setBounds(151, 130, 160, 21);
contentPane.add(ageText);
ageText.setColumns(10);
JLabel lblNewLabel_3 = new JLabel("专业：");
lblNewLabel_3.setBounds(112, 177, 43, 15);
contentPane.add(lblNewLabel_3);
majorText = new JTextField();
majorText.setBounds(151, 177, 160, 21);
contentPane.add(majorText);
majorText.setColumns(10);
JLabel lblNewLabel_4 = new JLabel("班级：");
lblNewLabel_4.setBounds(111, 220, 43, 15);
contentPane.add(lblNewLabel_4);
gradeText = new JTextField();
gradeText.setBounds(151, 220, 160, 21);
contentPane.add(gradeText);
gradeText.setColumns(10);
JLabel lblNewLabel_5 = new JLabel("偏爱学科：");
lblNewLabel_5.setBounds(90, 263, 70, 15);
contentPane.add(lblNewLabel_5);
loveSubjText = new JTextField();
loveSubjText.setBounds(151, 263, 160, 21);
contentPane.add(loveSubjText);
loveSubjText.setColumns(10);
//保存
JButton saveBtn = new JButton("保存");
saveBtn.addActionListener(e -> {
String sid = sidText.getText();
String name = nameText.getText();
String age = ageText.getText();
String major = majorText.getText();
String grade = gradeText.getText();
String loveSubj = loveSubjText.getText();
if (sid == null || "".equals(sid)) {
JOptionPane.showMessageDialog(contentPane, "请输入学号", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
if (name == null || "".equals(name)) {
JOptionPane.showMessageDialog(contentPane, "请输入姓名", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
if (age == null || "".equals(age)) {
JOptionPane.showMessageDialog(contentPane, "请输入年龄", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
if (major == null || "".equals(major)) {
JOptionPane.showMessageDialog(contentPane, "请输入专业", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
if (grade == null || "".equals(grade)) {
JOptionPane.showMessageDialog(contentPane, "请输入年纪", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
if (loveSubj == null || "".equals(loveSubj)) {
JOptionPane.showMessageDialog(contentPane, "请输入偏爱学科", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
// 判断学号是否重复
Student s = service.selectBySid(sid);
if (s != null && s.getId() != id) {
JOptionPane.showMessageDialog(contentPane, "学号已存在", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
Student student = new Student();
student.setSid(sid);
student.setName(name);
student.setAge(Integer.parseInt(age));
student.setMajor(major);
student.setGrade(grade);
student.setLoveSubj(loveSubj);
student.setId(id);
//修改并保存重新录入的数据
service.update(student);
dispose();
JOptionPane.showMessageDialog(contentPane, "修改成功!");
userListView.load(null);
});
saveBtn.setBounds(151, 300, 74, 23);
contentPane.add(saveBtn);
//取消
JButton cancelBtn = new JButton("取消");
cancelBtn.addActionListener(e -> dispose());
cancelBtn.setBounds(237, 300, 74, 23);
contentPane.add(cancelBtn);
//数据回显
Student student = service.selectByid(id);
sidText.setText(student.getSid());
nameText.setText(student.getName());
ageText.setText(String.valueOf(student.getAge()));
majorText.setText(student.getMajor());
gradeText.setText(student.getGrade());
loveSubjText.setText(student.getLoveSubj());
}
}（5）AddView（添加学生界面）
package guanzhi.GUITest;
import guanzhi.pojo.Student;
import guanzhi.service.StudentService;
import javax.swing.*;
import javax.swing.border.EmptyBorder;
/**
* @author CSDN 观止study
*/
public class AddView extends JFrame {
private JPanel contentPane;
private JTextField sidText;
private JTextField nameText;
private JTextField ageText;
private JTextField majorText;
private JTextField gradeText;
private JTextField loveSubjText;
private StudentService service = new StudentService();
public AddView(UserListView userListView) {
setTitle("学生添加");
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setBounds(100, 100, 443, 450);
setLocationRelativeTo(null);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
JLabel lblNewLabel = new JLabel("学号：");
lblNewLabel.setBounds(112, 50, 43, 15);
contentPane.add(lblNewLabel);
sidText = new JTextField();
sidText.setBounds(151, 47, 160, 21);
contentPane.add(sidText);
sidText.setColumns(10);
JLabel lblNewLabel_1 = new JLabel("姓名：");
lblNewLabel_1.setBounds(112, 93, 43, 15);
contentPane.add(lblNewLabel_1);
nameText = new JTextField();
nameText.setBounds(151, 90, 160, 21);
contentPane.add(nameText);
nameText.setColumns(10);
JLabel lblNewLabel_2 = new JLabel("年龄：");
lblNewLabel_2.setBounds(112, 134, 43, 15);
contentPane.add(lblNewLabel_2);
ageText = new JTextField();
ageText.setBounds(151, 130, 160, 21);
contentPane.add(ageText);
ageText.setColumns(10);
JLabel lblNewLabel_3 = new JLabel("专业：");
lblNewLabel_3.setBounds(112, 177, 43, 15);
contentPane.add(lblNewLabel_3);
majorText = new JTextField();
majorText.setBounds(151, 177, 160, 21);
contentPane.add(majorText);
majorText.setColumns(10);
JLabel lblNewLabel_4 = new JLabel("班级：");
lblNewLabel_4.setBounds(111, 220, 43, 15);
contentPane.add(lblNewLabel_4);
gradeText = new JTextField();
gradeText.setBounds(151, 220, 160, 21);
contentPane.add(gradeText);
gradeText.setColumns(10);
JLabel lblNewLabel_5 = new JLabel("偏爱学科：");
lblNewLabel_5.setBounds(90, 263, 70, 15);
contentPane.add(lblNewLabel_5);
loveSubjText = new JTextField();
loveSubjText.setBounds(151, 263, 160, 21);
contentPane.add(loveSubjText);
loveSubjText.setColumns(10);
//保存
JButton saveBtn = new JButton("保存");
saveBtn.addActionListener(e -> {
String sid = sidText.getText();
String name = nameText.getText();
String age = ageText.getText();
String major = majorText.getText();
String grade = gradeText.getText();
String loveSubj = loveSubjText.getText();
if (sid == null || "".equals(sid)) {
JOptionPane.showMessageDialog(contentPane, "请输入学号", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
if (name == null || "".equals(name)) {
JOptionPane.showMessageDialog(contentPane, "请输入姓名", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
if (age == null || "".equals(age)) {
JOptionPane.showMessageDialog(contentPane, "请输入年龄", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
if (major == null || "".equals(major)) {
JOptionPane.showMessageDialog(contentPane, "请输入专业", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
if (grade == null || "".equals(grade)) {
JOptionPane.showMessageDialog(contentPane, "请输入年纪", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
if (loveSubj == null || "".equals(loveSubj)) {
JOptionPane.showMessageDialog(contentPane, "请输入偏爱学科", "系统提示", JOptionPane.WARNING_MESSAGE);
return;
}
// 查看学号是否已存在
if (service.selectBySid(sid) != null) {
JOptionPane.showMessageDialog(contentPane, "学号已存在!");
return;
}
Student student = new Student();
student.setSid(sid);
student.setName(name);
student.setAge(Integer.parseInt(age));
student.setMajor(major);
student.setGrade(grade);
student.setLoveSubj(loveSubj);
try {
//添加学生
service.add(student);
dispose();
JOptionPane.showMessageDialog(contentPane, "添加成功!");
userListView.load(null);
} catch (Exception error) {
JOptionPane.showMessageDialog(contentPane, "该学号已存在", "系统提示", JOptionPane.WARNING_MESSAGE);
}
});
saveBtn.setBounds(151, 300, 74, 23);
contentPane.add(saveBtn);
//取消
JButton cancelBtn = new JButton("取消");
cancelBtn.addActionListener(e -> dispose());
cancelBtn.setBounds(237, 300, 74, 23);
contentPane.add(cancelBtn);
}
}六.工具类
package guanzhi.util;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
/**
* @author CSDN 观止study
*/
public class SqlSessionFactoryUtils {
private static SqlSessionFactory sqlSessionFactory;
static {
//静态代码块会随着类的加载自动执行，且只执行一次
try {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
}
public static SqlSession getSqlSession() {
return sqlSessionFactory.openSession();
}
}七.配置文件
（1）pom文件
<properties>
<maven.compiler.source>17</maven.compiler.source>
<maven.compiler.target>17</maven.compiler.target>
</properties>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.23</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>16</source>
<target>16</target>
</configuration>
</plugin>
</plugins>
</build>（2）mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!--CSDN 观止study-->
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url" value="jdbc:mysql:///studentmessage?useSSL=false&useServerPrepStmts=true"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<!--扫描mapper-->
<package name="guanzhi.mapper"/>
</mappers>
</configuration>（3）StudentMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!--CSDN 观止study-->
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="guanzhi.mapper.StudentMapper">
<insert id="add">
insert into studentall
(sid, name, age, major, grade, loveSubj)
values (#{sid}, #{name}, #{age}, #{major}, #{grade}, #{loveSubj})
</insert>
<update id="update">
UPDATE studentall
SET name=#{name},
age=#{age},
major=#{major},
grade=#{grade},
loveSubj=#{loveSubj},
sid=#{sid}
WHERE id = #{id}
</update>
<delete id="delete">
delete
from studentall
where id = #{id}
</delete>
<select id="selectAll" resultType="guanzhi.pojo.Student">
select *
from studentAll
</select>
<select id="selectBySid" resultType="guanzhi.pojo.Student">
select *
from studentAll
where sid = #{sid}
</select>
<select id="selectById" resultType="guanzhi.pojo.Student">
select *
from studentAll
where id = #{id}
</select>
</mapper>（4）UserMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!--CSDN 观止study-->
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="guanzhi.mapper.UserMapper">
</mapper>四.待优化处及gitee仓库地址
1.由于不熟悉图形界面的开发，图形界面开发的比较简陋，各种按钮及标签的坐标都是一点一点移动对齐的，页面展示的功能也比较简单。
2.数据创建学生信息表时直接将学号sid当成主键为int型，结果后期调试时发现输入超过10位的学号程序便会抛出异常，由于需要改的地方太多了便没有修改，我觉得此处多设置一个主键id，然后将sid设置为String型比较好。
注：bug已修复，功能更加完善，建议直接git拉取最新代码或者在上述复制粘贴最新代码，压缩包内代码还未更新
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
