什么问题？怎么解决？

显示全部楼层 · 2007-10-20 08:38:44

org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 41 in the jsp file: /insert.jsp
Generated servlet error:
[javac] Compiling 1 source file
G:\Tomcat 4.1\work\Standalone\localhost\myapp\insert_jsp.java:87: unclosed character literal
('"+StudentID+"','"+Last+"','"+First+"','"+Street+"','"+City+"','"+State+"','"+Zip+"','"+StartTeam+"',to_date('"+BirthDay+"','"dd-mm-yyyy"'),'"+FacultyID+"','"+MajordID+"','"+phone+"')";
^

An error occurred at line: 41 in the jsp file: /insert.jsp
Generated servlet error:
G:\Tomcat 4.1\work\Standalone\localhost\myapp\insert_jsp.java:87: ')' expected
('"+StudentID+"','"+Last+"','"+First+"','"+Street+"','"+City+"','"+State+"','"+Zip+"','"+StartTeam+"',to_date('"+BirthDay+"','"dd-mm-yyyy"'),'"+FacultyID+"','"+MajordID+"','"+phone+"')";

^
2 errors

千问 · 2007-10-20 08:38:44

最初由 xbyuan 发布
[B]org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 41 in the jsp file: /insert.jsp
Generated servlet error:
[javac] Compiling 1 source file
G:\Tomcat 4.1\work\Standalone\localhost\myapp\insert_jsp.java:87: unclosed character literal
('"+StudentID+"','"+Last+"','"+First+"','"+Street+"','"+City+"','"+State+"','"+Zip+"','"+StartTeam+"',to_date('"+BirthDay+"','"dd-mm-yyyy"'),'"+FacultyID+"','"+MajordID+"','"+phone+"')";
^

An error occurred at line: 41 in the jsp file: /insert.jsp
Generated servlet error:
G:\Tomcat 4.1\work\Standalone\localhost\myapp\insert_jsp.java:87: ')' expected
('"+StudentID+"','"+Last+"','"+First+"','"+Street+"','"+City+"','"+State+"','"+Zip+"','"+StartTeam+"',to_date('"+BirthDay+"','"dd-mm-yyyy"'),'"+FacultyID+"','"+MajordID+"','"+phone+"')";

^
2 errors [/B]
to_date()函数用错啦
to_date('"+BirthDay+"','"dd-mm-yyyy"')改为
to_date('"+BirthDay+"','dd-mm-yyyy')

千问 · 2007-10-20 08:38:44

應該是那段sql 的問題.

千问 · 2007-10-20 08:38:44

'"+BirthDay+"','"dd-mm-yyyy"'引号太多,小心看错……

千问 · 2007-10-20 08:38:44

谢谢了，你们说的方法，我已经试过了，还是不能解决。

千问 · 2007-10-20 08:38:44

代码修改成下面的能插入到数据库里面，可是把235，Name,23,236,8送到数据库里面，不能从网页动态的把数据传到数据库里面。

数据插入

数据插入程序
数据插入成功!

千问 · 2007-10-20 08:38:44

参考的资料
pstmt.setInt(1,235);
pstmt.setString(2,"Name&quot

;
pstmt.setInt(3,23);
pstmt.setInt(4,236);
pstmt.setInt(5,8);
一般是这样写的，怎么能把动态的数据传到数据库里面？能否给个例子？