Java开发网 Java开发网
注册 | 登录 | 帮助 | 搜索 | 排行榜 | 发帖统计  

您没有登录

» Java开发网 » Servlet/JSP/JSF/JavaFX Script  

按打印兼容模式打印这个话题 打印话题    把这个话题寄给朋友 寄给朋友    该主题的所有更新都将Email到你的邮箱 订阅主题
reply to postflat modethreaded modego to previous topicgo to next topicgo to back
作者 jsp连接数据库问题,将用户信息从数据库里读出,放到表单里,
86970810





发贴: 4
于 2006-05-29 16:22 user profilesend a private message to userreply to postsearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
原代码
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-color: #ADBACE;
}
-->
</style>
<link href="css/site.css" rel="stylesheet" type="text/css" />
</head>

<body>
<%
String uid=(String)session.getValue("uid");
if(uid==null||uid=="")
{%>
<p>您还没有登陆！</p>
<p><a href="default.jsp">回到首页</a>
<%}else{%>
</p>
<form action="edit2.jsp" method="post">
<div align="center">
<p>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String driver = "jdbc:odbc:try";
//如果是采用windwos验证方式，则采用下面的语句连接
//Connection conn = DriverManager.getConnection(driver);
//如果采用SQL Server验证方式，则采用下面语句，其中sa是用户名，密码为空，如果用户设置了密码，后面的引号中写入密码
Connection conn = DriverManager.getConnection(driver,"sa","get");
Statement stmt = conn.createStatement();
//生成查询的sql命令
String sql="select * from custom where uid='"+uid+"'";
//rs为返回结果的ResultSet对象
ResultSet rs=stmt.executeQuery(sql);
rs.next();
String nickname=rs.getString("nickname").trim();
String name=rs.getString("name").trim();
String gender=rs.getString("gender").trim();
String career=rs.getString("career").trim();
String address=rs.getString("address").trim();
String email=rs.getString("email").trim();
String tel=rs.getString("tel").trim();
String birth=rs.getString("birth").trim();
String year=birth.substring(0,4);
String month=birth.substring(5,7);
String date=birth.substring(8,10);
%>
请按照下表修改您的信息！</p>
<hr />
<table width="527" border="0">
<tr>
<td width="153" height="32">用户 ID: </td>
<td width="364" ><%=uid%> </td>
<input type="hidden" name="uid" value="<%=uid%>">
</tr>
<tr>
<td height="29">请设定您的密码：</td>
<td><input type="password" name="pwd" /></td>
</tr>
<tr>
<td height="34">请确认您的密码：</td>
<td><input type="password" name="pwd1" /></td>
</tr>
<tr>
<td height="27">请输入您的昵称：</td>
<td><input type="text" name="nickname" value="<%=nickname%>"/></td>
</tr>
<tr>
<td height="31">请选择您的性别：</td>
<td><input name="gender" type="radio" <%if(gender.compareTo("male")==0) out.print("checked");%> value="male" />
男
<input type="radio" name="gender" <%if(gender.compareTo("female")==0) out.print("checked");%> value="female" />
女</td>
</tr>
<tr>
<td height="25">请输入您的真实姓名：</td>
<td><input type="text" name="name" value="<%=name%>"/></td>
</tr>
<tr>
<td height="24">请输入您的通讯地址：</td>
<td><input type="text" name="address" value="<%=address%>"/></td>
</tr>
<tr>
<td height="25">请输入电子信箱：</td>
<td><input type="text" name="email" value="<%=email%>"/></td>
</tr>
<tr>
<td height="30">请输入联系电话：</td>
<td><input type="text" name="tel" value="<%=tel%>" /></td>
</tr>
<tr>
<td height="28">请输入您的生日：</td>
<td><input name="year" type="text" size="10" value="<%=year%>"/>
年
<input name="month" type="text" size="5" value="<%=month%>"/>
月
<input name="date" type="text" size="5" value="<%=date%>"/>
日(yyyy-mm-dd)</td>
</tr>
<tr>
<td height="28">职业：</td>
<td><input type="text" name="career" value="<%=career%>"/></td>
</tr>
</table>
<hr />
<table width="320" border="0">
<tr>
<td height="31"><input type="submit" name="Submit" value="确认" /></td>
<td><input type="reset" name="Submit2" value="清除" /></td>
</tr>
</table>
<p> </p>
<p>  </p>
</div>
</form>
<%}%>
</body>
</html>

错误提示:
javax.servlet.ServletException: Column not found
  org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
  org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
  org.apache.jsp.edit1_jsp._jspService(edit1_jsp.java:108)
  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

root cause

java.sql.SQLException: Column not found
  sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(Unknown Source)
  sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
  org.apache.jsp.edit1_jsp._jspService(edit1_jsp.java:66)
  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

求助:我究竟错在那里,怎摸改,我在用户界面倒入数据到数据库没问题，
但这行代码是从数据库倒出到用户界面就不行...



话题树型展开
人气 标题 作者 字数 发贴时间
2657 jsp连接数据库问题,将用户信息从数据库里读出,放到表单里, 86970810 5447 2006-05-29 16:22
1810 Re:jsp连接数据库问题,将用户信息从数据库里读出,放到表单里, lisliefor 48 2006-05-29 21:23
2297 Re:jsp连接数据库问题,将用户信息从数据库里读出,放到表单里, 86970810 14 2006-05-30 11:36

reply to postflat modethreaded modego to previous topicgo to next topicgo to back
  已读帖子
  新的帖子
  被删除的帖子
Jump to the top of page

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923