struts和hibernate和serlet没有影响。在bean.setArea(rs.getString("area"));这行的时候就乱码了。package cn.edu.bit.zgc2d.accountQuery;import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;import cn.edu.bit.zgc2d.db.db;public class accountList extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { Connection conn = null;
Statement st = null;
ResultSet rs = null;
try {
db db = new db();
// 打开数据库
conn = db.conn();
// 创建st
st = conn.createStatement();
// 组织sql并执行
HttpSession session_account = request.getSession();
String account = (String) session_account.getAttribute("account");
String sql = "select * from account where main_account=" + account
+ "order by is_main_account desc";
rs = st.executeQuery(sql);
// 组建arrayList列表
ArrayList list = new ArrayList();
while (rs.next()) {
accountBean bean = new accountBean();
bean.setArea(rs.getString("area"));
bean.setKind(rs.getInt("kind"));
bean.setAccount(rs.getString("account"));
bean.setMain_account(rs.getString("main_account"));
bean.setType(rs.getInt("type"));
bean.setOther_name(rs.getString("other_name"));
bean.setPassword(rs.getString("password"));
bean.setIs_main_account(rs.getInt("is_main_account"));
bean.setMoney(rs.getString("money"));
bean.setId(rs.getInt("id"));
list.add(bean);
}
HttpSession session = request.getSession();
session.setAttribute("list", list);
if (request.getParameter("sign") != null) {
if (request.getParameter("sign").equals("del")) {
response.sendRedirect("../accountQuery/accountList.jsp?sign=del");
} else if (request.getParameter("sign").equals("change")) {
response.sendRedirect("../accountQuery/accountChangeName.jsp");
} else {
response.sendRedirect("../accountQuery/accountList.jsp");
}
}else{
response.sendRedirect("../accountQuery/accountList.jsp");
} } catch (Exception e) {
e.printStackTrace();
} finally { }
}
}
}