TESTCONNECT.jsp 1.58 KB
Newer Older
Thitichaipun Wutthisak committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
<%@ 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>");
	
	}
	
%>