Java代码实现班级通讯录系统(连接mysql数据库)
package one;
import java.sql.*;
import java.util.Scanner;
public class AddressBook_Pro {
private static String connect = "jdbc:mysql:///studentinformation";
private static String user = "root";
private static String passward = "root";
private static String driver="com.mysql.cj.jdbc.Driver";
public static void main(String[] args) {
Scanner sc = new Scanner(System.in);
while(true){
welcome();
System.out.println("请输入您的选择:");
int choice = sc.nextInt();
switch (choice){
case 1:
DataBaseAdd();
break;
case 2:
DataBaseDelete();
break;
case 3:
DataBaseChange();
break;
case 4:
DataBaseFindAll();
break;
case 5:
DataBaseFindsingle();
break;
case 6:
System.out.println("谢谢使用!");
System.exit(0);
break;
default:
System.out.println("您输入的信息有误");
break;
}
}
}
public static void welcome(){
System.out.println("***************欢迎来到学生信息管理系统!!****************");
System.out.println("----------1.添加学生通讯录信息--------------");
System.out.println("----------2.删除学生通讯录信息--------------");
System.out.println("----------3.修改学生通讯录信息--------------");
System.out.println("----------4.查询所有学生的通讯录信息---------");
System.out.println("----------5.按学号查询单个学生的通讯录信息----");
System.out.println("----------6.退出-------------------------");
}
public static void DataBaseAdd(){
Scanner sc = new Scanner(System.in);
Connection();
Connection conn = null;
Statement stmt = null;
ResultSet resultSet = null;
try {
String id;
String name;
String qq;
String phone;
String address;
String sql1 = "select * from addressbook";
conn = DriverManager.getConnection(connect, user, passward);
stmt = conn.createStatement();
resultSet = stmt.executeQuery(sql1);
while(true){
resultSet = stmt.executeQuery(sql1);
resultSet.next();
System.out.println("请输入学生学号:");
id = sc.next();
if(resultSet.isAfterLast()!=resultSet.isBeforeFirst()){