<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%
String strFileName = "ProjectsCompletedByProgrammer.jsp";
String strQuery = "Select Programmerbemsid as BemsID, Programmer, " +
"TheCount as [Tasks Completed] From " +
"VIEW_MRDR_Completions";
%>
MMO Metrics Solution Development - MRDR - Projects Complete By Programmer
MRDR - Projects Completed by Programmer
<%
Connection objConn = null;
String url = "jdbc:microsoft:sqlserver://";
String serverName= "SQL-EVT-68";
String portNumber = "49603";
String databaseName= "SMMDev";
String uName = "linksqlid";
String pwd = "linksqlpw";
String selectMethod = "cursor";
String getConnectionUrl = url + serverName + ":" + portNumber + ";databaseName=" + databaseName + ";selectMethod=" + selectMethod + ";";
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
objConn = java.sql.DriverManager.getConnection(getConnectionUrl,uName,pwd);
}
catch(Exception e)
{
e.printStackTrace();
out.println("Couldn't connect: " + e.getMessage() + "");
}
Statement objStmt = objConn.createStatement();
ResultSet objRS = objStmt.executeQuery(strQuery);
ResultSetMetaData objRSMeta = objRS.getMetaData();
int intColCount = objRSMeta.getColumnCount();
out.println("
");
for(int i = 1; i <= intColCount; i++)
{
out.println("| " + objRSMeta.getColumnName(i) + " | ");
}
out.println("
");
while(objRS.next())
{
out.println("");
for(int i = 1; i <= intColCount; i++)
{
out.println("| " + objRS.getObject(i) + " | ");
}
out.println("
");
}
out.println("
");
objRS.close();
objConn.close();
%>
<%@ include file="Footer.inc" %>