Action-Dao-Connection

//ACTION
public class PublicAction {

public void updatepage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
//����UTF-8
request.setCharacterEncoding("UTF-8");

String newsid = request.getParameter("newsid");

NewsDao newsdao = new NewsDao();

NewsBean newsBean = new NewsBean();
newsBean = newsdao.selectNewsId(Long.parseLong(newsid));

request.setAttribute("type","update");
request.setAttribute("newsBean", newsBean);
request.getRequestDispatcher("add_update.jsp").forward(request, response);
}

}


//DAO
public class Dao {

public List<UserBean> selUser(){
ConnectionManager connManager = new ConnectionManager();
Connection conn=null;
PreparedStatement st=null;
ResultSet rs=null;

String sql= "SELECT * FROM ";
sql+="User";

List<UserBean> myList = new ArrayList<UserBean>();

try {
conn = connManager.getConnection();
st = conn.prepareStatement(sql);
rs = st.executeQuery();
while (rs.next()) {
UserBean userBean = new UserBean();
userBean.setId(rs.getLong("id"));
userBean.setUserName(rs.getString("name"));
userBean.setPassword(rs.getString("psw"));
userBean.setUserAddress(rs.getString("address"));
myList.add(userBean);
}

connManager.closeConnection(rs, st, conn);


} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}

return myList;
}
}


//ConnectionManager
public class ConnectionManager {
private String driver="com.mysql.jdbc.Driver";
private String url="jdbc:mysql://localhost:3306/news?useUnicode=true&characterEncoding=gbk";
private String userName="sa";
private String password="sa";

//获取连接的方法
public Connection getConnection(){
Connection conn=null;
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,userName,password);

} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return conn;
}

//关闭连接的方法
public void closeConnection(ResultSet rs,PreparedStatement st,Connection conn){
try {
if (rs!=null) {
rs.close();
}
if(st!=null){
st.close();
}
if(conn!=null&(!conn.isClosed())){
conn.close();
}

} catch (Exception e) {
// TODO: handle exception
}
}
}