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