一个未完成的java项目

最新推荐文章于 2024-09-25 10:59:43 发布

lilimu996

最新推荐文章于 2024-09-25 10:59:43 发布

阅读量119

点赞数

文章标签： java

本文链接：https://blog.csdn.net/lilililimu/article/details/115709786

版权

本文档展示了使用Java进行Web应用程序中管理员数据的CRUD操作。包括实体类`Manager`的定义，数据库连接管理，DAO接口及其实现，服务层接口及其实现，以及控制器`ManagerController`的Servlet实现。代码涵盖了从数据库查询所有管理员，添加、删除、修改管理员信息，以及根据账号密码和ID查找管理员的方法。

摘要由CSDN通过智能技术生成

1.实体类entity

package com.etc.entity;
/*管理员实体类*/
public class Manager {
	private int id;//管理员编号
	private String name;//管理员账户
	private String pwd;//管理员密码
	
	public Manager() {
		super();
		
	}
	
	public Manager(int id, String name, String pwd) {
		super();
		this.id = id;
		this.name = name;
		this.pwd = pwd;
	}
	
	//属性访问器
	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getPwd() {
		return pwd;
	}

	public void setPwd(String pwd) {
		this.pwd = pwd;
	}

	@Override
	public String toString() {
		return "Manager [id=" + id + ", name=" + name + ", pwd=" + pwd + "]";
	}
	
	
	
	
	

}

2.数据库连接util

package com.etc.util;

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

/**数据库访问基础类*/
public class BaseDao {
	//数据库访问连接字符串
	public String url = "jdbc:mysql://localhost:3306/mydatebase?user=root&password=admin";
	/**获得数据库连接*/
	public Connection getConnection() {
		Connection conn =null;//数据库连接对象
		try {
			// 1.加载驱动
			Class.forName("com.mysql.jdbc.Driver");
			// 2.建立连接
			conn = DriverManager.getConnection(url);
			} catch (Exception e) {
				e.printStackTrace();
			}
			return conn;
		}
	
	
	/** 释放资源 */
	public void closeAll(ResultSet rs, PreparedStatement ps, Connection conn) {
		try {
			if (rs != null) {
				rs.close();
			}
			if (ps != null) {
				ps.close();
			}
			if (conn != null) {
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	/**增删改查方法*/
	public int execute(String sql, Object... args) {
		int result = -1;
		Connection conn = null;
		PreparedStatement ps = null;
		try {
			conn = this.getConnection();
			ps = conn.prepareStatement(sql);
			if (args != null) {
				for (int i = 0; i < args.length; i++) {
					ps.setObject(i + 1, args[i]);
				}
			}
			result = ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} 
		return result;
	}


}

3.数据访问层dao

package com.etc.dao;

import java.util.List;

import com.etc.entity.Manager;

public interface ManagerDao {
	/**查询全部管理员*/
	List<Manager> listManager();
	
	/**添加管理员*/
	int addManager(Manager manager);
	
	/**删除管理员*/
	int deleteManager(int id);
	
	/**修改管理员*/
	int modifyManager(Manager manager);
	
	/**根据账号密码加载管理员信息*/
	Manager loadManager(Manager manager);
	
	/**根据id查询管理员*/
	Manager queryManagerById(int id);
	

}

4.数据访问层实现类daoimpl

package com.etc.dao.impl;

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

import com.etc.dao.ManagerDao;
import com.etc.entity.Manager;
import com.etc.util.BaseDao;

/**管理员信息数据访问实现类*/
public class ManagerDaoImpl extends BaseDao implements ManagerDao{

	@Override
	public List<Manager> listManager() {
		List<Manager> list = new ArrayList<Manager>();
		String sql="SELECT * FROM wh_manager";
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs=null;
		try {
			conn=this.getConnection();
			ps=conn.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()) {
				Manager manager=new Manager(rs.getInt("id"),rs.getString("name"),rs.getString("pwd"));
				list.add(manager);
				manager=null;
			}
		}catch(Exception e) {
				e.printStackTrace();
		}
		
		return list;
	}

	@Override
	public int addManager(Manager manager) {
		String sql="INSERT into wh_manager(name,pwd) value(?,?)";
		Object[] args= {manager.getName(),manager.getPwd()};
		return this.execute(sql, args);
	}

	@Override
	public int deleteManager(int id) {
		String sql="DELETE FROM wh_manager WHERE id=?";
		Object[] args= {id};
		return this.execute(sql, args);
	}

	@Override
	public int modifyManager(Manager manager) {
		String sql="UPDATE wh_manager SET name=?,pwd=? WHERE id=?";
		Object[] args= {manager.getName(),manager.getPwd()};
		return this.execute(sql,args);
	}

	@Override
	public Manager loadManager(Manager manager) {
		Manager m=null;
		String sql = "SELECT * FROM wh_manager WHERE name=? AND pwd=?";
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = this.getConnection();
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			if(rs.next()) {
				m = new Manager(rs.getInt("id"), rs.getString("name"), rs.getString("pwd"));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return m;
	}

	@Override
	public Manager queryManagerById(int id) {
		 Manager m=null;
		String sql = "SELECT * FROM wh_manager WHERE id=?";
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = this.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setInt(1, id);
			rs = ps.executeQuery();
			if(rs.next()) {
				m = new Manager(rs.getInt("id"), rs.getString("name"), rs.getString("pwd"));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return m;
	}

}

5.服务层service

package com.etc.service;

import java.util.List;

import com.etc.entity.Manager;

public interface ManagerService {
	/**查询全部管理员*/
	List<Manager> listManager();
	
	/**添加管理员*/
	int addManager(Manager manager);
	
	/**删除管理员*/
	int deleteManager(int id);
	
	/**修改管理员*/
	int modifyManager(Manager manager);
	
	/**根据账号密码加载管理员信息*/
	Manager loadManager(Manager manager);
	
	/**根据id查询管理员*/
	Manager queryManagerById(int id);
}

6.服务层实现类serviceimpl

package com.etc.service.impl;

import java.util.List;

import com.etc.dao.ManagerDao;
import com.etc.dao.impl.ManagerDaoImpl;
import com.etc.entity.Manager;
import com.etc.service.ManagerService;

public class ManagerServiceImpl implements ManagerService {
	ManagerDao md=new ManagerDaoImpl();
	@Override
	public List<Manager> listManager() {
		
		return md.listManager();
	}

	@Override
	public int addManager(Manager manager) {
		// TODO Auto-generated method stub
		return md.addManager(manager);
	}

	@Override
	public int deleteManager(int id) {
		// TODO Auto-generated method stub
		return md.deleteManager(id);
	}

	@Override
	public int modifyManager(Manager manager) {
		// TODO Auto-generated method stub
		return md.modifyManager(manager);
	}

	@Override
	public Manager loadManager(Manager manager) {
		// TODO Auto-generated method stub
		return md.loadManager(manager);
	}

	@Override
	public Manager queryManagerById(int id) {
		// TODO Auto-generated method stub
		return md.queryManagerById(id);
	}

}

7.控制层controller

package com.etc.controller;

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

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

import com.etc.entity.Manager;
import com.etc.service.ManagerService;
import com.etc.service.impl.ManagerServiceImpl;

/**
 * Servlet implementation class ManagerController
 */
@WebServlet("/mg")
public class ManagerController extends HttpServlet {
	private static final long serialVersionUID = 1L;

    /**
     * Default constructor. 
     */
    public ManagerController() {
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		ManagerService ms=new ManagerServiceImpl();
		List<Manager> list=ms.listManager();
		request.setAttribute("managerlist",list);
		request.getRequestDispatcher("NewFile.jsp").forward(request,response);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

8.jsp页面

<%@page import="com.etc.entity.Manager"%>
<%@page import="java.util.List" %>


<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>前端测试页面one</title>
</head>
<body>
	<h1>
	4444nwnwnwnwnw
	</h1>
	<%
		List<Manager> list=(List<Manager>)request.getAttribute("managerlist");
	%>
</body>
</html>