java 连接sqlitle_SQL Date时间显示

java.sql.Timestamp createTime = rs.getTimestamp("create_time");

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

解决办法 用 ResultSet 中的getTimestamp()方法

往数据库存储的时候可以接收 java.util.Date类型 再用getTime()方法得到代表那个Date对象的long值，再以这个long值 构造一个Timestamp对象 存进数据库中。

从存数据库里取的时候，可以先得到Timestamp用他的getTime()方法得到long值，再以这个long值构造一个 java.util.Date对象，这样就可以对这个Date对象操作了。

例如 new SimpleTimeFormat("yyyyy-MM-dd HH:mm:ss").format()等等

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.Statement;

import java.sql.SQLException;

import java.sql.ResultSet;

import java.util.ArrayList;

import java.util.List;

import java.util.Date;

import java.text.SimpleDateFormat;

public class Test {

public static void main(String[] args) throws SQLException, ClassNotFoundException {

Class.forName("com.mysql.jdbc.Driver");

Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/dayuanit003?charset=utf8", "root", "123456");

Statement statement = conn.createStatement();

String sql = "select age, user_name, sex, c_id, create_time from dy_person;";

ResultSet rs = statement.executeQuery(sql);

// while (rs.next()) {

// int age = rs.getInt(1);

// String username = rs.getString(2);

// String sex = rs.getString(3);

// int countryId = rs.getInt(4);

// System.out.println(age + " " + username + " " + countryId + " " + sex);

// }

List personList = new ArrayList();

while (rs.next()) {

int age = rs.getInt("age");

String username = rs.getNString("user_name");

String sex = rs.getNString("sex");

int countryId = rs.getInt("c_id");

java.sql.Timestamp createTime = rs.getTimestamp("create_time");

Person person = new Person();

person.userName = username;

person.age = age;

person.sex = sex;

person.countryId = countryId;

if (null != createTime) {

person.createTime = new Date(createTime.getTime());

System.out.println(person.createTime);

}

personList.add(person);

}

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

for (Person p : personList) {

System.out.println(p.age + "" + p.userName + " ");

if (null != p.createTime) {

System.out.println(sdf.format(p.createTime));

}

}

String addSql = "insert into dy_person values(\"laoda222\", 100, \"F\", 1009, now())";

int rows = statement.executeUpdate(addSql);

System.out.println(rows);

}

}

import java.util.Date;

public class Person {

public String userName;

public int age;

public String sex;

public int countryId;

public Date createTime;

}