利用JDBC实现学生管理系统

Main.java——(学生管理系统代码实现)

1、添加学生信息

Scanner scanner = new Scanner(System.in);
		int option  = scanner.nextInt();
		switch (option) {
   
			case 1:{
   
				System.out.println("请输入学号");
				String id = scanner.next();
				String sql1 = "select id from student where id='"+id+"' ";
				if(new DBLink().exist(sql1)) {
   
					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();
				String sql2="insert into student(id,name,mobile,address) values ('"+id+"','"+name+"','"+mobile+"','"+address+"') ";
				if(new DBLink().update(sql2)) {
   
					System.out.println("添加成功");
				}
				System.out.println("添加失败");
				break;
			}

2、修改学生信息

case 2:{
   
				System.out.println("请输入学号");
				String id = scanner.next();
				String sql1 = "select id from student where id='"+id+"' ";
				if(new DBLink().exist(sql1)) {
   
					System.out.println("请输入新姓名");
					String name = scanner.next();
					System.out.println("请输入新地址");
					String address = scanner.next();
					String sql2 = "update student set name = '"+name+"'，address = '"+address+"' where id = '"+id+"'";
					System.out.println("修改成功");
					return;
				}
				System.out.println("学号不存在，修改失败");
				break;
			}

3、查询学生信息

case 3:{
   
				System.out.println("请输入学号");
				String id = scanner.next();
				String sql1 = "select id from student where id='"+id+"' ";
				if(new DBLink().exist(sql1)) {
   
					class RowMapper implements IRowMapper{
   
						@Override
						public void IRowMapper(ResultSet rs) {
   
							try {
   
								if(rs.next()) {
   
									String id = rs.getString("id");
									String name = rs.getString("name");
									String mobile = rs.getString("mobile");
									String address = rs.getString("address");
									System.out.println(id+','+name+','+mobile+','+address);
								}
							} catch (SQLException e) {
   
								e.printStackTrace();
							}
						}	
					}
					String sql2 = "select id,name,mobile,address from student where id='"+id+"'"