<%@ page import="java.sql.*"%> <%@ page import="java.lang.*"%> <% /* //String url = "jdbc:mysql://localhost/testDB?user=root&password=1234"; // String url ="jdbc:jtds:sqlserver://it-act-001;DatabaseName=WIN-PAK PRO"; String url ="jdbc:jtds:sqlserver://it-act-002;DatabaseName=biostar"; // String url ="jdbc:odbc:Driver=AccessDoors"; //String sql = "select * from hrviewhistory"; String sql = "select * from view_AccessBCT"; //String user = "HRImport"; //String pass = "matrix5555"; String user = "itSystem"; String pass = "p@ssw0rd"; */ //Class.forName("org.gjt.mm.mysql.Driver"); //Class.forName("net.sourceforge.jtds.jdbc.Driver"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=D:/OEI/bsv5.mdb"; Connection conn = DriverManager.getConnection(url); out.print(" >"+conn); Statement stmt = conn.createStatement(); //ResultSet rs = stmt.executeQuery("select user_no,user_sj,user_card from dt_user where user_sj like '%28/10/2014%' or user_sj like '%28/10/2557%'"); // ResultSet rs = stmt.executeQuery("select user_no,user_sj,user_card from dt_user "); // ResultSet rs = stmt.executeQuery("select user_no,user_sj,user_card from dt_user where user_sj >'2014-10-01'"); ResultSet rs = stmt.executeQuery("select user_no,user_sj,user_card from dt_user where user_sj >=CDate('2014-10-01')"); // ResultSet rs = stmt.executeQuery("select user_no,user_sj,user_card from dt_user "); out.print(" >>>>>>><br>"); while(rs.next()){ out.print(" >"+rs.getString("user_sj") + "<br>"); } %>