<%@ 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>");
	   }
%>