<%
// define variables
String CLASS="oracle.jdbc.driver.OracleDriver";
String NODE1_AND_DB="jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.1.3)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =RACDB.GLOBAL)))";
String NODE2_AND_DB="jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.1.4)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =RACDB.GLOBAL)))";
String USER="<username>";
String PASSWORD="<password>";
String SQL="select count(*) from tab";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
// check NODE1
try
{
Class.forName(CLASS);
conn = DriverManager.getConnection(NODE1_AND_DB,USER,PASSWORD);
stmt = conn.createStatement();
rs=stmt.executeQuery(SQL);
out.println("<br>");
out.println("172.17.1.3 is OK");
}
catch(SQLException e)
{
out.println("172.17.1.3 is not OK");
}
finally
{
try
{
if(rs != null) rs.close();
if(stmt != null) stmt.close();
if(conn != null) conn.close();
}
catch(SQLException e)
{
out.println("DB close error " + getClass());
}
}
try
{
Class.forName(CLASS);
conn = DriverManager.getConnection(NODE2_AND_DB,USER,PASSWORD);
stmt = conn.createStatement();
rs=stmt.executeQuery(SQL);
out.println("<br>");
out.println("172.17.1.4 is OK");
}
catch(SQLException e)
{
out.println("172.17.1.4 is not OK");
}
finally
{
try
{
if(rs != null) rs.close();
if(stmt != null) stmt.close();
if(conn != null) conn.close();
}
catch(SQLException e)
{
out.println("DB close error " + getClass());
}
}
%>
<%
out.print("1.Local Address: " + request.getLocalAddr() + "<br>");
out.print("2.Local Name: " + request.getLocalName() + "<br>");
out.print("3.Server Name: " + request.getServerName() + "<br>");
out.print("4.Server Port: " + request.getServerPort() + "<br>");
out.print("5.Remote Host: " + request.getRemoteHost() + "<br>");
out.print("6.User Agent: " + request.getHeader("user-agent") + "<br>");
out.print("7.User Agent: " + request.getHeader("referer") + "<br>");
out.print("8.Protocol: " + request.getProtocol() + "<br>");
out.print("9.Method: " + request.getMethod() + "<br>");
out.print("10.Request URI: " + request.getRequestURI() + "<br>");
out.print("11.Servlet Path: " + request.getServletPath()+ "<br>");
out.print("12.Path Info: " + request.getPathInfo() + "<br>");
out.print("13.Real Path: " + request.getRealPath("/")+ "<br>");
%>
LANG="zh_CN.GB18030"
LANGUAGE="zh_CN.GB18030:zh_CN.GB2312:zh_CN"
SUPPORTED="zh_CN.UTF-8:zh_CN:zh:en_US.UTF-8:en_US:en"
SYSFONT="lat0-sun16"
<%
// define variables
String CLASS="com.mysql.jdbc.Driver";
// note: default character set of mysql is gb2312
// version of connectorJ is greater 5.0
String dbString = "jdbc:mysql://localhost/test?user=admin&password=password&useUnicode=true&characterEncoding=gb2312";
String SQL_create_table = "create table test.cn(col1 varchar(10))";
String SQL_insert_cn = "insert into test.cn values('中文')";
String SQL_select_cn = "select * from test.cn";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
// check
try
{
Class.forName(CLASS);
conn = DriverManager.getConnection(dbString);
stmt = conn.createStatement();
stmt.execute(SQL_create_table);
stmt.execute(SQL_insert_cn);
rs = stmt.executeQuery(SQL_select_cn);
while(rs.next())
{
out.println(rs.getString("col1"));
out.println("<br>");
}
}
catch(SQLException e)
{
out.println("DB operation error " + getClass());
}
finally
{
try
{
if(rs != null) rs.close();
if(stmt != null) stmt.close();
if(conn != null) conn.close();
}
catch(SQLException e)
{
out.println("DB close error " + getClass());
}
}
%>