用标签怎么不能显示数据??还有如何对其单一数据进行删除修改
数据层:
package datajava;
import java.sql.*;
import java.util.*;
public class xians {
private Connection conn;
private PreparedStatement psmt;
private ResultSet rs;
private ArrayList arry;
public ArrayList xiashconn(){
conn=new database().dataconn();
try {
psmt = conn.prepareStatement("select * from userinfo");
rs=psmt.executeQuery();
while(rs.next())
{
userbane ub=new userbane();
ub.setUserid(rs.getString(1));
ub.setUsername(rs.getString(2));
ub.setUsersex(rs.getString(3));
ub.setUserpassword(rs.getString(4));
arry.add(ub);
}
} catch (SQLException ex) {
}finally
{
if(conn!=null)
try {
conn.close();
} catch (SQLException ex1) {
} }
return arry;
}
}
实体类:
package datajava;
public class userbane {
private String userid;
private String username;
private String usersex;
private String userpassword;
public String getUserid() {
return userid;
} public String getUsername() {
return username;
} public String getUsersex() {
return usersex;
} public String getUserpassword() {
return userpassword;
} public void setUserid(String userid) {
this.userid = userid;
} public void setUsername(String username) {
this.username = username;
} public void setUsersex(String usersex) {
this.usersex = usersex;
} public void setUserpassword(String userpassword) {
this.userpassword = userpassword;
}
} 模型层:
<table border="2">
<tr>
<td>姓名 </td>
<td>性别 </td>
<td>ID </td>
<td>密码 </td>
<td>修改 </td>
<td>删除 </td>
</tr>
<c:forEach var="i" items="responseScope.arry">
<tr>
<td>
<c:out value="${i.userid}"/>
</td>
<td>
<c:out value="${i.usersex}"/>
</td> <td>
<c:out value="${i.username}"/>
</td> <td>
<c:out value="${i.userpassword}"/>
</td> <td>修改 </td>
<td>删除 </td>
</tr>
</c:forEach>
控制层:
datajava.userbane ub = new datajava.userbane(); ArrayList arry = new datajava.xians().xiashconn();
if (arry == null) {
response.sendRedirect("shibai.jsp");
} else {
request.setAttribute("arry",arry);
request.getRequestDispatcher("/xianshi.jsp").forward(
request,
response);
} } else {
response.sendRedirect("shibai.jsp");
}
数据层:
package datajava;
import java.sql.*;
import java.util.*;
public class xians {
private Connection conn;
private PreparedStatement psmt;
private ResultSet rs;
private ArrayList arry;
public ArrayList xiashconn(){
conn=new database().dataconn();
try {
psmt = conn.prepareStatement("select * from userinfo");
rs=psmt.executeQuery();
while(rs.next())
{
userbane ub=new userbane();
ub.setUserid(rs.getString(1));
ub.setUsername(rs.getString(2));
ub.setUsersex(rs.getString(3));
ub.setUserpassword(rs.getString(4));
arry.add(ub);
}
} catch (SQLException ex) {
}finally
{
if(conn!=null)
try {
conn.close();
} catch (SQLException ex1) {
} }
return arry;
}
}
实体类:
package datajava;
public class userbane {
private String userid;
private String username;
private String usersex;
private String userpassword;
public String getUserid() {
return userid;
} public String getUsername() {
return username;
} public String getUsersex() {
return usersex;
} public String getUserpassword() {
return userpassword;
} public void setUserid(String userid) {
this.userid = userid;
} public void setUsername(String username) {
this.username = username;
} public void setUsersex(String usersex) {
this.usersex = usersex;
} public void setUserpassword(String userpassword) {
this.userpassword = userpassword;
}
} 模型层:
<table border="2">
<tr>
<td>姓名 </td>
<td>性别 </td>
<td>ID </td>
<td>密码 </td>
<td>修改 </td>
<td>删除 </td>
</tr>
<c:forEach var="i" items="responseScope.arry">
<tr>
<td>
<c:out value="${i.userid}"/>
</td>
<td>
<c:out value="${i.usersex}"/>
</td> <td>
<c:out value="${i.username}"/>
</td> <td>
<c:out value="${i.userpassword}"/>
</td> <td>修改 </td>
<td>删除 </td>
</tr>
</c:forEach>
控制层:
datajava.userbane ub = new datajava.userbane(); ArrayList arry = new datajava.xians().xiashconn();
if (arry == null) {
response.sendRedirect("shibai.jsp");
} else {
request.setAttribute("arry",arry);
request.getRequestDispatcher("/xianshi.jsp").forward(
request,
response);
} } else {
response.sendRedirect("shibai.jsp");
}
->
<c:forEach var="i" items="${responseScope.arry}"> 试一试