实体bean-Admin.java
AdminDaoImpl.java
DefaultServlet.java
AdminSerlet.java
WebRoot/manager
WebRoot/manager
left.jsp
AdminServlet.java
WebRoot/manager/admin
insertAdmin.jsp
updateAdmin.jsp
src/db.properties
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