用标签怎么不能显示数据??还有如何对其单一数据进行删除修改
数据层:
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");
}
解决方案 »
- 关于servlet的中方法访问的问题
- 各位大大,帮忙看下这个小程序怎么写!小弟无限感激
- 高手们,熊猫烧香病毒弄的把ORACLE服务端启动不起来了,但计算机可以启却,怎么才能备份出数据啊?
- 我想从MySql数据库中提取图片,然后在jsp页面中提取,请问怎么办啊?江湖救急 啊!!!!大侠们~~
- 这个问题比较困难,有待高人指点
- JavaMail收到的邮件标题是乱码~~~(急需解决,在线等待)
- 关于weblogic中的调试问题???刚学一天,不懂!
- 100分struts读数据库数据的中文显示问题,急!!!
- JDBC的高手来帮下忙
- 我也了一个ejb,出现了这个错误,请教!
- 急求!!!!各位哥们帮帮忙
- 请问是否有这样的技术
换成requestScope...看下
out.print("Sorry!!!");
}
else {
datajava.userbane one = null;
out.print("姓名" + "\t" + "密码" + "\t" + "性别" + "\t" + "年龄");
out.print("<br/>");
for (int i = 0; i < arry.size(); i++) {
one = ( datajava.userbane) arry.get(i);
out.print(one.getUserid());
out.print(" ");
out.print(one.getUsername());
out.print(" ");
out.print(one.getUserpassword());
out.print(" ");
out.print(one.getUsersex());
out.print("<br/>");