<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*" %>
<html>
<head><title>员工管理</title>
</head>
<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
String url="jdbc:sqlserver://localhost:1433;DatabaseName=company";
String editemployeename=request.getParameter("name");
Connection conn=DriverManager.getConnection(url,"user","123456");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(
"select * from employee where firstname='"+editemployeename+"'");
if(rs!=null)rs.next();
%>
<body>
修改员工的数据
<hr>
<form action=employrredit.jsp method=post>
<table border="0" cellspacing="0">
<tr>
<td> Firstname:</td>
<td>
<input type="text" size="20" name="firstname" readonly="true" value="<%=rs.getString("firstname")%>"> </td></tr>
<tr>
<td> Lastname:</td>
<td><input type="text" size="20" name="lastname"
value="<%=rs.getString("lastname")%>" /></td>
</tr>
<tr>
<td> Age:</td>
<td><input type="text" size="20" name="age"
value="<%=rs.getInt("age")%>" /></td>
</tr>
<tr>
<td> City:</td>
<td>
<input type="text" size="20" name="city"
value="<%=rs.getString("city")%>" /> </td></tr>
<tr>
<td> Address:</td>
<td>
<input type="text" size="40" name="address"
value="<%=rs.getString("address")%>" /> </td></tr>
</table>
<input type="submit" value="提交" />
</form>
</body>
<%
rs.close();
stmt.close();
conn.close();
%>
</html>Java
<%@ page import="java.sql.*" %>
<html>
<head><title>员工管理</title>
</head>
<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
String url="jdbc:sqlserver://localhost:1433;DatabaseName=company";
String editemployeename=request.getParameter("name");
Connection conn=DriverManager.getConnection(url,"user","123456");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(
"select * from employee where firstname='"+editemployeename+"'");
if(rs!=null)rs.next();
%>
<body>
修改员工的数据
<hr>
<form action=employrredit.jsp method=post>
<table border="0" cellspacing="0">
<tr>
<td> Firstname:</td>
<td>
<input type="text" size="20" name="firstname" readonly="true" value="<%=rs.getString("firstname")%>"> </td></tr>
<tr>
<td> Lastname:</td>
<td><input type="text" size="20" name="lastname"
value="<%=rs.getString("lastname")%>" /></td>
</tr>
<tr>
<td> Age:</td>
<td><input type="text" size="20" name="age"
value="<%=rs.getInt("age")%>" /></td>
</tr>
<tr>
<td> City:</td>
<td>
<input type="text" size="20" name="city"
value="<%=rs.getString("city")%>" /> </td></tr>
<tr>
<td> Address:</td>
<td>
<input type="text" size="40" name="address"
value="<%=rs.getString("address")%>" /> </td></tr>
</table>
<input type="submit" value="提交" />
</form>
</body>
<%
rs.close();
stmt.close();
conn.close();
%>
</html>Java
syso(rs.getString("xx"));
}
这样才能保证你的rs集合有值才遍历,不然没值的时候会报错
String lastname = "";
while(rs.next()){
firstname = rs.getString("firstname");
lastname = rs.getString("lastname");
}
然后下面input的value就用这个firstname就可以了
<%
String firstName = "";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();2,
if(rs!=null)rs.next();
改成
if(rs.next()) {
firstName = rs.getString("firstname");
// 其他字段类似
}3,赋值
value="<%=firstName %>"
// 其他字段类似