谁有在struts结构中使用action操作数据库的例子 ？

Question

参考
 String sql = "SELECT PWP_SRIL, WBS_SRIL, PWP_T_KND, PWP_T_DES, PWP_S_BL, PWP_T_BL, PWP_EFFT,PWP_ANNEX FROM PJCT_WPLN WHERE PJCT_SRIL = ? AND DD_SRIL = ? ";
        try
        {
            PreparedStatement preparedStatement = conn.prepareStatement(sql.
                toString());
            preparedStatement.setInt(1, pjctSril);
            preparedStatement.setInt(2, weekSril);
            result = preparedStatement.executeQuery();
            while (result.next())
            {
                pjctWPlnVO = new PjctWPlnVO();
                pjctWPlnVO.setPjctWeekPlnSril(result.getString(1));
                pjctWPlnVO.setWeekBSSril(result.getString(2));
                pjctWPlnVO.setPjctWeekPlnStartDate(result.getString(3));
                pjctWPlnVO.setPjctWeekPlnTaskDes(result.getString(4));
                pjctWPlnVO.setPjctWeekPlnStartDate(result.getString(5));
                pjctWPlnVO.setPjctWeekPlnFinishDate(result.getString(6));
                pjctWPlnVO.setPjctWeekPlnEfft(result.getString(7));
                pjctWPlnVO.setPjctWeekPlnAnnex(result.getString(8));
                list.add(pjctWPlnVO);
            }
            return list;
        }
        catch (SQLException ex)
        {
            throw new DataAccessException(
                //,ex);
        }
        finally
        {
            try
            {
                if (result != null)
                    result.close();
                if (conn != null)
                    conn.close();
            }
            catch (SQLException e)
            {
                log.debug("//");
            }
        }