还是不行,好像这段代码有问题: strSQL="insert into book values(request.getParameter("tbxid"),'request.getParameter("tbxBookid")','request.getParameter("tbxTitle")','request.getParameter("tbxPdate")','request.getParameter("tbxAuthor")',request.getParameter("tbxPrice"),'request.getParameter("txtamemo")')'';
哪有啊? strSQL="insert into book values(request.getParameter("tbxid"),'request.getParameter("tbxBookid")','request.getParameter("tbxTitle")','request.getParameter("tbxPdate")','request.getParameter("tbxAuthor")',request.getParameter("tbxPrice"),'request.getParameter("txtamemo")')''; 到最后''然后;就结束了
strSQL="insert into book values(request.getParameter("tbxid"),'request.getParameter("tbxBookid")','request.getParameter("tbxTitle")','request.getParameter("tbxPdate")','request.getParameter("tbxAuthor")',request.getParameter("tbxPrice"),'request.getParameter("txtamemo")')"; 这样也不行啊,急杀我了>>
sql语句哪有这样写的 把request都写进去了,一旦出了问题看的眼花 先用变量把这些值都取出来再写sql语句request.getParameter("tbxPrice"), strSQL="insert into book values("+"request.getParameter("tbxid")"+",'.....
不好意思,打错了 strSQL="insert into book values("+request.getParameter("tbxid")+",'.....
运行是有如下的错误: Unhandled error! You might want to consider having an error page to report such errors more gracefully com.sun.jsp.JspException: Compilation failed:work\%3A80%2F\SQLFrm_jsp_1.java:75: Method setAttribute(java.lang.String, java.lang.String) not found in interface javax.servlet.http.HttpSession. { session.setAttribute("Done",""); ^ work\%3A80%2F\SQLFrm_jsp_1.java:76: Ambiguous class: java.sql.Date and java.util .Date Date Now=new Date(); ^ work\%3A80%2F\SQLFrm_jsp_1.java:76: Ambiguous class: java.sql.Date and java.util .Date Date Now=new Date(); ^ work\%3A80%2F\SQLFrm_jsp_1.java:96: Method getAttribute(java.lang.String) not fo und in interface javax.servlet.http.HttpSession. if(session.getAttribute("Done")!="yes") ^ work\%3A80%2F\SQLFrm_jsp_1.java:105: Method setAttribute(java.lang.String, java. lang.String) not found in interface javax.servlet.http.HttpSession. session.setAttribute("Done","yes"); ^
strSQL="insert into book values(request.getParameter("tbxid"),'request.getParameter("tbxBookid")','request.getParameter("tbxTitle")','request.getParameter("tbxPdate")','request.getParameter("tbxAuthor")',request.getParameter("tbxPrice"),'request.getParameter("txtamemo")')'';
strSQL="insert into book values(request.getParameter("tbxid"),'request.getParameter("tbxBookid")','request.getParameter("tbxTitle")','request.getParameter("tbxPdate")','request.getParameter("tbxAuthor")',request.getParameter("tbxPrice"),'request.getParameter("txtamemo")')'';
到最后''然后;就结束了
这样也不行啊,急杀我了>>
把request都写进去了,一旦出了问题看的眼花
先用变量把这些值都取出来再写sql语句request.getParameter("tbxPrice"),
strSQL="insert into book values("+"request.getParameter("tbxid")"+",'.....
strSQL="insert into book values("+request.getParameter("tbxid")+",'.....
'request.getParameter("tbxBookid")'能这样写吗?把java语句写到sql语句当中,而且里面还有”,
'"+request.getParameter("tbxBookid")+"'如果没有“还真能插进数据库,不过不是你想得到的结果
你会发现数据库里全是
request.getParameter("tbxBookid")这种东西
('"+request.getParameter("tbxid")+"','"+
request.getParameter("tbxbookid")+"','"+
request.getParameter("tbxTitle")+"','"+
request.getParameter("tbxPdate")+"','"+
request.getParameter("tbxauthor")+"',"+
request.getParameter("tbxPrice")+")";
stmt.executeUpdate(strSQL);
还有这段程序是不是有问题:
session.setAttribute("Done","");
Date Now=new Date();
String date=(Now.getYear()+1900)+"/";
date=date+(Now.getMonth()+1)+"/";//这里是不是有问题
date=date+Now.getDate();
int或者integer和string效果是不一样的
Unhandled error! You might want to consider having an error page to report such
errors more gracefully
com.sun.jsp.JspException: Compilation failed:work\%3A80%2F\SQLFrm_jsp_1.java:75:
Method setAttribute(java.lang.String, java.lang.String) not found in interface
javax.servlet.http.HttpSession.
{ session.setAttribute("Done","");
^
work\%3A80%2F\SQLFrm_jsp_1.java:76: Ambiguous class: java.sql.Date and java.util
.Date
Date Now=new Date();
^
work\%3A80%2F\SQLFrm_jsp_1.java:76: Ambiguous class: java.sql.Date and java.util
.Date
Date Now=new Date();
^
work\%3A80%2F\SQLFrm_jsp_1.java:96: Method getAttribute(java.lang.String) not fo
und in interface javax.servlet.http.HttpSession.
if(session.getAttribute("Done")!="yes")
^
work\%3A80%2F\SQLFrm_jsp_1.java:105: Method setAttribute(java.lang.String, java.
lang.String) not found in interface javax.servlet.http.HttpSession.
session.setAttribute("Done","yes");
^
这个session的用法,jsp中有这么用的,看你的服务器是什么,
而且session,getAttribute("Done")返回的是个Object,你必须强制转换成String的