How Do I Insert system time Into Ms Access Using Java?

Question

I have just created a simple Student Registration Form using Java(Netbeans). It has several columns to enter the students' data such as regNo, name, address, etc and a Insert button which inserts the data into the table created in MS Access.It works fine.But I need to store the time when a user fills that form.It means when a user fills that form, the system time should be captured and stored in the table for each entry(each tuple). So I want to know how to get the system time and insert into MS Access database.I found the following code.But I don't know how to pass the time captured by the code to the database.I have already created the field for enter the time in the database.

Calendar cal = Calendar.getInstance();
java.util.Date currentTime = cal.getTime();

This is the code I wrote to pass time to the table.....

ps = con.prepareStatement("insert into RegInfo(RegNo,StudName,Address,"
               + "Telephone,Stream,RegDate,Time) values(?,?,?,?,?,?,?)");
ps.setLong(6,currentTime.getTime());

I used your code Razvan. It is working really good but it doesn't insert the Time into the table......("System.out.println" is working properly).....

 final String t1 = "hh:mm:ss";
 final DateFormat df = new SimpleDateFormat(t1);
 final String formattedTime = df.format(new java.util.Date());
 ps.setString(7, formattedTime);
 System.out.println("formattedTime "+formattedTime);

SQL is a computer language for working with sets of facts and the relationships between them. Relational database programs, such as Microsoft Office Access, use SQL to work with data. — Ravi Perera, May 15 '15 at 09:37
MySQL is a type of Database, like MS Access, MS SQL, PostgreSQL, H2, DB2 ... hence the question — MadProgrammer, May 15 '15 at 09:41
I used ODBC. Is there any other way to connect to MS Access database rather using MySql commands. — Ravi Perera, May 15 '15 at 13:06
You're misunderstanding, mysql is a database, sql, as you've stated, is standard query language, they are different. There is a JDBC driver available for direct access, but you'd still need to use sql — MadProgrammer, May 15 '15 at 20:33
can't MS Access database be accessed by sql commands with ODBC??? — Ravi Perera, May 18 '15 at 09:47
Yes, ODBC is just a common level driver that facilitates the connection. — MadProgrammer, May 18 '15 at 10:36

score 1 · Answer 1 · edited May 23 '17 at 11:58

You can simply use the Now() function in your INSERT query:

try (Connection conn = DriverManager.getConnection(connStr)) {
    String sql;
    sql = "INSERT INTO RegInfo (RegNo, StudName, Address, Telephone, Stream, RegDateTime) " +
            "VALUES (?, ?, ?, ?, ?, Now())";
    try (PreparedStatement ps = conn.prepareStatement(sql)) {
        ps.setInt(1, 3);
        ps.setString(2, "Gord");
        ps.setString(3, "123 Main St");
        ps.setString(4, "416-555-1212");
        ps.setString(5, "Standard");
        ps.executeUpdate();
    }
} catch (Exception e) {
    e.printStackTrace(System.err);
}

That will work for both JDBC-ODBC (obsolete, removed from Java 8) and UCanAccess (more info here).

Note that Date/Time columns in Access always have both a Date and Time component, so you don't need to maintain separate columns for RegDate and Time.

Thanks a lot my dear.It really works.It really helped me.Thanks a lot Thompson..................... — Ravi Perera, May 15 '15 at 16:25

score 0 · Answer 2 · answered May 14 '15 at 21:52

0

The generic form could be :

    final String DB_DATE_FORMAT = "MM/dd/YYYY"; //not sure about this, modify to fit your Access date format
    final SimpleDateFormat formatter = new SimpleDateFormat(DB_DATE_FORMAT);
    final String formattedDate = formatter.format(new Date());

answered May 14 '15 at 21:52

Razvan Manolescu

404
2
10

Why not just use java.sql.Date or java.sql.Timestamp? – MadProgrammer May 14 '15 at 21:59
I used your code Razvan. It is working really good but it doesn't insert the Time into the table......("System.out.println" is working properly).....code is given at the top of the page....... – Ravi Perera May 15 '15 at 13:26

score 0 · Answer 3 · answered May 14 '15 at 22:07

0

your time is not the first column in the insert statement it is number 6 so just change your ps parameter as ps.setLong(6,currentTime.getTime());

answered May 14 '15 at 22:07

Alaa Abuzaghleh

1,003
6
11

How Do I Insert system time Into Ms Access Using Java?

3 Answers3