JSP新闻发布系统

1.主页面

1.1登录

1.2 分页

2.注销

3.代码如下

package cn.news.dao.impl;

import java.sql.SQLException;

import org.junit.Test;

import cn.news.dao.BaseDAO;

import cn.news.dao.IUserInfoDAO;

import cn.news.entity.UserInfo;

public class UserInfoDAOImpl extends BaseDAO implements IUserInfoDAO {

    @Test

    public void loginTest() throws SQLException{

        UserInfo info =new UserInfo();

        info.setUname("admin");

        info.setUpwd("admin");

         boolean flag= isLogin(info);

         if (flag) {

            System.out.println("login success!");

        }

    }

    public boolean isLogin(UserInfo info) throws SQLException {

        boolean flag=false;

        String sql="select count(1) as mycount from userinfo where uname=? and upwd=?";

        Object[] paras={info.getUname(),info.getUpwd()};

        getConection();

        rs=executeQuery(sql,paras);

        if (rs.next()) {

            int count = rs.getInt("mycount");

            if (count>) {

                //登录成功

                flag=true;

            }

        }

        closeResources();

        return flag;

    }

}

package cn.news.serlvet;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.SQLException;

import java.util.List;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import cn.news.entity.Topic;

import cn.news.service.ITopicService;

import cn.news.service.impl.TopicServiceImpl;

public class TopicServlet extends HttpServlet {

    public void doGet(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

         doPost(request,response);

    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        ITopicService service=new TopicServiceImpl();

        try {

            List<Topic> list = service.getAllTopics();

            request.setAttribute("topicList",list);

            //转发到列表页面

            request.getRequestDispatcher("/newspages/topic_list.jsp").forward(request, response);

        } catch (SQLException e) {

        }

    }

}

<%@page import="cn.news.entity.Page"%>

<%@page import="javax.naming.InitialContext"%>

<%@page import="javax.naming.Context"%>

<%@page import="cn.news.entity.NewsInfo"%>

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>新闻中国</title>

<link href="css/main.css" rel="stylesheet" type="text/css" />

</head>

<body>

<%

Context ctx=new InitialContext();

String ss=(String)ctx.lookup("java:comp/env/hehe");

%>

<%=ss %>

<div id="header">

  <div id="top_login">

  <%--

     登录区域 需要程序员构建表单

    --%>

    <form action="UserInfoServlet?action=login" method="post">

        <label> 登录名 </label>

        <input type="text" id="uname" name="uname"  value="" class="login_input" />

        <label> 密&#;&#;码 </label>

        <input type="password" id="upwd" name="upwd" value="" class="login_input" />

        <input type="submit" class="login_sub" value="登录" onclick="login()"/>

    </form>

    <label id="error"> </label>

    <img src="data:images/friend_logo.gif" alt="Google" id="friend_logo" /> </div>

  <div id="nav">

    <div id="logo"> <img src="data:images/logo.jpg" alt="新闻中国" /> </div>

    <div id="a_b01"> <img src="data:images/a_b01.gif" alt="" /> </div>

    <!--mainnav end-->

  </div>

</div>

<div id="container">

  <div class="sidebar">

    <h1> <img src="data:images/title_1.gif" alt="国内新闻" /> </h1>

    <div class="side_list">

      <ul>

        <li> <a href='#'><b> 景区，如何不再依靠门票收入 </b></a> </li>

        <li> <a href='#'><b> 高考期间中东部地区将现大范围降雨 </b></a> </li>

        <li> <a href='#'><b> 山西离柳焦煤集团井下人行车发生事故6人死亡 </b></a> </li>

      </ul>

    </div>

    <h1> <img src="data:images/title_2.gif" alt="国际新闻" /> </h1>

       <h1> <img src="data:images/title_3.gif" alt="娱乐新闻" /> </h1>

    <div class="side_list">

      <ul>

        <li> <a href='#'><b> "星跳水立方"决战临近 陈楚生被华谊要求进前三 </b></a> </li>

        <li> <a href='#'><b> 《新恋爱时代》登东方卫视 《非诚》元素遭删除 </b></a> </li>

        <li> <a href='#'><b> 《海角七号》导演新片开机 吴宇森等出席 </b></a> </li>

        <li> <a href='#'><b> 《致命黑兰》佐伊坐拥7种武器 暴力登陆全国院线 </b></a> </li>

      </ul>

    </div>

  </div>

  <div class="main">

    <div class="class_type"> <img src="data:images/class_type.gif" alt="新闻中心" /> </div>

    <div class="content">

      <ul class="class_date">

        <li id='class_month'> <a href='#'><b> 国内 </b></a> <a href='#'><b> 国际 </b></a> <a href='#'><b> 军事 </b></a> <a href='#'><b> 体育 </b></a> <a href='#'><b> 娱乐 </b></a> <a href='#'><b> 社会 </b></a> <a href='#'><b> 财经 </b></a> <a href='#'><b> 科技 </b></a> <a href='#'><b> 健康 </b></a> <a href='#'><b> 汽车 </b></a> <a href='#'><b> 教育 </b></a> </li>

        <li id='class_month'> <a href='#'><b> 房产 </b></a> <a href='#'><b> 家居 </b></a> <a href='#'><b> 旅游 </b></a> <a href='#'><b> 文化 </b></a> <a href='#'><b> 其他 </b></a> </li>

      </ul>

      <ul class="classlist">

      <%

      Page onepage=(Page)request.getAttribute("onepage");

      for(NewsInfo item : onepage.getList()){

          %>

          <li> <a href='news_read.jsp'> <%=item.getNtitle() %> </a><span> <%=item.getNcreateda() %> </span> </li>

    <%

      }

      %>

        <p align="right"> 当前页数:[/]&nbsp; <a href="UserInfoServlet?pageIndex=<%=onepage.getPageIndex()+1%>">下一页</a> <a href="#">末页</a> </p>

      </ul>

    </div>

    <div class="picnews">

      <ul>

        <li> <a href="#"><img src="data:images/Picture1.jpg" width="" alt="" /> </a><a href="#">幻想中穿越时空</a> </li>

        <li> <a href="#"><img src="data:images/Picture2.jpg" width="" alt="" /> </a><a href="#">国庆多变的发型</a> </li>

        <li> <a href="#"><img src="data:images/Picture3.jpg" width="" alt="" /> </a><a href="#">新技术照亮都市</a> </li>

        <li> <a href="#"><img src="data:images/Picture4.jpg" width="" alt="" /> </a><a href="#">群星闪耀红地毯</a> </li>

      </ul>

    </div>

  </div>

</div>

<div id="footer">

 <iframe src="index-elements/index_bottom.html" scrolling="no" frameborder="" width="947px" height="190px"></iframe>

</div>

</body>

</html>

巴特西

JSP新闻发布系统

最新文章

热门文章