论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2004-03-27 14:32 |只看该作者 |倒序浏览

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">;
<html>;
<head>;
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">;
<title>;修改用户信息</title>;
</head>;

<body>;
<jsp:useBean id="jspEx"scope="page" class="opendb.opendb"/>;
<%@page language="java" import="java.sql.*"%>;
<%@page language="java" import="java.lang.String.*"%>;
<%
String name=request.getParameter("name"

;
String password=request.getParameter("password"

;
String sql="select * from custom where name='"+name+"'and password='"+password+"'";
ResultSet rs=null;
rs=jspEx.executeQuery(sql);

if(rs.next()==false)
{
out.println("000000000000"

;
rs.close();

%>;
<script language=JavaScript>;
alert("用户名或密码错误"

;
self.location="editinf.html";
</script>;
<%
}
rs.close();
rs=null;
rs=jspEx.executeQuery(sql);

String realname =rs.getString("realname"

.trim;
String sex =rs.getString("sex"

.trim();
String age =rs.getString("age"

.trim();
String xueli =rs.getString("xueli"

.trim();
String marriage =rs.getString("marriage"

.trim();
String job =rs.getString("job"

.trim();
String mail =rs.getString("mail").trim();
String tel =rs.getString("tel").trim();

rs.close();
%>;

数据库连接正常，到了从rs取值时出现如下错误:
大虾们知道否关于resultset 到那里去查他的方法。
500 Servlet Exception
java.sql.SQLException: [Microsoft][ODBC q???h] 郒処?
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:618

at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3266)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5377)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:320)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:376)
at _jsp._erp._jsp._editinf1__jsp._jspService(/erp/jsp/editinf1.jsp:42)
at com.caucho.jsp.JavaPage.service(JavaPage.java:87)
at com.caucho.jsp.JavaPage.subservice(JavaPage.java:81)
at com.caucho.jsp.Page.service(Page.java:407)
at com.caucho.server.http.Invocation.service(Invocation.java:290)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:121)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:23

at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:157)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">;
<html>;
<head>;
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">;
<title>;修改用户信息</title>;
</head>;

<body>;
<jsp:useBean id="jspEx"scope="page" class="opendb.opendb"/>;
<%@page language="java" import="java.sql.*"%>;
<%@page language="java" import="java.lang.String.*"%>;
<%
String name=request.getParameter("name");
String password=request.getParameter("password");
String sql="select * from custom where name='"+name+"'and password='"+password+"'";
ResultSet rs=null;
rs=jspEx.executeQuery(sql);

if(rs.next()==false)
{
out.println("000000000000");
rs.close();

%>;
<script language=JavaScript>;
alert("用户名或密码错误");
self.location="editinf.html";
</script>;
<%
}
rs.close();
rs=null;
rs=jspEx.executeQuery(sql);

String realname =rs.getString("realname");
String sex =rs.getString("sex").trim();
String age =rs.getString("age").trim();
String xueli =rs.getString("xueli").trim();
String marriage =rs.getString("marriage").trim();
String job =rs.getString("job").trim();
String mail =rs.getString("mail").trim();
String tel =rs.getString("tel").trim();

rs.close();
%>;