怎样把从mysql数据库查询的数据通过action的调用显示到struts2的jsp页面中去? 我想写一个personal.jsp页面用于显示从mysql数据库中查询的数据,查询数据库的代码我给封装到DatabaseConn.java中了,然后我想通过mvc模式再写一个action来查询数据库中的信息并显示在personal.jsp页面中,但是我写的代码好像不是太对请大家给指点一下了!谢谢高手指点! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 从数据库中查询的代码 public boolean getUser(String username) throws NamingException{ HttpServletRequest request=ServletActionContext.getRequest(); Connection conn = null; Statement st= null; ResultSet rs = null; boolean result=false; try { conn =(Connection) JdbcUtils.getConnection(); st =(Statement) conn.createStatement(); String sql="select * from userinfo where username='"+username+"'"; rs=(ResultSet) st.executeQuery(sql); while(rs.next()){ request.setAttribute("name",rs.getString("username")); request.setAttribute("sex",rs.getString("usersex")); request.setAttribute("birthday",rs.getString("userbirthday")); request.setAttribute("national",rs.getString("usernational")); request.setAttribute("degree",rs.getString("userdegree")); request.setAttribute("perfession",rs.getString("userperfession")); request.setAttribute("telephone",rs.getString("usertelephone")); request.setAttribute("home",rs.getString("userhome")); request.setAttribute("email",rs.getString("userhome")); result=true; } }catch (SQLException e) { e.getStackTrace(); result=false; } finally { JdbcUtils.free(rs, st, conn); } return result;} 我想问怎样通过点击person.jsp页面通过一个action来调用查询数据的方法来显示用户信息? S2SH环境搭建中struts2.0的freemarker-2.3.16包的问题 茫然ing.... 关于jsp在线聊天的问题(急) JSP如何把参数传递给iframe 关于javamail发送HTML格式邮件的问题!大家帮忙看一下啊! resin最近老是有问题 下拉列表值为中文,提交表单到本页处理,显示所选值却不能显示中文,为乱码,何故? 这是什么引起的错误 servlet当中的页面转换 客户端JavaScipt对servlet的调用问题。各位高手请进!!! 求助hibernate联合主键问题 如何通过客户端电脑的用户名实现登陆?
public boolean getUser(String username) throws NamingException{
HttpServletRequest request=ServletActionContext.getRequest();
Connection conn = null;
Statement st= null;
ResultSet rs = null;
boolean result=false;
try {
conn =(Connection) JdbcUtils.getConnection();
st =(Statement) conn.createStatement();
String sql="select * from userinfo where username='"+username+"'";
rs=(ResultSet) st.executeQuery(sql);
while(rs.next()){
request.setAttribute("name",rs.getString("username"));
request.setAttribute("sex",rs.getString("usersex"));
request.setAttribute("birthday",rs.getString("userbirthday"));
request.setAttribute("national",rs.getString("usernational"));
request.setAttribute("degree",rs.getString("userdegree"));
request.setAttribute("perfession",rs.getString("userperfession"));
request.setAttribute("telephone",rs.getString("usertelephone"));
request.setAttribute("home",rs.getString("userhome"));
request.setAttribute("email",rs.getString("userhome"));
result=true;
}
}catch (SQLException e) {
e.getStackTrace();
result=false;
} finally {
JdbcUtils.free(rs, st, conn);
}
return result;
}