大家看看我的代码
这个叫SelectAllUser
package huoshichuli;
import java.sql.Connection;
import java.sql.ResultSet;import java.sql.Statement;
import java.util.*;import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.softengine.util.database.DBCloser;
public class SelectAllUser extends BusinessController{
public String exectue(HttpServletRequest request,
HttpServletResponse response
){
Connection dbCon=null;
Statement stmt=null;
ResultSet rs=null;
try{
dbCon=ConnectionFactory.getConnection();
String sql="select username from page";
stmt=dbCon.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next())
{
String sss=rs.getString("username");
request.setAttribute("username", sss);
}
return "/jsp/SelectAllUserSuccess.jsp";
}catch(Exception e){
e.printStackTrace();
return "/jsp/dbException.jsp";
}finally{
DBCloser.clearDatabaseResource(dbCon,stmt,rs);
}
}
}然后转到SelectAllUserSuccess
里面我是这样写的
以下是所有的注册用户:
<%=request.getParameter("username") %>
<%=request.getAttribute("sss") %>我知道不对,可是不知道应该怎么改,我的目的是,当一个用户成功登陆以后。就可以查看数据库中已经存入的所有用户的名字,希望大家指教。分数不是问题,谢谢。
这个叫SelectAllUser
package huoshichuli;
import java.sql.Connection;
import java.sql.ResultSet;import java.sql.Statement;
import java.util.*;import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.softengine.util.database.DBCloser;
public class SelectAllUser extends BusinessController{
public String exectue(HttpServletRequest request,
HttpServletResponse response
){
Connection dbCon=null;
Statement stmt=null;
ResultSet rs=null;
try{
dbCon=ConnectionFactory.getConnection();
String sql="select username from page";
stmt=dbCon.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next())
{
String sss=rs.getString("username");
request.setAttribute("username", sss);
}
return "/jsp/SelectAllUserSuccess.jsp";
}catch(Exception e){
e.printStackTrace();
return "/jsp/dbException.jsp";
}finally{
DBCloser.clearDatabaseResource(dbCon,stmt,rs);
}
}
}然后转到SelectAllUserSuccess
里面我是这样写的
以下是所有的注册用户:
<%=request.getParameter("username") %>
<%=request.getAttribute("sss") %>我知道不对,可是不知道应该怎么改,我的目的是,当一个用户成功登陆以后。就可以查看数据库中已经存入的所有用户的名字,希望大家指教。分数不是问题,谢谢。
StringBuffer sb = new StringBuffer();
if(rs.next()){
sb.append(rs.getString("username"));
}
request.setAttribute("username", sb.toString());在jsp中使用<%=request.getAttribute("username") %>
String sql="select username from page";
stmt=dbCon.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next())
{
String sss=rs.getString("username");
request.setAttribute("username", sss);
}
return "/jsp/SelectAllUserSuccess.jsp";
}catch(Exception e){
e.printStackTrace();
return "/jsp/dbException.jsp";
}finally{
DBCloser.clearDatabaseResource(dbCon,stmt,rs);
}
通过方法查询出数据库中已经存入的所有用户的名字并把它放入对象重
然后在JSP可以可以参考我做的一个循环用来输出userList = userBO.list(groupId,accountId); 这里是通过页面调用JAVA类的查询方法 下面是循环输出
<%
for(int i=0;i<userList.length;i++){
DQ.UserDO userDOTemp = userList[i];
%>
<tr>
<!--<td>
<%//=DQ.Common.writeHtml(userDOTemp.getUserID()+"")%> </td>-->
<td><a href="javascript:userAmend(<%=userDOTemp.getUserID()%>,<%=userDOTemp.getGroupID()%>)"><%=DQ.Common.writeHtml(userDOTemp.getUserName())%></a></td>
<!--<td>
<%// if(userDOTemp.getActive()){
// out.println("Active");
// } else {
// out.println("Inactivate");
// }
%> </td>-->
<td>
<%=DQ.Common.writeHtml(userDOTemp.getUserNameEng())%> </td>
<td>
<%=DQ.Common.writeHtml(userDOTemp.getUserNameChi())%> </td>
<td>
<%=DQ.Common.writeHtml(userDOTemp.getPhone())%> </td>
<td>
<%=DQ.Common.writeHtml(userDOTemp.getEmail())%> </td>
<td>
<%=DQ.Common.writeHtml(userDOTemp.getLastLoginTime())%> </td>
<td align="center">
<%=DQ.Common.writeHtml(userDOTemp.getIsLogin())%> </td>
<td align="center"><% if(userDO.getUserID()!=userDOTemp.getUserID()){%>
<input style=" height:20" type="button" id="del<%=i%>" name="del<%=i%>" value="Delete" onclick="delUser('<%=userDOTemp.getUserID()%>','<%=userDOTemp.getUserName()%>');">
<%}%>
</td>
</tr>
<%
}
%>
</table>
</td>
</tr>
<% }
%>
dbCon=ConnectionFactory.getConnection();
String sql="select username from page";
stmt=dbCon.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next())
{
String sss=rs.getString("username");
request.setAttribute("username", sss);
}
return "/jsp/SelectAllUserSuccess.jsp";
}改下 rs.next() 你要循环存放数据 要用while(rs.next()){
rs.getString("DB字段名")
}
最好将他们放到LIST里去2.如果在所进入的页面要看到除了自己以外的人,在页面取得登陆人的ID就可以,改下SQL就OK了
jsp页面,循环那个list,这种方法比较易懂
代码如9楼