使用maven工具----实现JDBC学生管理系统

项目结构

Main.java

package com.zzu.client;


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 {
   

	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() {
   
		//DBLink db = new DBLink();
		System.out.println("1添加学生信息");
		System.out.println("2修改学生信息");
		System.out.println("3查询学生信息");//地址传递
		System.out.println("4删除学生信息");//name
		System.out.println("请输入Enter键以继续");
		final Scanner scanner = new Scanner(System.in);
		int option  = scanner.nextInt();
		switch (option) {
   
			case 1:{
   
				System.out.println("添加系统");
				System.out.println("请输入学号");
				String id = scanner.next();
				String sql = "select id from student where id = ?";
				if(new DBLink().exist(sql,id)) {
   
					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 (?,?,?,?)";
				if(new DBLink().update(sql,id, name,mobile,address)) {
   
					System.out.println("添加成功");
					break;
				}
				System.out.println("添加失败");
				break;
			}
			case 2:{
   
				System.out.println("修改系统");
				System.out.println("请输入学号");
				String id = scanner.next();
				String sql = "select id from student where id = ?";
				if(new DBLink(