数据库实现学生管理系统

 主体

package com.zzu.main;

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

import com.zzu.tool.db.DBLink;
import com.zzu.tool.db.IRowMapper;

public class Main {
	private static DBLink db = new DBLink();
	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();
				String sql = "select id from student where id = '"+id+"'";
				if(db.exist(sql)) {
					System.out.println("学号已存在！");
					return;
				}
				System.out.println("请输入姓名：");
				String name = scanner.next();
				System.out.println("请输入手机号：");
				String mobile = scanner.next();
				System.out.println("请输入地址：");
				String address = scanner.next();
				sql ="insert into student (id,name,mobile,address) values ('"+id+"','"+name+"','"+mobile+"','"+address+"')";
				if(db.update(sql)) {
					System.out.println("添加成功");
					return;
				}
				System.out.println("添加失败");
				break;
			}
			case 2:{
				System.out.println("请输入学号：");
				String id = scanner.next();
				String sql = "select id from student where id = '"+id+"'";
				if(db.exist(sql)) {
				sql = "delete from student where id = '"+id+"'";
				if(db.update(sql)) {
					System.out.println("删除成功");
					return;