原

news

2014年04月30日 10:27:46 阅读数 1312
版权声明：本文为博主原创文章，遵循 CC 4.0 by-sa 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/java_12_liuxinfei/article/details/24772449
实体bean-Admin.java
package www.csdn.net.ajax.domain;

import java.io.Serializable;

public class Admin implements Serializable {

    /**
     *
     */
    private static final long serialVersionUID = 1L;
    private Integer id;
    private String name;
    private String pass;
    public Admin() {
        super();
        // TODO Auto-generated constructor stub
    }
    public Admin(Integer id, String name, String pass) {
        super();
        this.id = id;
        this.name = name;
        this.pass = pass;
    }
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getPass() {
        return pass;
    }
    public void setPass(String pass) {
        this.pass = pass;
    }
    @Override
    public String toString() {
        return "Admin [id=" + id + ", name=" + name + ", pass=" + pass + "]";
    }
}

BaseDao.java

package www.csdn.net.ajax.dao;

import java.util.List;

public interface BaseDao<T, PK> {

    /**
     * 插入实体
     *
     * @param entity
     * @throws Exception
     */
    void insert(T entity) throws Exception;

    /**
     * 更新实体
     *
     * @param entity
     * @throws Exception
     */
    void update(T entity) throws Exception;

    /**
     * 删除实体
     *
     * @param entity
     * @throws Exception
     */
    void delete(T entity) throws Exception;

    /**
     * 根据id删除实体
     *
     * @param id
     * @throws Exception
     */
    void deleteById(PK id) throws Exception;

    /**
     * 查询所有
     *
     * @return
     * @throws Exception
     */
    List<T> findAll() throws Exception;

    /**
     * 根据id查询实体对象
     *
     * @param id
     * @return
     * @throws Exception
     */
    T findById(PK id) throws Exception;
    
    /**
     * 批量删除的操作
     * @param ids
     */
    void deletes(PK ids[])throws Exception;
    
    /**
     * 查询当前页信息
     * @param nowpage
     * @return
     */
    List<T> findNowPageInfo(int nowpage)throws Exception;
    
    Integer getCountPage()throws Exception;

}
AdminDao.java 

package www.csdn.net.news.dao;

import www.csdn.net.news.domain.Admin;

public interface AdminDao extends BaseDao<Admin, Integer>{

    /**
     * 用户登录验证(根据name，pass)
     * @param name
     * @param pass
     * @return
     */
    Admin checkLogin(String name,String pass) throws Exception;
}

DBConn.java

package www.csdn.net.news.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class DBConn {
	private static Connection conn;

	private DBConn() {

	}

	public static Connection getConn() {
		try {
			if (conn == null) {
				// 创建集合对象
				Properties properties = new Properties();
				// 装载
				properties.load(DBConn.class.getClassLoader()
						.getResourceAsStream("db.properties"));
				// 加载驱动程序
				Class.forName(properties.getProperty("driverClassName"));
				// 获取连接对象
				conn = DriverManager.getConnection(
						properties.getProperty("url"),
						properties.getProperty("user"),
						properties.getProperty("pass"));
				conn.setAutoCommit(false);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
	}

	public static void update(String sql, Object params[]) {
		PreparedStatement pstmt = null;

		try {
			pstmt = getConn().prepareStatement(sql);
			for (int i = 0; i < params.length; i++) {
				pstmt.setObject(i + 1, params[i]);
			}
			pstmt.executeUpdate();
		} catch (Exception e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			e.printStackTrace();

		} finally {
			release(null, pstmt);
		}
	}

	public static void release(ResultSet rs, PreparedStatement pstmt) {
		if (rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if (pstmt != null) {
			try {
				pstmt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}

AdminDaoImpl.java 

package www.csdn.net.news.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import www.csdn.net.news.dao.AdminDao;
import www.csdn.net.news.domain.Admin;
import www.csdn.net.news.util.DBConn;

public class AdminDaoImpl implements AdminDao {

    private Connection conn;
    private PreparedStatement pstmt;
    private ResultSet rs;

    @Override
    public void insert(Admin entity) throws Exception {
        // 定义sql
        String sql = "insert into admin(name,pass) values(?,?)";
        DBConn.update(sql, new Object[] {entity.getName(), entity.getPass()});
    }

    @Override
    public void update(Admin entity) throws Exception {
        // 定义sql语句
        String sql = "update admin set name=?,pass=? where id=?";
        DBConn.update(sql, new Object[] { entity.getName(), entity.getId(),
                entity.getPass() });
    }

    @Override
    public void delete(Admin entity) throws Exception {
        // 定义sql语句
        String sql = "delete from admin where id=?";
        DBConn.update(sql, new Object[] { entity.getId() });
    }

    @Override
    public void deleteById(Integer id) throws Exception {
        // 定义sql
        String sql = "delete from admin where id=?";
        DBConn.update(sql, new Object[] { id });
    }

    @Override
    public List<Admin> findAll() throws Exception {
        List<Admin> entities = new ArrayList<Admin>();
        // 定义sql语句
        String sql = "select id,name,pass from admin";
        conn = DBConn.getConn();
        pstmt = conn.prepareStatement(sql);
        rs = pstmt.executeQuery();
        while (rs.next()) {
            Admin entity = new Admin();
            entity.setId(rs.getInt("id"));
            entity.setName(rs.getString("name"));
            entity.setPass(rs.getString("pass"));
            entities.add(entity);

        }
        return entities;
    }

    @Override
    public Admin findById(Integer id) throws Exception {
        Admin entity = null;
        // 定义sql语句
        String sql = "select id,name,pass from admin";
        conn = DBConn.getConn();
        pstmt = conn.prepareStatement(sql);
        rs = pstmt.executeQuery();
        if (rs.next()) {
            entity = new Admin();
            entity.setId(rs.getInt("id"));
            entity.setName(rs.getString("name"));
            entity.setPass(rs.getString("pass"));

        }
        return entity;

    }

    @Override
    public Admin checkLogin(String name, String pass) throws Exception {

        Admin entity = null;
        // 定义sql语句
        String sql = "select id,name,pass from admin where name=? and pass=?";
        conn = DBConn.getConn();
        pstmt = conn.prepareStatement(sql);
        int index = 1;
        pstmt.setString(index++, name);
        pstmt.setString(index++, pass);
        rs = pstmt.executeQuery();
        while (rs.next()) {
            entity = new Admin();
            entity.setId(rs.getInt("id"));
            entity.setName(rs.getString("name"));
            entity.setPass(rs.getString("pass"));

        }
        return entity;
    }

    @Override
    public void deletes(Integer[] ids) throws Exception {
        conn = DBConn.getConn();
        try {
            for (int i = 0; i < ids.length; i++) {
                String sql = "delete from admin where id=?";
                pstmt = conn.prepareStatement(sql);
                pstmt.setInt(1, ids[i]);
                pstmt.executeUpdate();
            }
            conn.commit();
        } catch (Exception e) {
            e.printStackTrace();
            conn.rollback();
        }
    }
    final int PAGESIZE=10;
    @Override
    public List<Admin> findNowPageInfo(int nowpage) throws Exception{
        List<Admin> entities = new ArrayList<Admin>();
        // 定义sql语句
        String sql = "select id,name,pass from admin limit ?,?";
        conn = DBConn.getConn();
        pstmt = conn.prepareStatement(sql);
        int index=1;
        pstmt.setInt(index++, (nowpage-1) * PAGESIZE);
        pstmt.setInt(index++, PAGESIZE);
        rs = pstmt.executeQuery();
        while (rs.next()) {
            Admin entity = new Admin();
            entity.setId(rs.getInt("id"));
            entity.setName(rs.getString("name"));
            entity.setPass(rs.getString("pass"));
            entities.add(entity);

        }
        return entities;
    }

    @Override
    public Integer getCountPage() throws Exception {
        
        // 定义sql语句
        String sql = "select count(*) as c from admin";
        conn = DBConn.getConn();
        pstmt = conn.prepareStatement(sql);
        
        rs = pstmt.executeQuery();
        if(rs.next()) {
            int countsize=rs.getInt("c");
            return countsize%PAGESIZE==0?countsize/PAGESIZE:countsize/PAGESIZE+1;
        }
        return null;
    }

}


DefaultServlet.java 


package www.csdn.net.news.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class DefaultServlet extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		//转发
		request.getRequestDispatcher("/WEB-INF/login.jsp").forward(request, response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doGet(request, response);
	}

}

AdminSerlet.java 

package www.csdn.net.news.servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import www.csdn.net.news.dao.AdminDao;
import www.csdn.net.news.domain.Admin;
import www.csdn.net.news.impl.AdminDaoImpl;

public class AdminServlet extends HttpServlet {
	// 声明dao操作对象
	private AdminDao adminDao = new AdminDaoImpl();

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 设置编码问题
		request.setCharacterEncoding("UTF-8");
		// 获取操作的标识符
		String oper = request.getParameter("oper");
		// 判断是否是登录操作
		if ("login".equals(oper)) {
			login(request, response);
		}

		if ("list".equals(oper)) {
			list(request, response);
		}
		if ("findById".equals(oper)) {
			findById(request, response);
		}
		if ("update".equals(oper)) {
			update(request, response);
		}
		if ("add".equals(oper)) {
			add(request, response);
		}
		if ("deletes".equals(oper)) {
			deletes(request, response);
		}
		if ("deleteById".equals(oper)) {
			deleteById(request, response);
		}
	}
	public void deleteById(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
			String id=request.getParameter("id");
			
			try{
				adminDao.deleteById(Integer.parseInt(id));
			}catch(Exception e){
				request.setAttribute("msg","用户操作失败");
				e.printStackTrace();
			}
			
			// 转发给查询所有的操作
			request.getRequestDispatcher("./adminList.do?oper=list").forward(
					request, response);

	}
	public void deletes(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		String ids = request.getParameter("ids");
		System.out.println(ids + "----");
		String arrs[] = ids.split(",");
		Integer idarrs[] = new Integer[arrs.length];
		try {
			for (int i = 0; i < arrs.length; i++) {
				String arr = arrs[i];
				idarrs[i] = Integer.parseInt(arr);
			}
			adminDao.deletes(idarrs);
		} catch (Exception e) {
			e.printStackTrace();
		}

		// 转发给查询所有的操作
		request.getRequestDispatcher("./adminList.do?oper=list").forward(
				request, response);

	}

	public void add(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		// 获取更新数据
		String name = request.getParameter("name");
		String pass = request.getParameter("pass");

		Admin entity = new Admin();
		try {
			// 查询实体
			entity.setName(name);
			// 更新属性值
			entity.setPass(pass);
			// 更新
			adminDao.update(entity);
			// 转发给查询所有的操作
			request.getRequestDispatcher("./adminList.do?oper=list").forward(
					request, response);
		} catch (Exception e) {
			request.setAttribute("msg", "添加用户失败");
			// 转发到添加的页面
			request.getRequestDispatcher("./manager/admin/insertAdmin.jsp")
					.forward(request, response);
			e.printStackTrace();
		}

	}

	public void update(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		// 获取更新数据
		String id = request.getParameter("id");
		String name = request.getParameter("name");

		System.out.println("id:::" + id + "::::name" + name);

		Admin entity = null;
		try {
			// 查询实体
			entity = adminDao.findById(Integer.parseInt(id));
			// 更新属性值
			entity.setName(name);
			// 更新
			adminDao.update(entity);
		} catch (Exception e) {
			e.printStackTrace();
		}
		// 转发给查询所有的操作
		request.getRequestDispatcher("./adminList.do?oper=list").forward(
				request, response);

	}

	public void findById(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		String id = request.getParameter("id");
		Admin entity = null;
		try {
			entity = adminDao.findById(Integer.parseInt(id));
		} catch (NumberFormatException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		request.setAttribute("entity", entity);
		request.getRequestDispatcher("./manager/admin/updateAdmin.jsp")
				.forward(request, response);
	}

	public void list(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
	    String npage= request.getParameter("nowpage");
		int nowpage=1;
		int countPage=0;
		if(npage!=null){
			nowpage=Integer.parseInt(npage);
		}
		// 查询所有
		List<Admin> entities = null;
		try {
			entities = adminDao.findNowPageInfo(nowpage);
			 countPage=adminDao.getCountPage();
		} catch (Exception e) {
			e.printStackTrace();
		}
		request.setAttribute("entities", entities);
		request.setAttribute("nowpage", nowpage);
		request.setAttribute("countpage", countPage);
		request.getRequestDispatcher("/manager/admin/adminList.jsp").forward(
				request, response);
	}

	// 用户登录操作
	public void login(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 获取用户登录操作的信息
		String name = getValue(request, "name");
		String pass = getValue(request, "pass");
		System.out.println(name + "==" + pass);
		// 调用业务方法
		// dao对象去调用响应的操作
		Admin admin = null;
		try {
			admin = adminDao.checkLogin(name, pass);
		} catch (Exception e) {

			e.printStackTrace();
		}
		// 判断
		if (admin != null) {
			// 把admin对象储存
			request.getSession().setAttribute("name", admin.getName());
			// 转发成功页面
			request.getRequestDispatcher("/manager/main.jsp").forward(request,
					response);
		} else {
			request.setAttribute("msg", "用户名或者密码错误，请重新登录");
			// 转发登录界面
			request.getRequestDispatcher("WEB-INF/login.jsp").forward(request,
					response);
			;
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doGet(request, response);
	}

	/**
	 * 获取参数指定的值
	 * 
	 * @param request
	 * @param name
	 * @return
	 */
	public String getValue(HttpServletRequest request, String name) {
		return request.getParameter(name);
	}
}

WebRoot/manager

index.jsp

<%@ 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 HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <title>My JSP 'index.jsp' starting page</title>
  </head>
  
  <body>
    路径:<%=basePath%><a href="./default.do">登录界面</a>
  </body>
</html>
WebRoot/WEB-INF

login.jsp

<%@ 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 HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'login.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

</head>

<body>
	<div style="text-align: center;">
		<form action="./adminLogin.do" method="post">
			用户名:<input type="text" name="name" /></br> 密码：<input type="password"
				name="pass" /></br> <input type="reset" value="重置" />
			           <input
				type="submit" value="登录" /> <input type="hidden" name="oper"
				value="login" />
		</form>
	</div>
	<div>
		<%
			String msg = (String) request.getAttribute("msg");
			if (msg != null) {
		%>
		<%=msg%>
		<%
			} else {
		%>
		<h5>没有提示操作！</h5>
		<%
			}
		%>
	</div>
</body>
</html>

WebRoot/manager

main.jsp

<%@ 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 HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'main.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

</head>
<frameset border="1px" rows=10%,*,10%>
	<frame noresize="noresize" src="./manager/top.jsp">
	<frameset cols="10%,*,">
		<frame noresize="noresize" src="./manager/left.jsp">
		<frame noresize="noresize" name="m" src="./manager/rigth.jsp">
	</frameset>
	<frame noresize="noresize" src="./manager/botton.jsp">
</frameset>
</html>

left.jsp 

<%@ 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 HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'left.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  
  <body bgcolor="lavender">
  
     <div align="center">
        <a href="./adminList.do?oper=list" target="m">管理员管理</a><br/><br/><br/>
        <a href="#">新闻类型管理</a><br/><br/><br/>
        <a href="#">新闻管理</a>
       
     </div>
   
  </body>
</html>

AdminServlet.java 

package www.csdn.net.news.servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import www.csdn.net.news.dao.AdminDao;
import www.csdn.net.news.domain.Admin;
import www.csdn.net.news.impl.AdminDaoImpl;

public class AdminServlet extends HttpServlet {
	// 声明dao操作对象
	private AdminDao adminDao = new AdminDaoImpl();

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 设置编码问题
		request.setCharacterEncoding("UTF-8");
		// 获取操作的标识符
		String oper = request.getParameter("oper");
		// 判断是否是登录操作
		if ("login".equals(oper)) {
			login(request, response);
		}

		if ("list".equals(oper)) {
			list(request, response);
		}
		if ("findById".equals(oper)) {
			findById(request, response);
		}
		if ("update".equals(oper)) {
			update(request, response);
		}
		if ("add".equals(oper)) {
			add(request, response);
		}
		if ("deletes".equals(oper)) {
			deletes(request, response);
		}
		if ("deleteById".equals(oper)) {
			deleteById(request, response);
		}
	}
	public void deleteById(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
			String id=request.getParameter("id");
			
			try{
				adminDao.deleteById(Integer.parseInt(id));
			}catch(Exception e){
				request.setAttribute("msg","用户操作失败");
				e.printStackTrace();
			}
			
			// 转发给查询所有的操作
			request.getRequestDispatcher("./adminList.do?oper=list").forward(
					request, response);

	}
	public void deletes(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		String ids = request.getParameter("ids");
		System.out.println(ids + "----");
		String arrs[] = ids.split(",");
		Integer idarrs[] = new Integer[arrs.length];
		try {
			for (int i = 0; i < arrs.length; i++) {
				String arr = arrs[i];
				idarrs[i] = Integer.parseInt(arr);
			}
			adminDao.deletes(idarrs);
		} catch (Exception e) {
			e.printStackTrace();
		}

		// 转发给查询所有的操作
		request.getRequestDispatcher("./adminList.do?oper=list").forward(
				request, response);

	}

	public void add(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		// 获取更新数据
		String name = request.getParameter("name");
		String pass = request.getParameter("pass");

		Admin entity = new Admin();
		try {
			// 查询实体
			entity.setName(name);
			// 更新属性值
			entity.setPass(pass);
			// 更新
			adminDao.update(entity);
			// 转发给查询所有的操作
			request.getRequestDispatcher("./adminList.do?oper=list").forward(
					request, response);
		} catch (Exception e) {
			request.setAttribute("msg", "添加用户失败");
			// 转发到添加的页面
			request.getRequestDispatcher("./manager/admin/insertAdmin.jsp")
					.forward(request, response);
			e.printStackTrace();
		}

	}

	public void update(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		// 获取更新数据
		String id = request.getParameter("id");
		String name = request.getParameter("name");

		System.out.println("id:::" + id + "::::name" + name);

		Admin entity = null;
		try {
			// 查询实体
			entity = adminDao.findById(Integer.parseInt(id));
			// 更新属性值
			entity.setName(name);
			// 更新
			adminDao.update(entity);
		} catch (Exception e) {
			e.printStackTrace();
		}
		// 转发给查询所有的操作
		request.getRequestDispatcher("./adminList.do?oper=list").forward(
				request, response);

	}

	public void findById(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		String id = request.getParameter("id");
		Admin entity = null;
		try {
			entity = adminDao.findById(Integer.parseInt(id));
		} catch (NumberFormatException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		request.setAttribute("entity", entity);
		request.getRequestDispatcher("./manager/admin/updateAdmin.jsp")
				.forward(request, response);
	}

	public void list(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
	    String npage= request.getParameter("nowpage");
		int nowpage=1;
		int countPage=0;
		if(npage!=null){
			nowpage=Integer.parseInt(npage);
		}
		// 查询所有
		List<Admin> entities = null;
		try {
			entities = adminDao.findNowPageInfo(nowpage);
			 countPage=adminDao.getCountPage();
		} catch (Exception e) {
			e.printStackTrace();
		}
		request.setAttribute("entities", entities);
		request.setAttribute("nowpage", nowpage);
		request.setAttribute("countpage", countPage);
		request.getRequestDispatcher("/manager/admin/adminList.jsp").forward(
				request, response);
	}

	// 用户登录操作
	public void login(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 获取用户登录操作的信息
		String name = getValue(request, "name");
		String pass = getValue(request, "pass");
		System.out.println(name + "==" + pass);
		// 调用业务方法
		// dao对象去调用响应的操作
		Admin admin = null;
		try {
			admin = adminDao.checkLogin(name, pass);
		} catch (Exception e) {

			e.printStackTrace();
		}
		// 判断
		if (admin != null) {
			// 把admin对象储存
			request.getSession().setAttribute("name", admin.getName());
			// 转发成功页面
			request.getRequestDispatcher("/manager/main.jsp").forward(request,
					response);
		} else {
			request.setAttribute("msg", "用户名或者密码错误，请重新登录");
			// 转发登录界面
			request.getRequestDispatcher("WEB-INF/login.jsp").forward(request,
					response);
			;
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doGet(request, response);
	}

	/**
	 * 获取参数指定的值
	 * 
	 * @param request
	 * @param name
	 * @return
	 */
	public String getValue(HttpServletRequest request, String name) {
		return request.getParameter(name);
	}
}

WebRoot/manager/admin

adminList.jsp

<%@ page language="java"
	import="java.util.*,www.csdn.net.news.domain.Admin"
	pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
	+ request.getServerName() + ":" + request.getServerPort()
	+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'adminList.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
<script type="text/javascript">
	//当窗体加载完毕后触发函数
	window.onload = function() {

		var cbk = document.getElementById("cbk");
		//触发函数
		cbk.onclick = clickCheckbox;

	}
	//全选或全取消
	function clickCheckbox() {
		var cbks = document.getElementsByName("cbks");
		if (this.checked) {
			for (var i = 0; i < cbks.length; i++) {
				var cbktemp = cbks[i];
				if (!cbktemp.checked) {
					cbktemp.checked = true;
				}
			}
		} else {
			for (var i = 0; i < cbks.length; i++) {
				var cbktemp = cbks[i];
				if (cbktemp.checked) {
					cbktemp.checked = false;
				}
			}
		}

	}
	function deletes() {
		var cbks = document.getElementsByName("cbks");
		var temp = "";
		for (var i = 0; i < cbks.length; i++) {
			var cbktemp = cbks[i];
			if (cbktemp.checked) {
				temp += cbktemp.value + ",";
			}
		}
		//发送请求到web器
		window.location.href = "./deletesAdmin.do?ids=" + temp
				+ "&oper=deletes";
	}
</script>
</head>

<body>
	<div align="center">
		<div>
			<a href="./manager/admin/insertAdmin.jsp" target="m">添加</a> <a
				href="javascript:deletes()">删除所选项</a>
		</div>

		<div>
			<%
				String msg = (String) request.getAttribute("msg");
				if (msg != null) {
			%>
			<%=msg%>
			<%
				}
			%>
		</div>

		<div>
			<%
				List<Admin> entities = (List<Admin>) request
						.getAttribute("entities");
			%>
			<table border="1px" cellpadding="0" cellspacing="0">
				<thead>
					<th><input id="cbk" type="checkbox"></th>
					<th>序号</th>
					<th>姓名</th>
					<th>密码</th>
					<th>操作</th>
				</thead>
				<tbody>
					<%
						for (Admin entity : entities) {
					%>
					<tr>
						<td><input name="cbks" type="checkbox"
							value="<%=entity.getId()%>" /></td>
						<td><%=entity.getId()%></td>
						<td><%=entity.getName()%></td>
						<td><%=entity.getPass()%></td>
						<td><a
							href="./findByIdAdmin.do?oper=findById&id=<%=entity.getId()%>"
							target="m">编辑</a> | <a
							href="./deleteAdmin.do?oper=deleteById&id=<%=entity.getId()%>">删除</a></td>
					</tr>
					<%
						}
					%>
					<tr>
						<td colspan="5" align="center"><a
							href="./adminList.do?oper=list&nowpage=1">首页</a> <a
							href="./adminList.do?oper=list&nowpage=<%=(Integer) request.getAttribute("nowpage") - 1 <= 1 ? 1
					: (Integer) request.getAttribute("nowpage") - 1%>">上一页</a>
							<a
							href="./adminList.do?oper=list&nowpage=<%=(Integer) request.getAttribute("nowpage") + 1 >= (Integer) request
					.getAttribute("countpage") ? (Integer) request
					.getAttribute("countpage") : (Integer) request
					.getAttribute("nowpage") + 1%>">下一页</a>
							<a
							href="./adminList.do?oper=list&nowpage=<%=(Integer) request.getAttribute("countpage")%>">末页</a>
						</td>
					</tr>
				</tbody>
			</table>
		</div>
	</div>
</body>
</html>

insertAdmin.jsp 

<%@ 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 HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'insertAdmin.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

</head>

<body>
	<div align="center">
		<div>
			<%
				String msg = (String) request.getAttribute("msg");
				if (msg != null) {
			%>
			<%=msg%>
			<%
				}
			%>
		</div>
		<h3>用户加添界面</h3>
		<form action="./addAdmin.do" method="post">
			<table>
				<tr>
					<td>名称：</td>
					<td><input type="text" name="name"></td>
					<td><input type="button" value="检查用户"></td>
				</tr>
				<tr>
					<td>密码:</td>
					<td colspan="2"><input type="password" name="pass"></td>
				</tr>
				<tr>
					<td colspan="3" align="center"><input type="reset" value="重置" />
						<input type="submit" value="添加" /> <input type="hidden"
						value="add" name="oper"></td>
				</tr>
			</table>
		</form>
	</div>
</body>
</html>

updateAdmin.jsp 

<%@ page language="java"
	import="java.util.*,www.csdn.net.news.domain.Admin"
	pageEncoding="UTF-8"%>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'updateAdmin.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

</head>

<body>
	<div align="center">
		<%
			Admin entity = (Admin) request.getAttribute("entity");
		%>
		<form action="./updateAdmin.do" method="post">
			序号：<input type="text" disabled="disabled"
				value="<%=entity.getId()%>" /><br /> 用户名:<input type="text"
				name="name" value="<%=entity.getName()%>" /><br /> <input
				type="hidden" name="oper" value="update" /> <input type="hidden"
				name="id" value="<%=entity.getId()%>" /><br /> <input
				type="submit" value="更新" />
		</form>

	</div>
</body>
</html>

src/db.properties 

url=jdbc\:mysql\://localhost\:3306/news?useUnicode\=true&characterEncoding\=UTF-8
user=root
pass=root
driverClassName=com.mysql.jdbc.Driver


展开阅读全文
还能输入1000个字符

NEWS

09-12

- 论坛

<%#news%>和<%=news%>的区别

12-06

简单变量的数据绑定，书上写的是<%#news%>形式，可这样写的话，数据出不来，是空白的rn而用<%=news%>就可以出来结果，这是什么绑定？这两个有什么区别啊？ 论坛

3S News\3S News part4

04-21
3s新闻周刊（全）。由于受上传文件大小的限制，分四部分上传。造成不便，敬请见谅。该部分为第22期。
下载

asp.net news

09-16
一个基于asp.net+sql Server 的新闻发布系统， 数据库连接在配置文件和\app_code\sql.cs 里修改
下载

News数据库

10-30
News数据库,开发事例,用于平时的学习,希望能提供给大家帮助
下载

Corona News

02-23
Corona News
下载

News website

08-26
news website for every body
下载

news System

09-05
一款自己开发出来的软件，包含了jsp的大量主要知识
下载

the trigger news

11-12

这周六（15日） 中午11点，央视5台 《电子竞技世界》栏目， 播出<>游戏介绍的栏目，一定要看啊！rn 论坛

news新闻发布系统

07-28
随着计算机科学的发展，数据库技术在Internet中的应用越来越广泛，为广大网络用户提供了更加周到和人性化的服务。个性化已逐渐成为当今Web应用的潮流。利用JSP技术开发的网站新闻管理系统，实现了网站新闻的动态管理，因为可以用来动态发布新...
下载

Trending News

11-10
[Trending News] - 最佳科技新聞應用，專為手機和平板進行優化的用戶界面.
下载

News media

12-13
News media
下载

新闻客户端News

05-24 阅读数 220

AsyncHttpClient和SmartImageView的使用 博文 来自： ClaireElva的博客

News Everywhere

03-16
News Everywhere使用SDI库(我写的一个用于声音显示的库，晚些时候也会在CSDN上发布，现在正在整理中)，主要功能是从新闻网站上下载数据并用IBM ViaVoice TTS转换成语音，然后用A3D进行3D定位，同时输出新闻标...
下载

news 新闻发布系统

06-06
这是一款 新闻发布系统的 源码， 附加毕业论文。附加数据库。
下载

软件技术news

12-13
适合中小型的企业,和管理方面的公司管理和使用.
下载

news资源

09-20
news 代码news 代码news 代码
下载

新闻发布系统news

08-28
新闻发布系统 news 用java做的新闻发布系统
下载

news网页设计

10-25
画面简洁！画面简洁！画面简洁！画面简洁！画面简洁！画面简洁！画面简洁！画面简洁！
下载

good news

07-12

heard from friends:rnrnMicrosoft would provide more investments at unmanage development Communityrnrnproduct developer and PSS engineer will provide free online support services. 论坛

最新news!!!

06-16

delphi数据库搜索组件 最新信息！！！ [Delphi]rndelphi 数据库搜索组件包1.3 最新版本 rn可在http://www.csdn.net/cnshare/soft/5/5712.html 下载rn注册只要118rn这个版本可以试用58次，注册在rnhttp://www.shareware.net.cn/shareware_view.asp?id=18D304AF-DF03-44DE-82F7-389445544936rn它很好,很好用rn它能帮助您做数据库应用程序!而且很方便易用!!! 论坛

NewsApp源码

11-11
这个是用于网络解析一个新闻接口的安卓小项目，但只写到ListView中显示
下载

FLASH NEWS

03-30
FLASH+XML图片滚动新闻 NEWS！
下载

blockchain news

12-07
this is blockchain related news, for reference only
下载

北大青鸟News项目

06-17
北大青鸟News项目北大青鸟News项目北大青鸟News项目北大青鸟News项目
下载

fake news dataset

10-18
data set for fake news, so this is to download the pdf file i have got from your website.
下载

ZT News iii

04-04
大家好，这是一个JOOMLA php网站建设当中的一个有用的ZT News iii组件。
下载

news 新闻发布系统源码

11-04
新闻发布系统源码 界面简单清洁，很适合初学者学习。 功能： 具备新闻发布系统的基本核心功能 有添加新闻，生成静态页。 还有用户管理。
下载

jsp项目BBS/news

06-25
用jsp做的，news和BBS！恢复速度丰厚的返回的是
下载

课堂项目news

09-23
学生课堂项目，9月23日完成（作者：xs922）.仅供参考
下载

CNN student news

08-05
CNN news including social issues,entertainment,daily life and so on.
下载

软件测试考试内容NEWS

12-26
一：收费系统 1收费项目 2收费类别 3收费单 4根据类别和时间段统计报表 前三项黑盒测试，后一项白盒测试 二：学生成绩管理系统 内容： 1. 选课信息 2. 课程信息 3. 学生信息 4. 学生成绩录入 要求：1.根据分数段进行查询人数...
下载

Google News优化技巧

09-01 阅读数 95

GoogleNews以机器算法自动聚合新闻内容而著名，尽管它还不完美。但可以肯定的是，无论你的新闻网站是什么类型，一旦被GoogleNews选为新闻源，那么它将会给你的网站带去非常可观的流量及新用户。... 博文 来自： Just Code

symfony php news

11-16
框架编写的php实例
下载

Java-新闻news案例

09-14 阅读数 644

一共有三个类News，NewsService,NewsTest/***新闻,实体类，javabean,pojo,domain对象*@authorAdministrator*/publicclassNe... 博文 来自： sun_smile1的博客

news新闻网站（前台）

01-27
期末考试做的大作业，无错误，供大家参考。
下载

项目实战:news网页

10-11 阅读数 80

下载bootstraphttps://getbootstrap.com/docs/4.1/getting-started/download/解压到本地目录：-css：bootstrap.min.css... 博文 来自： weixin_42635252的博客

news://是什么协议？

02-28

除了Windows Mail能打开还有什么软件能打开？在线的有吗？Google产品里有吗？ 论坛

INSERT INTO `news` SELECT * FROM `news`，news中含有唯一索引的ID字段时，怎么办？

12-25

INSERT INTO `news` SELECT * FROM `news`，news中含有唯一索引的ID字段时，怎么办？ 论坛

news 2015图册

05-08
news 2015年 最新图册，适用于LED灯具行业
下载

wForm news reader

04-28
新闻阅读器 添加新闻信息 tree显示 二级tree
下载

学籍管理系统(news)

05-10
.net框架下用C#语言写的一个小例子.....希望大家参考后能把你认为的bug通过邮件发给我,谢谢!
下载

Java Study News

04-15
the new documents for Java study, private for the uploader.
下载

新闻发布系统News源码

05-23
一个比较简单的新闻发布系统,适合于初学者学习。
下载

News新闻系统学习

01-01
News新闻系统学习，这是我做的一个新闻学习系统，分享给大家。
下载

3S News part3

04-21
3s新闻周刊（全）。由于受上传文件大小的限制，分四部分上传。造成不便，敬请见谅。该部分为17-21期。
下载

delphi db program news !!!

06-12

delphi数据库搜索组件 最新信息！！！ [Delphi]rndelphi 数据库搜索组件包1.3 最新版本 rn可在http://www.csdn.net/cnshare/soft/5/5712.html 下载rn注册只要118元人民币rn这个版本可以试用58次，注册在rnhttp://www.shareware.net.cn/shareware_view.asp?id=18D304AF-DF03-44DE-82F7-389445544936rnrn 论坛

news信息发布系统

05-17
articles mediumint 8 0 -1 0 0 0 0 -1 0 0
下载

news 半成 新闻管理系统

06-27
php祸胎程序开发,php网站建设,新手练习,新闻系统,网站开发,半成
下载

10.发送消息_news消息

02-16

"微信公众平台企业号开发Java版"系列课程，采用java语言细致、详尽、全面地讲解微信企业号开发的相关知识点。该套课程，在"微信公众平台深度开发Java版v2.0"的基础上，对企业号开发的“回调模式”、“主动调用模式”、“JSAPI模式”分类讲解。贯彻“简单、高效、快捷”的课程特色，采用“一课两知识点”的课程进度，保证课程质量的同时，尽可能的压缩课程时间，让学员“以短的时间，学到多的知识”。课程的知识点包括：建立连接；接收消息与响应消息；被动响应消息；接收事件（菜单事件、关注/取消关注事件、坐标事件、异步任务完成事件）；发送消息（消息推送）；自定义菜单；OAuth验证；Userid与openid互换；微信JS-SDK接口（重点）；企业会话服务（重点）；基础样式库（重点）；企业号登录授权（重点），等知识点。rn以及，针对微信公众号开发的服务端架构设计方案。课程以微信公众号开发视角，讲解JAVA开发微信公众号所需的框架、第三方工具。 rn购买套餐还赠送经典微信开发课程——[微信公众号_独立知识点]环境搭建。该课程针对各种复杂的网络环境，讲解如何构建开发环境，已解决“没有服务器”、“没有固定IP”等开发者遇到的窘境。 rn详情 qq2326321088

没有更多推荐了，返回首页