新闻发布系统进程汇报

1。整个新闻发布系统全架构

2。实现登陆

public boolean isLogin(UserInfo info) throws Exception {
		getConection();
		boolean flag=false;
		String sql="select count(1)as con from userinfo where uname=? and upwd=?";
		Object[]paras={info.getUname(),info.getUpwd()};
		rs=executeQuery(sql,paras);
		if(rs.next()){
		  int count=rs.getInt("con");
		  if(count>0){
			  flag=true;
		  }
		}
		return flag;
	}

}

  serlvet层代码：

		//解决乱码
		request.getCharacterEncoding();
		//解析
		String uname=request.getParameter("uname");
		String upwd=request.getParameter("upwd");
		UserInfo info=new UserInfo();
		info.setUname(uname);
		info.setUpwd(upwd);
		IUserInfoService service=new UserInfoServiceImpl();
		
		try{
			
			boolean flag=service.isLogin(info);
			
			if(flag){
				request.getSession().setAttribute("uname", uname);
				request.getRequestDispatcher("/newspages/admin.jsp").forward(request, response);
			}else{
				
				//request.getRequestDispatcher("/index.jsp").forward(request, response);
				response.sendRedirect("/NewsManagerSystem/index.jsp");
			}
		}catch(SQLException e){
			e.printStackTrace();
		} catch (Exception e) {
			e.printStackTrace();
		} 
		}else{
			request.getRequestDispatcher("/index.jsp").forward(request, response);
		}
	}

}

　　3.实现注销

 

		String action=request.getParameter("action");		
		if("logout".equals(action)){
			request.getSession().removeAttribute("uname");
			//response.sendRedirect("/NewsManagerSystem/index.jsp");
				request.getRequestDispatcher("/index.jsp").forward(request, response);	

　　

4.显示新闻列表

public List<NewsInfo> getAllNews() throws Exception {
		getConection();
		List<NewsInfo>list=new ArrayList<NewsInfo>();
		String sql="select * from newsinfo";
		rs=executeQuery(sql);
		while(rs.next()){
			NewsInfo info=new NewsInfo();
			info.setNtitle(rs.getString("ntitle"));
			info.setNcreateda(rs.getDate("ncreateda"));
			list.add(info);
		}
		return list;
	}

 5.编辑主题

	
	public List<Topic> getAllTopics() throws Exception {
       List<Topic> list=new ArrayList<Topic>();
       getConection();
       String sql="select * from topic";
       ResultSet rs= executeQuery(sql);
       
       while (rs.next()) {
	    Topic topic=new Topic();
	    topic.setTid(rs.getInt("tid"));
	    topic.setTname(rs.getString("tname"));
	    list.add(topic);
	}
      return list;
	}

6.添加主题

public boolean addTopic(Topic topic) throws SQLException {
			getConection();
		boolean flag=false;
		String sqlString="insert into topic values(?,?)";
        int count=0; 
        try {
			count=exeuteUpdate(sqlString,topic.getTid(),topic.getTname());
			if (count>0) {
				flag=true;
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return flag;
	}　

　7.分页显示

　

public List<NewsInfo> getOnePageData(int pageindex, int pageSize) throws Exception{
		List<NewsInfo>list=new ArrayList<NewsInfo>();
		String sql="select * from newsinfo limit ?,?";
		Object[]paras={(pageindex-1)*pageSize,pageSize};
		getConection();
		rs=executeQuery(sql,paras);
		while(rs.next()){
			NewsInfo info=new NewsInfo();
			info.setNtitle(rs.getString("ntitle"));
			info.setNcreateda(rs.getDate("ncreateda"));
			list.add(info);
		}
		
		return list;
	}

　以上就是我的新闻发布系统大概进程　

   增删改还没有写