注册 登录
编程论坛 J2EE论坛

如何将JSP页面表中的数据存入数据库?

lewis0323 发布于 2006-10-22 12:13, 561 次点击

<%
if(bean.validate()==true)

{TestBean.OpenConn("university","sa","");
String a=bean.getnumber();
String b=bean.getname();
String c=bean.getsex();
String d=bean.getnianlin();
String e=bean.getjiguan();
String f=bean.getyuanxi();
String sql="insert into student "+"values("+a+","+b+","+c+","+d+","+e+","+f+")";
TestBean.executeUpdate(sql);
%>


aq.execute:No suitable driver
sqlDataBaseBean.executeUpdata[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第一行:'."附近有语法错误
aq.execute:No suitable driver


请问这是什么错误啊?

2 回复
#2
lewis03232006-10-22 12:47

找到错误了 sql values中的数据少了 ' '

#3
y03112006-10-22 13:56
呵呵
1