客户管理系统（Java）

一、创建数据库表格

1.创建数据库表

create database customers;create table customer(id int primary key auto_increment,   name varchar(30),sex varchar(5), age int,phone varchar(11),email varchar(30));

二、操作数据库

1.创建一个Customer对象

package test2;

public class Customer {
    private int id;
    private String name;
    private String sex;
    private  int age;
    private String phone;
    private String email;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public Customer() {
    }

    public Customer(int id, String name, String sex, int age, String phone, String email) {
        this.id = id;
        this.name = name;
        this.sex = sex;
        this.age = age;
        this.phone = phone;
        this.email = email;
    }

    @Override
    public String toString() {
        return
                "id=" + id +"\n"+
                "姓名='" + name + "\n"+
                "性别sex='" + sex + "\n"+
                "年龄=" + age +
                "手机号='" + phone + "\n"+
                "邮箱='" + email + '\'';
    }
}

2.创建连接mysql的文本信息

建立一个文本文件sql.proparetis，存入mysql连接信息，注意格式这里是文本格式

url=数据库地址
user=数据库用户名
password=数据库密码
drive=com.mysql.jdbc.Driver

2.对数据库增删改操作

1.编写主要方法

package test2;

import org.junit.Test;

import java.io.IOException;
import java.lang.reflect.Field;
import java.sql.*;
import java.util.ArrayList;
import java.util.Enumeration;
import java.util.List;
import java.util.