《个人信息管理系统》

需求

1.显示所有
2.添加功能
3.搜索功能
4.删除功能：（ajax）
5.核对电话是否重复（检查）

数据库准备

数据库操作

-- 建库
CREATE DATABASE resumeSys CHARACTER SET utf8;

-- 用库
USE resumeSys;

-- 建表
CREATE TABLE RESUME(
	id INT PRIMARY KEY AUTO_INCREMENT,
	userName VARCHAR(20) NOT NULL,
	sex VARCHAR(20) NOT NULL,
	birth DATE NOT NULL,
	address VARCHAR(20) NOT NULL,
	telephone VARCHAR(20) NOT NULL,
	school VARCHAR(20) NOT NULL,
	`status` INT NOT NULL COMMENT '1公开，0保密'
);

-- 验证
DESC RESUME;

-- 添加数据
INSERT INTO RESUME VALUES(NULL,'username','sex','2011-1-1','addresss','phone','school',0);

-- 查询数据
SELECT * FROM RESUME;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

浏览器的请求示意图

完成bean的创建

package bean;

import java.util.Date;

public class ResumeBean {
    private int id;
    private String userName;
    private String sex;
    private Date birth;
    private String address;
    private String telephone;
    private String school;
    private int status;

    @Override
    public String toString() {
        return "ResumeBean{" +
                "id=" + id +
                ", userName='" + userName + '\'' +
                ", sex='" + sex + '\'' +
                ", birth=" + birth +
                ", address='" + address + '\'' +
                ", school='" + school + '\'' +
                ", status=" + status +
                '}';
    }

    public int getId() {
        return id;
    }

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

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getSex() {
        return sex;
    }

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

    public Date getBirth() {
        return birth;
    }

    public void setBirth(Date birth) {
        this.birth = birth;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }
    public String getTelephone() { return telephone; }

    public void setTelephone(String telephone) { this.telephone = telephone; }


    public String getSchool() {
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72