.........................问题是这样滴........................................
myeclipse 中
.html文件中有
.....
<p align= "left "> 1、 您经常购买的编程类图书属于哪一类? </p>
<p align= "left ">
<input name= "type " type= "checkbox " id= "type " value= "kaifa " >
开发手册
<input name= "type " type= "checkbox " id= "type " value= "baili ">
百例
<input name= "type " type= "checkbox " id= "type " value= "jiqiao ">
技巧
<input name= "type " type= "checkbox " id= "type " value= "shili ">
实例集锦
<input name= "type " type= "checkbox " id= "type " value= "jiaocheng ">
教程 </p>
<p align= "left "> 2、 您使用下面哪种编程语言或工具? </p>
<p align= "left ">
<input name= "type2 " type= "checkbox " id= "type2 " value= "VB " >
VB
<input name= "type2 " type= "checkbox " id= "type2 " value= "VC ">
VC++
<input name= "type2 " type= "checkbox " id= "type2 " value= "JAVA ">
JAVA
<input name= "type2 " type= "checkbox " id= "type2 " value= "DELPHI ">
DELPHI
<input name= "type2 " type= "checkbox " id= "type2 " value= "ASP ">
ASP
<input name= "type2 " type= "checkbox " id= "type2 " value= "ASPNET ">
ASP.NET
<input name= "type2 " type= "checkbox " id= "type2 " value= "JSP ">
JSP
<input name= "type2 " type= "checkbox " id= "type2 " value= "OTHER ">
其他 </p>
<p> 3、 您最愿意购买或借阅哪类图书? </p>
<p>
<input name= "type3 " type= "checkbox " id= "type3 " value= "rumen " >
入门类图书
<input name= "type3 " type= "checkbox " id= "type3 " value= "jiangjie ">
讲解+实例
<input name= "type3 " type= "checkbox " id= "type3 " value= "wanquan ">
完全实例
<input name= "type3 " type= "checkbox " id= "type3 " value= "baili ">
百例型
<input name= "type3 " type= "checkbox " id= "type3 " value= "jiqiao ">
技巧类 </p>
</blockquote>
<p align= "center ">
<input type= "submit " name= "aa2 " value= "提交 ">
.........
提交给这个累加
<%
if(type!=null)
{
for(int i=0;i <type.length;i++)
{
String aa=type[i];
try
{
stmt.executeQuery( "update tb_book set "+aa+ "= "+aa+ " + 1 where id=1 ");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
if(type2!=null)
{
for(int i=0;i <type2.length;i++)
{
String aa=type2[i];
try
{
stmt.executeQuery( "update tb_language set "+aa+ "= "+aa+ " + 1 where id=1 ");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
if(type3!=null)
{
for(int i=0;i <type3.length;i++)
{
String aa=type3[i];
try
{
stmt.executeQuery( "update tb_borrowbook set "+aa+ "= "+aa+ " + 1 where id=1 ");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
%>
数据根本无法插入
还有我的.html文件为什么在myeclipse里是乱码 怎么解决呢?
[解决办法]
stmt.executeQuery ??
stmt.executeUpdate!!!