<Realm className="org.apache.catalina.realm.JDBCRealm"

       driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
   connectionURL="jdbc:sqlserver://DESKTOP-ND3EINKSQLEXPRESS;databaseName=HRSystem;integratedSecurity=true"
       userTable="HR.users" userNameCol="user_name" userCredCol="user_pass"
   userRoleTable="HR.user_roles" roleNameCol="role_name"/>

<display-name>SecurityConstraint</display-name>

    <web-resource-collection>
        <web-resource-name>HRPmain</web-resource-name>
        <url-pattern>/HRPmain.jsp</url-pattern>
    </web-resource-collection>

    <auth-constraint>
        <role-name>HRPersonnel</role-name>
    </auth-constraint>

    <user-data-constraint>
        <transport-guarantee>CONFIDENTIAL</transport-guarantee>
    </user-data-constraint>

</security-constraint>


<login-config>
    <auth-method> FORM</auth-method>
    <realm-name>org.apache.catalina.realm.JDBCRealm</realm-name>
    <form-login-config>
        <form-login-page>/login2.xhtml</form-login-page>
        <form-error-page>/error.xhtml</form-error-page>
    </form-login-config>
</login-config>

<security-role>
    <role-name>HRPersonnel</role-name>
</security-role>

static{
            try{
                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                con = DriverManager.getConnection("jdbc:sqlserver://DESKTOP-ND3EINK\SQLEXPRESS;databaseName=HRSystem;integratedSecurity=true");


            }
 catch (Exception e){

        e.printStackTrace();
    }
}