<%@page import="java.sql.*,java.util.*"%>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
PreparedStatement pstmt = conn.prepareStatement("insert into myDate(id, myDate) values(?, ?)");
pstmt.setInt(1, 32);
java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());
pstmt.setDate(2, sqlDate);
pstmt.executeUpdate();
out.println("Date is successfully inserted");
}
catch(Exception e){
System.out.println(e);
}
%>
|