Class.forName("com.hxtt.sql.access.AccessDriver").newInstance();
String hxtt_constr = "jdbc:access:///" + file.getPath();
hxtt_con = DriverManager.getConnection(hxtt_constr, "njtu", "njtu");
hxtt_statement.execute("insert into qkb(xm,gzdw,csrq,sfz) values('Tong.we', 'GUCAS', '1960-06-18', '1234567890')"); // no bug
// sql(1941-06-18) database (1941-06-17)
hxtt_statement.execute("insert into qkb(xm,gzdw,csrq,sfz) values('Heng.zhao', 'GUCAS', '1941-06-17', '1234567891')"); // have bug
// sql(1922-06-18) database (1922-06-17)
hxtt_statement.execute("insert into qkb(xm,gzdw,csrq,sfz) values('Heng.zhao', 'GUCAS', '1922-06-18', '1234567892')"); // have bug
now I found 1922 and 1941 would fire the bug that stored in database date is less one day.
|