| 1.jsp連接數(shù)據(jù)庫問題,將用戶信息從數(shù)據(jù)庫里讀出,放到表單里, |
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>無標(biāo)題文檔</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驗(yàn)證方式，則采用下面的語句連接
//Connection conn = DriverManager.getConnection(driver);
//如果采用SQL Server驗(yàn)證方式，則采用下面語句，其中sa是用戶名，密碼為空，如果用戶設(shè)置了密碼，后面的引號中寫入密碼
Connection conn = DriverManager.getConnection(driver,"sa","get");
Statement stmt = conn.createStatement();
//生成查詢的sql命令
String sql="select * from custom where uid='"+uid+"'";
//rs為返回結(jié)果的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">請?jiān)O(shè)定您的密碼：</td>
<td><input type="password" name="pwd" /></td>
</tr>
<tr>
<td height="34">請確認(rèn)您的密碼：</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">請輸入您的真實(shí)姓名：</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">請輸入聯(lián)系電話：</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">職業(yè)：</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="確認(rèn)" /></td>
<td><input type="reset" name="Submit2" value="清除" /></td>
</tr>
</table>
<p> </p>
<p> </p>
</div>
</form>
<%}%>
</body>
</html>
|
|
