MvcExample——数据库设计

mysql 数据库

首先在Mysql数据库建立DATABASE mvcexample
在该数据库下建立TABLE user
user 包含的有 id, username, password, phone, address, reddate。

eclipse项目中Model中类的实现

在com.foot.mvcpro包下创建class.
注意：该类上的每一行注释不可省略，该类中的无参构造方法不可省略，该类中的getter和setter方法可以自动生成，该类中toString方法自动生成。
如果数据库有多个表，则每个表都需要写与之对应的class。

package com.foot.mvcpro.model;

import java.util.Date;
/**
 * 用户类
 * @author footprint
 *
 */
public final class User {
    /**
     * 用户编号
     */
    private int id;
    /**
     * 用户名称
     */
    private String username;
    /**
     * 用户密码
     */
    private String password;
    /**
     * 用户的电话
     */
    private String phone;
    /**
     * 用户的地址
     */
    private String address;
    /**
     * 用户的注册日期
     */
    private Date regDate;

    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 getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public String getPhone() {
        return phone;
    }
    public void setPhone(String phone) {
        this.phone = phone;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
    public Date getRegDate() {
        return regDate;
    }
    public void setRegDate(Date regDate) {
        this.regDate = regDate;
    }

    public User() {
        super();
    }

    public User(int id, String username, String password, String phone, String address, Date regDate) {
        super();
        this.id = id;
        this.username = username;
        this.password = password;
        this.phone = phone;
        this.address = address;
        this.regDate = regDate;
    }

    @Override
    public String toString() {
        return "User [id=" + id + ", username=" + username + ", password=" + password + ", phone=" + phone
                + ", address=" + address + ", regDate=" + regDate + "]";
    }




}