Guest User

Untitled

a guest
Feb 3rd, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. package com;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.PreparedStatement;
  6.  
  7. public class DateTimeExample {
  8. public static void main(String args[]){
  9. try{
  10. Class.forName("com.mysql.jdbc.Driver");
  11. Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/demo","root","root");
  12.  
  13. java.util.Date date=new java.util.Date();
  14.  
  15. java.sql.Date sqlDate=new java.sql.Date(date.getTime());
  16. java.sql.Timestamp sqlTime=new java.sql.Timestamp(date.getTime());
  17.  
  18. PreparedStatement ps=con.prepareStatement("insert into record (date,time) values(?,?)");
  19. ps.setDate(1,sqlDate);
  20. ps.setTimestamp(2,sqlTime);
  21. ps.executeUpdate();
  22.  
  23. ps.close();
  24. con.close();
  25. }catch(Exception e){
  26. e.printStackTrace();
  27. }
  28. }
  29. }
Add Comment
Please, Sign In to add comment