TESTCONNECT0.jsp 627 Bytes
Newer Older
Thitichaipun Wutthisak committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.*"%>
<%
  //String  url =  "jdbc:mysql://localhost/testDB?user=root&password=1234";
  String url ="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=EW;user=myhradmin;password=systemadmin";
  String  sql = "select * from muser";
  //Class.forName("org.gjt.mm.mysql.Driver");
  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  Connection conn = DriverManager.getConnection(url);
  Statement stmt = conn.createStatement();
  ResultSet rs = stmt.executeQuery(sql);
       while(rs.next()){
    out.print(" >"+rs.getString("empid") + "<br>");
	   }
%>