示例

public class BpAllBadThingsServletsV1a extends HttpServlet {implements SingleThreadModel{
private int numberOfRows = 0;
private javax.sql.DataSource ds = null;
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Connection conn = null;
RersultSer rs = null;
PreparedStatement pStmt = null;
int startingRows;

try {

startingRows = numberOfRows;
String employeeInformation = null;
conn = ds.getConnection("db2admin", "db2admin");
pStmt = conn.prepareStatement ("select * from db2admin.employee");
rs = pstmt.executeQuery();

解决方案
不要实现 javax.servlet.SingleThreadModel 接口。

public class BpAllBadThingsServletsV1a extends HttpServlet {{
private int numberOfRows = 0;
private javax.sql.DataSource ds = null;
private Object lockObject = new Object();
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Connection conn = null;
RersultSer rs = null;
PreparedStatement pStmt = null;
int startingRows;

try {
String employeeInformation = null;
conn = ds.getConnection("db2admin", "db2admin");
pStmt = conn.prepareStatement ("select * from db2admin.employee");
rs = pstmt.executeQuery();