帮忙看一下写入数据库的代码!!

dike103 2003-06-06 01:24:55

<html>
<head>
<title>注册成功！</title>
<mate http-equiv="Content.Type" content="html/test" charset="gb2312">
</head>
<body>
<@ page language="java" import="java.sql.*" %>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb"; //mydb是你数据库的名
//pubs为你的数据库的
String user="aaa"; //用户名
String password="aaa"; //密码
Connection conn= DriverManager.getConnection(url,user,password);
%>
<%!
String username;
String password;
String gender;
String realname;
String career;
String address;
String email;
String tel;
String QQ;
String year;
String month;
String day;
String birth;
String sql; //变量的定义
%>
<%
username=request.getParameter("username");
password=request.getParameter("password");
gender=request.getParameter("gender");
realname=request.getParameter("realname");
career=request.getParameter("career");
address=request.getParameter("address");
email=request.getParameter("email");
tel=request.getParameter("tel");
QQ=request.getParameter("QQ");
year=request.getParameter("year");
month=request.getParameter("month");
day=request.getParameter("day"); //获得表单的值
birth=year+"-"+manth+"-"+day;
sql="insert into custom values("+username+","+password+","+gender+","+realname+","+career+","+address+","+email+","+tel+","+QQ+","+birth+");
ResultSet rs=db.executeQuery(sql);
%>
<%=uid%>:祝贺你！注册成功！
<a href="defult.jsp">回到首页</a>
</body>
</html>

运行后出现的错误是:
Generated servlet error:
C:\Apache Group\Tomcat 4.0\work\Standalone\localhost\_\reg4$jsp.java:105: String not terminated at end of line.
sql="insert into custom values("+username+","+password+","+gender+","+realname+","+career+","+address+","+email+","+tel+","+QQ+","+birth+");
^

An error occurred between lines: 31 and 47 in the jsp file: /reg4.jsp

Generated servlet error:
C:\Apache Group\Tomcat 4.0\work\Standalone\localhost\_\reg4$jsp.java:106: ';' expected.
ResultSet rs=db.executeQuery(sql);
^
2 errors, 1 warning

...全文

74 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

henrycheng 2003-06-06

打赏
举报

另外，你的db应该使用PreparedStatement而不是Statement！

henrycheng 2003-06-06

打赏
举报

你是将数据Insert到数据库中，所以应该使用db.executeUpdate(sql)而不是db.executeQuery(sql)！！

lkenshin 2003-06-06

打赏
举报

建议楼主采用StringBuffer,一来,不容易出错,而来 StringBuffer 比String 执行效率高

StringBuffer sbf = new StringBuffer(200);//200是估计的长度
sbf = sbf.append("insert into custom values ('");
sbf = sbf.append(username);
sbf = sbf.append("' ,'");
...
String sql = sbf.toString();
...

sdf

林巅峰 2003-06-06

打赏
举报

你构造的sql字符串有语法错误!仔细看看!

supjava 2003-06-06

打赏
举报

参考：
1）检查你的参数变量是否传递过来？例如：System.out.println(username);
2）检查你的录入sql语句是否正确？例如：
sql="insert into custom(username,password,.....)values('"+username+"','"+password+"',......)";

boat2002w 2003-06-06

打赏
举报

字符型的双引号外面应该有单引号吧
比如：'"+username+"'
还有就是楼上提到的问题

zhaoxichao 2003-06-06

打赏
举报

sql="insert into custom values("+username+","+password+","+gender+","+realname+","+career+","+address+","+email+","+tel+","+QQ+","+birth+");
改成
sql="insert into custom values("+username+","+password+","+gender+","+realname+","+career+","+address+","+email+","+tel+","+QQ+","+birth+")";