zbb20170922 mysql 保存日期时间格式 datetime

 mysql 保存日期时间格式 datetime

GetIpController 

package com.zbb.controller;

import java.sql.Timestamp;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.zbb.entity.PageView;
import com.zbb.service.face.PageViewService;

@Controller
@RequestMapping("/gi")
public class GetIpController {

    @Autowired
    private PageViewService pageViewService;

    @RequestMapping(value = "/gi")
    public String getRemortIP(HttpServletRequest request) {
        String ipv4Addr = "";
        String header = request.getHeader("x-forwarded-for");
        if (header == null) {
            System.out.println("1");
            ipv4Addr = request.getRemoteAddr();
        } else {
            System.out.println("2");
            ipv4Addr = header;
        }
        System.out.println(ipv4Addr);
        // 保存信息
        
        Date date = new Date();  
        Timestamp timeStamp = new Timestamp(date.getTime());  

        PageView pageView = new PageView();
        pageView.setIpv4(ipv4Addr);
        System.out.println(timeStamp);
        pageView.setMyDate(timeStamp);
        pageViewService.save(pageView);
        return "ui/index";
    }
}

 

PageView 

package com.zbb.entity;

import static javax.persistence.GenerationType.IDENTITY;

import java.sql.Timestamp;
import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
 * PageView entity. @author MyEclipse Persistence Tools
 */
@Entity(name = "page_view")
public class PageView implements java.io.Serializable {

    // Fields

    /**
     * zhaozhen02
     */
    private static final long serialVersionUID = 1L;
    private Integer id;
    private String ipv4;
    private String ipv6;
    private Timestamp myDate;
    private Integer a1;
    private Integer a2;
    private Integer a3;
    private String b1;
    private String b2;
    private String b3;
    private Timestamp c1;
    private Timestamp c2;
    private Timestamp c3;

    // Constructors

    /** default constructor */
    public PageView() {
    }

    /** full constructor */
    public PageView(String ipv4, String ipv6, Timestamp myDate, Integer a1, Integer a2, Integer a3, String b1,
            String b2, String b3, Timestamp c1, Timestamp c2, Timestamp c3) {
        this.ipv4 = ipv4;
        this.ipv6 = ipv6;
        this.myDate = myDate;
        this.a1 = a1;
        this.a2 = a2;
        this.a3 = a3;
        this.b1 = b1;
        this.b2 = b2;
        this.b3 = b3;
        this.c1 = c1;
        this.c2 = c2;
        this.c3 = c3;
    }

    // Property accessors
    @Id
    @GeneratedValue(strategy = IDENTITY)
    @Column(name = "id", unique = true, nullable = false)
    public Integer getId() {
        return this.id;
    }

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

    @Column(name = "ipv4")
    public String getIpv4() {
        return this.ipv4;
    }

    public void setIpv4(String ipv4) {
        this.ipv4 = ipv4;
    }

    @Column(name = "ipv6")
    public String getIpv6() {
        return this.ipv6;
    }

    public void setIpv6(String ipv6) {
        this.ipv6 = ipv6;
    }

    @Column(name = "myDate")
    public Timestamp getMyDate() {
        return this.myDate;
    }

    public void setMyDate(Timestamp myDate) {
        this.myDate = myDate;
    }

    @Column(name = "a1")
    public Integer getA1() {
        return this.a1;
    }

    public void setA1(Integer a1) {
        this.a1 = a1;
    }

    @Column(name = "a2")
    public Integer getA2() {
        return this.a2;
    }

    public void setA2(Integer a2) {
        this.a2 = a2;
    }

    @Column(name = "a3")
    public Integer getA3() {
        return this.a3;
    }

    public void setA3(Integer a3) {
        this.a3 = a3;
    }

    @Column(name = "b1")
    public String getB1() {
        return this.b1;
    }

    public void setB1(String b1) {
        this.b1 = b1;
    }

    @Column(name = "b2")
    public String getB2() {
        return this.b2;
    }

    public void setB2(String b2) {
        this.b2 = b2;
    }

    @Column(name = "b3")
    public String getB3() {
        return this.b3;
    }

    public void setB3(String b3) {
        this.b3 = b3;
    }

    @Column(name = "c1")
    public Timestamp getC1() {
        return this.c1;
    }

    public void setC1(Timestamp c1) {
        this.c1 = c1;
    }

    @Column(name = "c2")
    public Timestamp getC2() {
        return this.c2;
    }

    public void setC2(Timestamp c2) {
        this.c2 = c2;
    }

    @Column(name = "c3")
    public Timestamp getC3() {
        return this.c3;
    }

    public void setC3(Timestamp c3) {
        this.c3 = c3;
    }

}