用JDBC方法编写第一个项目关于学生管理系统_package xiaoqu; import java.sql.resultset; import -优快云博客

本文链接：https://blog.youkuaiyun.com/qingmeilucha/article/details/99560949

这是一个学生信息管理系统，包括添加、删除、修改和查询学生信息的功能。系统使用Java编程，通过控制台输入学号、姓名和地址进行操作，利用DBUtil工具类进行数据库的增删改查。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com.jd.util;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Scanner;

import 我.Student;

public class StudentServese {
	public static void main(String[] args) {
		System.out.println("*********************************");
		System.out.println("*\t\t\t\t*");
		System.out.println("*\t欢迎使用学生信息管理系统\t*");
		System.out.println("*\t\t\t\t*");
		System.out.println("*********************************");
		while (true) {
			menu();
		}
	}
	static void menu() {
		System.out.println("1、添加学生信息");
		System.out.println("2、删除学生信息");
		System.out.println("3、修改学生信息");// 地址传递
		System.out.println("4、查询学生信息");// name
		System.out.println("请输入操作，以Enter键结束:");
		Scanner scanner = new Scanner(System.in);
		int option = scanner.nextInt();
		switch (option) {
		case 1: {
			System.out.println("请输入学号");
			String id = scanner.next();
			System.out.println("请输入姓名");
			String name = scanner.next();
			System.out.println("请输入地址");
			String address = scanner.next();
			if (DBUtil.exist("select id from user where id=?", id)) {
				System.out.println("学号不能重复");
				return;
			}
			if (DBUtil.update("insert into user(id,name,address)values(?,?,?)",id, name, address)) {
				System.out.println("id:" + id + ",name:" + name + ",address" + address);
			} else {
				System.out.println("添加失败");
			}
			break;
		}
		case 2: {
			System.out.println("请输入学号");
			String id = scanner.next();
			if (!DBUtil.exist("select * from user where id=?", id)) {
				System.out.println("学号为" + id + "同学不存在");
				return;
			}
			if (DBUtil.update("delete from user where id=?", id)) {
				System.out.println("删除成功");
			} else {
				System.out.println("删除失败");
			}
			break;
		}
		case 3: {
			
			System.out.println("请输入学号：");
			String id = scanner.next();
			if (!DBUtil.exist("select *from user where id=?", id)) {
				System.out.println("学号为" + id + "同学不存在");
				return;
			}
			System.out.println("请输入新名字");
			String name = scanner.next();
			System.out.println("请输入新地址");
			String address = scanner.next();
			if (DBUtil.update("update user set name=?,address=? where id=?",name,address, id)) {
				System.out.println("name:" + name + "address" + address);
			} else {
				System.out.println("修改失败");
			}
			break;
		}
		case 4: {
			System.out.println("请输入学号：");
			String id = scanner.next();
			class RowMapper implements IRowMapper {

				public void rowMapper(ResultSet resultSet) {
					if (DBUtil.exist("select * from user where id=?", id)) {
						System.out.println(id);
					} else {
						System.out.println("学号为" + id + "同学不存在");
					}
					try {
						if(resultSet.next()) {
							String na=resultSet.getString("name");
							String ad=resultSet.getString("address");
							System.out.println("id="+id+",name="+na+",ad="+ad);
						}else {
							System.out.println("不存在");
						}
					} catch (SQLException e) {
						e.printStackTrace();
					}
				}
			}
			DBUtil.select("select *from user where id=?", new RowMapper(),id);
			break;
		}
		default: {
			System.out.println("I'm Sorry,there is not the " + option + "option,please try again.");
			}
		}
	}
}

package com.jd.util;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Scanner;

import 我.Student;

public class StudentServese {
	public static void main(String[] args) {
		System.out.println("*********************************");
		System.out.println("*\t\t\t\t*");
		System.out.println("*\t欢迎使用学生信息管理系统\t*");
		System.out.println("*\t\t\t\t*");
		System.out.println("*********************************");
		while (true) {
			menu();
		}
	}
	static void menu() {
		System.out.println("1、添加学生信息");
		System.out.println("2、删除学生信息");
		System.out.println("3、修改学生信息");// 地址传递
		System.out.println("4、查询学生信息");// name
		System.out.println("请输入操作，以Enter键结束:");
		Scanner scanner = new Scanner(System.in);
		int option = scanner.nextInt();
		switch (option) {
		case 1: {
			System.out.println("请输入学号");
			String id = scanner.next();
			System.out.println("请输入姓名");
			String name = scanner.next();
			System.out.println("请输入地址");
			String address = scanner.next();
			if (DBUtil.exist("select id from user where id=?", id)) {
				System.out.println("学号不能重复");
				return;
			}
			if (DBUtil.update("insert into user(id,name,address)values(?,?,?)",id, name, address)) {
				System.out.println("id:" + id + ",name:" + name + ",address" + address);
			} else {
				System.out.println("添加失败");
			}
			break;
		}
		case 2: {
			System.out.println("请输入学号");
			String id = scanner.next();
			if (!DBUtil.exist("select * from user where id=?", id)) {
				System.out.println("学号为" + id + "同学不存在");
				return;
			}
			if (DBUtil.update("delete from user where id=?", id)) {
				System.out.println("删除成功");
			} else {
				System.out.println("删除失败");
			}
			break;
		}
		case 3: {
			
			System.out.println("请输入学号：");
			String id = scanner.next();
			if (!DBUtil.exist("select *from user where id=?", id)) {
				System.out.println("学号为" + id + "同学不存在");
				return;
			}
			System.out.println("请输入新名字");
			String name = scanner.next();
			System.out.println("请输入新地址");
			String address = scanner.next();
			if (DBUtil.update("update user set name=?,address=? where id=?",name,address, id)) {
				System.out.println("name:" + name + "address" + address);
			} else {
				System.out.println("修改失败");
			}
			break;
		}
		case 4: {
			System.out.println("请输入学号：");
			String id = scanner.next();
//			class RowMapper implements IRowMapper {

//				public void rowMapper(ResultSet resultSet) {
//					if (DBUtil.exist("select * from user where id=?", id)) {
//						System.out.println(id);
//					} else {
//						System.out.println("学号为" + id + "同学不存在");
//					}
//					try {
//						if(resultSet.next()) {
//							String na=resultSet.getString("name");
//							String ad=resultSet.getString("address");
//							System.out.println("id="+id+",name="+na+",ad="+ad);
//						}else {
//							System.out.println("不存在");
//						}
//					} catch (SQLException e) {
//						e.printStackTrace();
//					}
//				}
//			}/////下面简写代码，效果同上方法
			DBUtil.select("select *from user where id=?", (ResultSet resultSet)->{
				try {
					if(resultSet.next()) {
						String na=resultSet.getString("name");
						String ad=resultSet.getString("address");
						System.out.println("id="+id+",name="+na+",ad="+ad);
					}else {
						System.out.println("不存在");
					}
				} catch (SQLException e) {
					e.printStackTrace();
				}
			},id);
			break;
		}
		default: {
			System.out.println("I'm Sorry,there is not the " + option + "option,please try again.");
			}
		}
	}
}