JSP应用开发详解-VOTE程序-案例代码运行修复PATCH

JSP应用开发详解书中，投票程序，更换数据库环境为MySql，导致程序无法运行，先将修改patch提供如下：

数据库环境：MySql

运行效果：

修改代码patch：

diff --git a/WebContent/vote/a/vote.jsp b/WebContent/vote/a/vote.jspindex cb0e684..8941a37 100644--- a/WebContent/vote/a/vote.jsp+++ b/WebContent/vote/a/vote.jsp@@ -1,11 +1,11 @@ <%@ include file="../vote_include.inc"%> <%@ page contentType="text/html; charset=utf-8" language="java" %>-<c:set var="all" value="SELECT 曹操+孙权+刘备+诸葛亮+未确定 as a FROM vote"/>-<c:set var="vote1" value="SELECT 曹操 as c  FROM vote"/>-<c:set var="vote2" value="SELECT 孙权 as c  FROM vote"/>-<c:set var="vote3" value="SELECT 刘备 as c  FROM vote"/>-<c:set var="vote4" value="SELECT 诸葛亮 as c FROM vote"/>-<c:set var="vote5" value="SELECT 未确定 as c FROM vote"/>+<c:set var="all" value="SELECT IFNULL(曹操,0)+IFNULL(孙权,0)+IFNULL(刘备,0)+IFNULL(诸葛亮,0)+IFNULL(未确定,0) as a FROM vote"/>+<c:set var="vote1" value="SELECT IFNULL(曹操,0) as c  FROM vote where id=1"/>+<c:set var="vote2" value="SELECT IFNULL(孙权,0) as c  FROM vote where id=1"/>+<c:set var="vote3" value="SELECT IFNULL(刘备,0) as c  FROM vote where id=1"/>+<c:set var="vote4" value="SELECT IFNULL(诸葛亮,0) as c FROM vote "/>+<c:set var="vote5" value="SELECT ifnull(未确定,0) as c FROM vote where id=1"/> <sql:query sql="${all}" var="queryall" dataSource="${vote}"/>      <c:forEach var="row" items="${queryall.rows}">    @@ -24,7 +24,7 @@     <td width="83%" align="center">得票率</td>   </tr>   <tr>-  <sql:query  var="query" dataSource="${vote}">  +  <sql:query sql = "${vote1}" var="query" dataSource="${vote}">          SELECT 曹操 as c  FROM vote   </sql:query>       <td><a href="vote_do.jsp?id=曹操">曹操 </a></td>@@ -35,7 +35,7 @@    </td>   </tr>   <tr>-     <sql:query  var="query" dataSource="${vote}">  +     <sql:query sql = "${vote4}" var="query" dataSource="${vote}">            SELECT 诸葛亮 as c  FROM vote      </sql:query>       <td><a href="vote_do.jsp?id=诸葛亮">诸葛亮</a></td>@@ -46,7 +46,7 @@      </td>   </tr>   <tr>-  <sql:query  var="query" dataSource="${vote}">  +  <sql:query sql = "${vote3}" var="query" dataSource="${vote}">          SELECT 刘备 as c  FROM vote   </sql:query>       <td><a href="vote_do.jsp?id=刘备">刘备</a></td>@@ -57,7 +57,7 @@      </td>   </tr>   <tr>-  <sql:query  var="query" dataSource="${vote}">  +  <sql:query sql = "${vote2}" var="query" dataSource="${vote}">          SELECT 孙权 as c  FROM vote   </sql:query>       <td><a href="vote_do.jsp?id=孙权">孙权</a></td>@@ -68,7 +68,7 @@      </td>   </tr>   <tr>  -  <sql:query  var="query" dataSource="${vote}">  +  <sql:query sql = "${vote5}" var="query" dataSource="${vote}">          SELECT 未确定 as c  FROM vote   </sql:query>       <td><a href="vote_do.jsp?id=未确定">未确定</a></td>

代码下载：http://download.csdn.net/download/hailushijie/9874752

---

关注我的技术公众号，查看更多优质技术文章推送

微信扫一扫下方二维码即可关注：