你先看看，不懂再問我。
複製程式
<%@ page contentType="text/html; charset=big5" language="java" import="java.sql.*" %>
<%!
private static String stErrMsg;
//拿connection的程式建議寫在某隻class，不要直接寫在jsp裡面
//建議你做個 Connection Pool，連線都直接拿，大量的話資料庫很容易掛掉
private static java.sql.Connection getQueryConnection(){
Connection conn = null;
String stUrl = "jdbc:microsoft:sqlserver://"+stDataBaseServerIP+":"+
stDataBaseServerPort+";DatabaseName="+stADDatabaseServerTable;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
conn = DriverManager.getConnection(stUrl,stDatabaseID,stDatabasePW);
}
catch(Exception ex){
stErrorMsg = ex.getMessage();
conn = null;
}
return conn;
}
public static String getErrMessage(){
return stErrMsg;
}
%>
<%
String stName = session.getValue("asd");
if(stName==null || stName.length()==0){
out.print("get name error");
return;
}
%>
<%=stName%>的個人資料
<html>
<body>
<center>
<table align="left">
<tr bgcolor=SkyBlue>
<td>帳號</td><td>密碼</td><td>姓名</td><td>電話</td><td>性別</td><td>地址</td>
</tr>
<%
Connection con = this.getQueryConnection();
if(con==null){
out.print("get connection error:"+this.getErrMessage());
return;
}
try{
Statement stmt = con.createStatement();
String sql = "select * from admin where username='"+stName.replaceAll("'","''")+"'";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
%>
<TR>
<TD><B><%= rs.getString("usermame") %></B></TD>
<TD><B><%= rs.getString("pass") %></B></TD>
<TD><B><%= rs.getString("chname") %></B></TD>
<TD><B><%= rs.getString("tel") %></B></TD>
<TD><B><%= rs.getString("sex") %></B></TD>
<TD><B><%= rs.getString("address") %></B></TD>
</TR>
<%
}
else{
%>
<tr>
<td colspan="6">none data</td>
</tr>
<%
}
rs.close();
stmt.close();
}
catch(Exception e){
out.print("error:"+e.toString());
}
finally{
try{con.close();}catch(Exception ee){}
con = null;
}
%>
</table>
</center>
</body>
</html>
PS：資料想做修改的話，作一個 form 吧？AJAX 也不錯，要小心寫就是了。
