这是第一个页面
<form name="myform" method="post" action="chktodb.jsp" >
发表次数:<input type="text" name="ID">
主 题:<input type="text" name="title">
简单描述:<input type="text" name="describe">
发帖 人:<input type="text" name="autor">
内 容:<input type="text" name="matter">
<center>
<input type="submit" value="注册">
<input type="reset" value="重置">
</center>
</form>
这是第二个页面
<%
int ID=Integer.parseInt(request.getParameter("ID"));
String title=new String(request.getParameter("title").getBytes("ISO8859_1"),"GBK");
String describe=new String(request.getParameter("describe").getBytes("ISO8859_1"),"GBK");
String autor=new String(request.getParameter("autor").getBytes("ISO8859_1"),"GBK");
String matter=new String(request.getParameter("matter").getBytes("ISO8859_1"),"GBK");
final String CLS="com.mysql.jdbc.Driver";
final String URL="jdbc:mysql://localhost:3306/bbsTest";
final String USER="root";
final String PWD="425680992";
Connection conn = null;
PreparedStatement pStmt = null;
ResultSet rs = null;
try{
Class.forName(CLS);
conn = DriverManager.getConnection(URL, USER, PWD);
String sql = "select * from test where " +
" ID=?";
pStmt = conn.prepareStatement(sql);
pStmt.setInt(1, ID);
rs= pStmt.executeQuery();
if(rs.next()){
err+="<h3>您的发表次数已经存在,请更换次数!</h3>";
valid=false;
}else{
sql="insert into test (ID,title,describe,autor,matter)values("+ID+",'"+title+"','"+describe+"','"+autor+"','"+matter+"')";
pStmt.executeUpdate(sql);
这基本上就是全部的代码了 但是一运行就出现这样的错误:
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near
'describe,autor,matter)values(5,'hj','h','hj','hj')' at line 1
这是怎么回事 我确定我的数据库建立的表正确 里面的数据类型也正确
以mysql为例子给一个代码示例:如下
public class MemberDAO {我就是这样写的啊 不行
追答sql="insert into test (`ID`,`title`,`describe`,`autor`,`matter`) values ("+ID+",'"+title+"','"+describe+"','"+autor+"','"+matter+"')";
本回答被网友采纳