<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%
/*
Unlike IIS VBScript, this variable *must* be declared and initialized
before calling the Footer.inc include, even if it's supposed to be
empty.
*/
String strPageName = "";
String strQuery = "Select * From ERPMET_CompanyNames";
%>
MMO Metrics Solution Development - NetCharts Testbed Project - SQL Server Connection Test
SQL Server Connection Test
Below is a query from the ERPMET CompanyNames table in the SMMDev database on SQL-EVT-68.
<%
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" %>