插入时间值

 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.PreparedStatement;

import java.sql.ResultSetMetaData;


public class InsertDateValue {

	public static void main(String[] args) throws Exception {
		Connection con = getConnection();
		Statement st = con.createStatement();
		
		st.executeUpdate("create table survey(id int , myDate DATE);");
		String INSERT_RECORD = "insert into survey(id,myDate) values(?,?)";
		
		PreparedStatement psmt = con.prepareStatement(INSERT_RECORD);
		psmt.setString(1, "1");
		java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());
		psmt.setDate(2, sqlDate);
		psmt.executeUpdate();
			
		
		ResultSet rs = st.executeQuery("select * from survey");
		
		outputResultSet(rs);
		
		rs.close();
		st.close();
		con.close();
		
	}

	private static void outputResultSet(ResultSet rs) throws SQLException {
		ResultSetMetaData rsmd =  rs.getMetaData();
		int numberOfCount = rsmd.getColumnCount();
		for(int i = 1; i < numberOfCount + 1; i++){
			String columnName = rsmd.getColumnName(i);
			System.out.println(columnName + "    ");
		}
		System.out.println();
		System.out.println("********");
		while(rs.next()){
			for(int i = 1; i < numberOfCount + 1; i++){
				System.out.println(rs.getString(i) + "    " );
			}
		}
	}

	public static Connection getConnection() throws Exception{
		Connection con = null;
		Class.forName("com.mysql.jdbc.Driver");
		con = DriverManager.getConnection("jdbc:mysql://localhost/bookshop","root","");
		return con;
	}
}

id   
myDate   

********
1   
2012-03-09