花落谁家，你作主！	盛大widget设计大赛英雄榜

jsp与数据库,字符的定义问题

楼主yipingdeng（日立新）2003-11-01 16:24:01 在 Java / Web 开发提问

String sql="insert custom(uid,nickname)
values(\'"+uid+"\',\'"+nickname"\')";
对不对？但我编译的时候，说字符报错！问题点数：50、回复次数：12Top

1 楼rainshow（要学习的是那样多，时间却是那么的少）回复于 2003-11-01 16:27:28 得分 40

String sql="insert into custom(uid,nickname) values('"+uid+"','"+nickname+"')"
很遗憾的说，错误很多！Top

2 楼rainshow（要学习的是那样多，时间却是那么的少）回复于 2003-11-01 16:32:40 得分 0

String sql="insert custom(uid,nickname) values(\'"+uid+"\',\'"+nickname"\')";
^^^ ^^^
没表名缺少+号

Top

3 楼lynx1111（任我行:一个PLMM看着就兴奋的男人）回复于 2003-11-01 16:33:51 得分 0

直接写引号就行了，不用加\Top

4 楼rainshow（要学习的是那样多，时间却是那么的少）回复于 2003-11-01 16:34:45 得分 0

我来灌水，哈

忘记写into了，没必要加“\”，当然加了也没错，关键是+号没写，这是报错的原因Top

5 楼ydr2002（★★★★★）回复于 2003-11-01 16:34:51 得分 0

nod
还缺个分号Top

6 楼lynx1111（任我行:一个PLMM看着就兴奋的男人）回复于 2003-11-01 16:36:33 得分 10

至少SQL SERVER 可以不写intoTop

7 楼yipingdeng（日立新）回复于 2003-11-01 18:50:38 得分 0

原代码
<html>
<head>
<title>修改成功 </title>
<meta http-equiv="content-Type" content="text/html;charset=gb2312">
</head>
<style type="text/css">

</style>
<body bgcolor="#FFFFFF" text="#000000">
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="db" scope="page" class="opendb.opendb"/>
<%
String uid=request.getParameter("uid");
String nickname=request.getParameter("nickname");
byte[] tmpbyte=nickname.getBytes("ISO8859_1");
nickname=new String(tmpbyte);
String gender=request.getParameter("gender");
byte[] tmpbyte=gender.getBytes("ISO8859_1");
gender=new String(tmpbyte);
String pwd=request.getParameter("pwd");
String realname=request.getParameter("realname");
byte[] tmpbyte=realname.getBytes("ISO8859_1");
realname=new String(tmpbyte);
String career=request.getParameter("career");
byte[] tmpbyte=career.getBytes("ISO8859_1");
career=new String(tmpbyte);
String address=request.getParameter("address");
byte[] tmpbyte=address.getBytes("ISO8859_1");
address=new String(tmpbyte);
String email=request.getParameter("email");
String tel=request.getParameter("tel");
String month=request.getParameter("month");
String year=request.getParameter("year");
String day=request.getParameter("day");
String birth=year+"-"+month+"-"+day;
String sql="insert custom(uid,nickname,gender,pwd,realname,career,address,email,tel,birth)values
(\'"+uid+"\',\'"+nickname+"\',\'"+gender+"\',\'"+pwd+"\',\'"+realname+"\',\'"+career+"\',\'"+address+"\',\'"+email+"\',\'"+tel+"\',\'"+birth+"\')";
ResultSet rs=db.executeQuery(sql);
%>
<p><font color="#CC033"><%=uid%></font>:祝贺你！你的信息已经填加到数据库中.</p>
<p align="center"><a href="default.jsp">回到首页</a></p>
</body>
</html>
Top

8 楼rainshow（要学习的是那样多，时间却是那么的少）回复于 2003-11-01 19:03:53 得分 0

好象没什么毛病Top

9 楼yipingdeng（日立新）回复于 2003-11-01 19:17:17 得分 0

500 Servlet Exception
Note: sun.tools.javac.Main has been deprecated.
/customer/reg3.jsp:36: String not terminated at end of line.
String sql="insert into custom(uid,nickname,gender,pwd,realname,career,address,email,tel,birth)
^
/customer/reg3.jsp:37: ';' expected.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
/customer/reg3.jsp:37: Invalid character constant.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
/customer/reg3.jsp:37: Invalid character constant.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
/customer/reg3.jsp:37: Invalid character constant.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
/customer/reg3.jsp:37: Invalid character constant.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
/customer/reg3.jsp:37: Invalid character constant.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
/customer/reg3.jsp:37: Invalid character constant.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
/customer/reg3.jsp:37: Invalid character constant.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
/customer/reg3.jsp:37: Invalid character constant.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
/customer/reg3.jsp:37: Invalid character constant.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
/customer/reg3.jsp:37: Invalid character constant.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
/customer/reg3.jsp:37: String not terminated at end of line.
values('"+uid+"','"+nickname+"','"+gender+"','"+pwd+"','"+realname+"','"+career+"','"+address+"','"+email+"','"+tel+"','"+birth+"')";
^
13 errors, 1 warning

Top

10 楼rainshow（要学习的是那样多，时间却是那么的少）回复于 2003-11-01 19:34:43 得分 0

打印出来的sql语句是什么？
Top

11 楼rainshow（要学习的是那样多，时间却是那么的少）回复于 2003-11-01 19:46:39 得分 0

1 你的sql语句中间换了一行，在values那个位置后面换行了
2 byte[] tmpbyte重新定义了，后面几个不用申明类型了Top

12 楼yipingdeng（日立新）回复于 2003-11-02 09:23:36 得分 0

上楼说得对！Top