QuestionAsk Questions?
trupti sonar
How to insert System Date & Time in MS-ACCESS using Java?
View Answers
April 30, 2012 at 1:39 PM
import java.sql.*; import java.util.*; import java.text.* class InsertDate{ public static void main(String[] args){ try{ java.util.Date d=new java.util.Date(); SimpleDateFormat sdf=new SimpleDateFormat("yyyy/MM/dd hh:mm:ss"); String st=sdf.format(d); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection("jdbc:odbc:roseindia");
Statement pstmt = conn.createStatement();
String INSERT_RECORD = "insert into person(dob) values('"+st+"')";
pstmt.executeUpdate(INSERT_RECORD);
pstmt.close();
conn.close();
}
catch(Exception e){
e.printStackTrace();
}
} }
April 30, 2012 at 1:39 PM
import java.sql.*;
import java.util.*;
import java.text.*
class InsertDate{
public static void main(String[] args){
try{
java.util.Date d=new java.util.Date();
SimpleDateFormat sdf=new SimpleDateFormat("yyyy/MM/dd hh:mm:ss");
String st=sdf.format(d);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:roseindia");
Statement pstmt = conn.createStatement();
String INSERT_RECORD = "insert into person(dob) values('"+st+"')";
pstmt.executeUpdate(INSERT_RECORD);
pstmt.close();
conn.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
