int iFinish = ((Integer)map.get(”finish”)).intValue();

byte iFinish = ((Integer)map.get(”finish”)).byteValue();

Finally, I find the root cause of the problem from MySQL Reference Manual:

When I change my code like following,

Or change the field width to 2 (greater than 1), and use the code below:

My jsp page works fine.

<script type=”text/javascript”>
function getCities() {
    var countryid = thisForm.countryid.value;
   
    // Create an instance of the XML HTTP Request object
    var xmlHttp = new ActiveXObject( “Microsoft.XMLHTTP” );
 
    // Prepare the XMLHTTP object for a HTTP POST
    var sURL = “search.jsp?countryid=” + countryid;
    xmlHttp.open( “POST”, sURL, false );

    // Execute the request
    xmlHttp.send(null);
   
    // responseText contains HTML code of select element
    cityContainer.innerHTML = xmlHttp.responseText;
   
    // delete XML HTTP Request object
    delete xmlHttp;
}
</script>

…

<select name=”countryid” style=”width:20%” onchange=”getCities()”>
    <option value=”1″>America</option>
    <option value=”2″>England</option>
    …
</select>

<div id=”cityContainer”">
   <select name=”cityid” style=”width: 20%”></select>
</div>

<%@ page import=”java.util.*”%>
<jsp:useBean id=”city” class=”com.esurfer.DemoApp.City”/>
<select name=”cityid” style=”width: 20%”>
<%
int countryid = 0;
String sCountryId = request.getParameter(”countryid”);
if (sCountryId != null) {
    countryid = Integer.parseInt(sCountryId);
}
city.setCountryid(countryid);
Iterator iterCities = city.getCities().iterator();
while (iterCities.hasNext()) {
    Map map = (Map)iterCities.next();%>
    <option value=”<%=map.get(”cityid”)%>”><%=map.get(”cityname”)%></option><%
}
%>
</select>

Java Plug-in Fatal Error:

The Java Runtime Environment cannot be loaded from <\bin\server\jvm.dll>

C:\Documents and Settings\<user name>\Application Data\Sun

public class DBConn {
    public static Connection getConnection() {
     Connection conn = null;
     try {
            Context initCtx = new InitialContext();
            DataSource ds =(DataSource)initCtx.lookup(”java:comp/env/jdbc/TestDB”);
            // or
            // Context envContext = (Context)initCtx.lookup(”java:comp/env”);
            // DataSource ds = (DataSource) envContext.lookup(”jdbc/TestDB”);
            try {
                conn = ds.getConnection();
            } catch (SQLException e1) {
                System.out.println(”Get Connection Failed!”);
            }
        } catch (NamingException e) {
            System.out.println(”Get Connection Failed!”);
        }
     return conn;
 }
}

public class DBConn {
    private static String dbUserName = “root”;
 private static String dbPassword = “secret”;
 private static String connectionURL = “jdbc:mysql://localhost:3306/demodb?autoReconnect=true”;
 private static String driverName = “com.mysql.jdbc.Driver”;
    public static Connection getConnection() {
     Connection conn = null;
     try {
         Class.forName(driverName).newInstance(); //Load Database Driver
         conn = DriverManager.getConnection(connectionURL, dbUserName, dbPassword);
        } catch (Exception e) {
            System.out.println(”Get Connection Failed!”);
        }
     return conn;
 }
}

public Vector getUserInfo() {
    Vector vector = new Vector();
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
 String sql = “SELECT userid, username FROM userinfo;
 try {
        conn = DBConn.getConnection();
        stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        rs = stmt.executeQuery(sql);
        while (rs.next()) {
            UserInfo user = new UserInfo();
            user.setUserId(rs.getInt(1));
            user.setUserName(rs.getString(2));
            vector.add(user);
        }
       
        rs.close();
        rs = null;
       
        stmt.close();
        stmt = null;
       
        conn.close();
        conn = null;
    } catch (Exception e) {
        System.out.println(”Fetch Record(s) Error!”);
    } finally {
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                System.out.println(”Cannot close ResultSet” + e);
            }
            rs = null;
        }
        if (stmt != null) {
            try {
                stmt.close();
            } catch (SQLException e) {
                System.out.println(”Cannot close Statement” + e);
            }
            stmt = null;
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                System.out.println(”Cannot close Connection” + e);
            }
            conn = null;
        }
    }
 return vector;
}

public static File getFileFromInputStream(String fileName) {
ClassLoader cl = Thread.currentThread().getContextClassLoader();
URL url = cl.getResource(fileName);
if (url != null) {
File file = new File(url.getFile());
return file;
} else {
return null;
}
}

<?xml version=”1.0″ encoding=”ISO-8859-1″?>
<proxool>
    <alias>myPool</alias>
    <driver-url>jdbc:mysql://localhost:3306/demodb</driver-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <driver-properties>
      <property name=”user” value=”root”/>
      <property name=”password” value=”secret”/>
    </driver-properties>
    <test-before-use>true</test-before-use>
    <maximum-connection-lifetime>60000</maximum-connection-lifetime>
    <prototype-count>5</prototype-count> 
    <maximum-connection-count>50</maximum-connection-count>
    <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>

<servlet>
  <servlet-name>ServletConfigurator</servlet-name>
  <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
  <init-param>
    <param-name>xmlFile</param-name>
    <param-value>WEB-INF/proxool.xml</param-value>
  </init-param>
  <load-on-startup>1</load-on-startup>
</servlet>

jdbc-0.proxool.alias=myPool
jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver
jdbc-0.proxool.driver-url=jdbc:mysql://localhost:3306/demodb
jdbc-0.user=root
jdbc-0.password=secret

jdbc-0.proxool.maximum-connection-count=40
jdbc-0.proxool.prototype-count=4

jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
jdbc-0.proxool.verbose=true
jdbc-0.proxool.statistics=10s,1m,1d
jdbc-0.proxool.statistics-log-level=DEBUG

<servlet>
  <servlet-name>ServletConfigurator</servlet-name>
  <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
  <init-param>
    <param-name>propertyFile</param-name>
    <param-value>WEB-INF/proxool.properties</param-value>
  </init-param>
  <load-on-startup>1</load-on-startup>
</servlet> 

package com.esurfer.common;

import java.sql.*;

public class DBConn {
    public static Connection getConnection() {
       Connection conn = null;
       try {
            conn = DriverManager.getConnection(”proxool.myPool”);
       } catch (Exception e) {
            System.out.println(”Get Connection Failed!” + e);
       }
      return conn;
    }
}

Connection conn = DBConn.getConnection();
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);

<load-on-startup>1</load-on-startup>

package com.esurfer.common;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Hashtable;
import java.util.Vector;

import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;

public class DBConn {
    public static Connection getConnection() {
        Connection conn = null;
        try {
               Context initCtx = new InitialContext();
               DataSource ds =(DataSource)initCtx.lookup(”java:comp/env/jdbc/myDB”);
               try {
                   conn = ds.getConnection();
               } catch (SQLException e1) {
                   System.out.println(”Get Connection Failed!” + e1);
               }
           } catch (NamingException e) {
               System.out.println(”Get Connection Failed!” + e);
           }
        return conn;
    }
   
    public static ArrayList searchA(String sql) {
        ArrayList result = null;
        Connection conn  = null;
        Statement stmt   = null;
        ResultSet rs     = null;
        try {
            // Fetch a connection from pool
            conn = getConnection();
           
            // Create a scrollable result set
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
            rs = stmt.executeQuery(sql);
           
            // Move to the end of the result set
            rs.last();
           
            // Get the row number of the last row which is also the row count
            int rowCount = rs.getRow();
           
            rs.beforeFirst();
            if (rowCount != 0) {
                result = new ArrayList(rowCount);
                ResultSetMetaData rsmd = rs.getMetaData();
                int cols = rsmd.getColumnCount();
                int iIndex = 0;
                while (rs.next()) {
                    Hashtable ht = new Hashtable();
                 for (int i = 1; i <= cols; i++) {
                     String sTemp = rs.getString(i);
                     if (sTemp == null) sTemp = “”;
                     sTemp = sTemp.trim();
                     ht.put(rsmd.getColumnName(i), sTemp);
                 }
                 result.add(iIndex, ht);
                 iIndex++;
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
            if (stmt != null) {
                try {
                    stmt.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
                stmt = null;
            }
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
                conn = null;
            }
        }
        return result;
    }
   
    public static ArrayList searchA1(String sql) {
        ArrayList result = new ArrayList();
        Connection conn  = null;
        Statement stmt   = null;
        ResultSet rs     = null;
        try {
            // Fetch a connection from pool
            conn = getConnection();
           
            // Create a scrollable result set
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
            rs = stmt.executeQuery(sql);
           
            ResultSetMetaData rsmd = rs.getMetaData();
            int cols = rsmd.getColumnCount();
            //int iIndex = 0;
            while (rs.next()) {
                Hashtable ht = new Hashtable();
                for (int i = 1; i <= cols; i++) {
                    String sTemp = rs.getString(i);
                    if (sTemp == null) sTemp = “”;
                    sTemp = sTemp.trim();
                    ht.put(rsmd.getColumnName(i), sTemp);
                }
                result.add(ht);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
            if (stmt != null) {
                try {
                    stmt.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
                stmt = null;
            }
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
                conn = null;
            }
        }
        return result;
    }
   
    public static Vector searchV(String sql) {
        Vector result = null;
        Connection conn  = null;
        Statement stmt   = null;
        ResultSet rs     = null;
        try {
            // Fetch a connection from pool
            conn = getConnection();
           
            // Create a scrollable result set
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
            rs = stmt.executeQuery(sql);
           
            // Move to the end of the result set
            rs.last();
           
            // Get the row number of the last row which is also the row count
            int rowCount = rs.getRow();
           
            rs.beforeFirst();
            if (rowCount != 0) {
                result = new Vector(rowCount);
                ResultSetMetaData rsmd = rs.getMetaData();
                int cols = rsmd.getColumnCount();
                int iIndex = 0;
                while (rs.next()) {
                    Hashtable ht = new Hashtable();
                 for (int i = 1; i <= cols; i++) {
                     String sTemp = rs.getString(i);
                     if (sTemp == null) sTemp = “”;
                     sTemp = sTemp.trim();
                     ht.put(rsmd.getColumnName(i), sTemp);
                 }
                 result.add(iIndex, ht);
                 iIndex++;
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
            if (stmt != null) {
                try {
                    stmt.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
                stmt = null;
            }
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
                conn = null;
            }
        }
        return result;
    }
   
    public static Vector searchV1(String sql) {
        Vector result = new Vector();
        Connection conn  = null;
        Statement stmt   = null;
        ResultSet rs     = null;
        try {
            // Fetch a connection from pool
            conn = getConnection();
           
            // Create a scrollable result set
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
            rs = stmt.executeQuery(sql);
           
            ResultSetMetaData rsmd = rs.getMetaData();
            int cols = rsmd.getColumnCount();
            //int iIndex = 0;
            while (rs.next()) {
                Hashtable ht = new Hashtable();
                for (int i = 1; i <= cols; i++) {
                    String sTemp = rs.getString(i);
                    if (sTemp == null) sTemp = “”;
                    sTemp = sTemp.trim();
                    ht.put(rsmd.getColumnName(i), sTemp);
                }
                result.add(ht);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
            if (stmt != null) {
                try {
                    stmt.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
                stmt = null;
            }
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
                conn = null;
            }
        }
        return result;
    }
}

<%@ page contentType=”text/html;charset=GBK”%>
<%@ page import= “java.util.*, com.esurfer.common.DBConn”%>
<%
System.out.println(”ArrayList with initial capacity set:”);
for (int i = 0; i < 100; i++) {
    long lBegin = System.currentTimeMillis();
    ArrayList result = DBConn.searchA(”SELECT * FROM z_pz01″);
    System.out.println(System.currentTimeMillis() - lBegin);
}
%>

<%@ page contentType=”text/html;charset=GBK”%>
<%@ page import= “java.util.*, com.esurfer.common.DBConn”%>
<%
System.out.println(”ArrayList without setting initial capacity:”);
for (int i = 0; i < 100; i++) {
    long lBegin1 = System.currentTimeMillis();
    ArrayList result1 = DBConn.searchA1(”SELECT * FROM z_pz01″);
    System.out.println(System.currentTimeMillis() - lBegin1);
}
%>

<%@ page contentType=”text/html;charset=GBK”%>
<%@ page import= “java.util.*, com.esurfer.common.DBConn”%>
<%
System.out.println(”Vector with initial capacity set:”);
for (int i = 0; i < 100; i++) {
    long lBegin = System.currentTimeMillis();
    Vector vector = DBConn.searchV(”SELECT * FROM z_pz01″);
    System.out.println(System.currentTimeMillis() - lBegin);
}
%>

<%@ page contentType=”text/html;charset=GBK”%>
<%@ page import= “java.util.*, com.esurfer.common.DBConn”%>
<%
System.out.println(”Vector without setting initial capacity:”);
for (int i = 0; i < 100; i++) {
    long lBegin = System.currentTimeMillis();
    Vector vector = DBConn.searchV1(”SELECT * FROM z_pz01″);
    System.out.println(System.currentTimeMillis() - lBegin);
}
%>

String sDBServer = “ibmserver”;
// String sDBServer = “server”;    <– I’ve modified this line, you know, it will not work for ever!

native2ascii -encoding gb2312 messages_zh.properties messages_zh_CN.properties

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN”
        “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<%@ page contentType=”text/html” %>
<%@ taglib prefix=”tab” uri=”http://ditchnet.org/jsp-tabs-taglib” %>

<html xmlns=”http://www.w3.org/1999/xhtml” xml:lang=”en” lang=”en”>

 
<head>
    <tab:tabConfig />
</head>
 
<body>
 
 
<tab:tabContainer id=”data-collect-container”>

 <tab:tabPane id=”computer” tabTitle=”Computer”>
      // some form fields here for computer
 </tab:tabPane>

 <tab:tabPane id=”software” tabTitle=”Software”>
      // some form fields here for software
 </tab:tabPane>

</tab:tabContainer>
 
</body> 
 
</html>