| 1.jsp连接数据库问题,将用户信息从数据库里读出,放到表单里, |
Copy to clipboard |
Posted by: 86970810
Posted on: 2006-05-29 16:22
原代码
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www./TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www./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>
|
|
