【SSH】：基于Struts2+HIbernate3+Spring3实现员工管理系统之案例实现篇（下）

最新推荐文章于 2018-05-31 21:23:50 发布

life is wonderful

最新推荐文章于 2018-05-31 21:23:50 发布

阅读量5.4k

点赞数 6

分类专栏： SSH SSH框架学习之路文章标签： struts hibernate 框架学习 spring ssh

本文链接：https://blog.csdn.net/erlian1992/article/details/54376717

版权

SSH框架学习之路同时被 2 个专栏收录

47 篇文章 29 订阅

订阅专栏

SSH

8 篇文章 0 订阅

订阅专栏

还是接着上一篇继续。

web层实现

1、web.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
  <display-name>ssh_employee</display-name>
  
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  
  <filter>
    <filter-name>openSessionInViewFilter</filter-name>
    <filter-class>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>openSessionInViewFilter</filter-name>
    <url-pattern>*.action</url-pattern>
  </filter-mapping>
  
  <filter>
    <filter-name>struts2</filter-name>
    <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>struts2</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
  </context-param>
  
</web-app>

2、Action

DepartmentAction类

package com.employee.action;

import com.employee.domain.Department;
import com.employee.domain.PageBean;
import com.employee.service.DepartmentService;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;

/**
 * 部门action
 * @author Administrator
 * @date 2016年12月24日
 */
@SuppressWarnings("serial")
public class DepartmentAction extends ActionSupport implements ModelDriven<Department>{
	
	//struts结合spring自动注入的department
	private Department department = new Department();
	
	public Department getModel() {
		return department;
	}
	
	//spring注入departmentService
	private DepartmentService departmentService;
	
	public void setDepartmentService(DepartmentService departmentService) {
		this.departmentService = departmentService;
	}
	
	//接收当前页面的值
	private int currentPage = 1;
	
	public void setCurrentPage(int currentPage) {
		this.currentPage = currentPage;
	}
	
	//分页查询部门
	public String findAll(){
		PageBean<Department> pageBean = departmentService.findByPage(currentPage);
		//将pageBean存入到值栈中
		ActionContext.getContext().getValueStack().push(pageBean);
		return "findAll";
	}
	
	//通过action返回添加部门的视图
	public String saveUI(){
		return "saveUI";
	}
	
	/**
	 * 保存部门
	 * @return
	 */
	//添加部门的save方法
	public String save(){
		departmentService.save(department);
		return "saveSuccess";
	}
	
	/**
	 * 根据ID查询部门
	 * @return
	 */
	public String editById(){
		department = departmentService.editById(department.getDid());
		return "editSuccess";
	}
	
	/**
	 * 修改部门
	 * @return
	 */
	public String update(){
		departmentService.update(department);
		return "updateSuccess";
	}
	
	/**
	 * 删除部门
	 * @return
	 */
	public String delete(){
		Department dep = departmentService.editById(department.getDid());
		departmentService.delete(dep);
		return "deleteSuccess";
	}
	
}

EmployeeAction类

package com.employee.action;

import java.util.List;

import com.employee.domain.Department;
import com.employee.domain.Employee;
import com.employee.domain.PageBean;
import com.employee.service.DepartmentService;
import com.employee.service.EmployeeService;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;

/**
 * 员工管理的Action类
 * @author Administrator
 * @date 2016年12月24日
 */
@SuppressWarnings("serial")
public class EmployeeAction extends ActionSupport implements ModelDriven<Employee>{
	
	//是struts与spring融合后自动注入的
	private Employee employee = new Employee();
		
	@Override
	public Employee getModel() {
		return employee;
	}
	
	//使用spring将service注入
	private EmployeeService employeeService;
	
	public void setEmployeeService(EmployeeService employeeService) {
		this.employeeService = employeeService;
	}
	
	//spring注入部门管理的service
	private DepartmentService departmentService;
	
	public void setDepartmentService(DepartmentService departmentService) {
		this.departmentService = departmentService;
	}
	
	//获取当前页
	private int currentPage=1;
	
	public void setCurrentPage(int currentPage) {
		this.currentPage = currentPage;
	}
	
	/**
	 * 登录执行的方法
	 * @return
	 */
	public String login(){
		//调用业务层的类
		Employee exsitEmploy = employeeService.findUserExist(employee);
		if(exsitEmploy == null){
			//登录失败
			this.addActionError("用户名或者密码错误！");
			return INPUT;
		}else{
			//登录成功
			//把用户信息保存在Session域中
			ActionContext.getContext().getSession().put("exsitEmploy",exsitEmploy);
			return SUCCESS;
		}
	}
	
	/**
	 * 分页查询员工
	 * @return
	 */
	public String findAll(){
		PageBean<Employee> pageBean = employeeService.findAll(currentPage);
		ActionContext.getContext().getValueStack().push(pageBean);
		return "findAll";
	}
	
	/**
	 * 跳转到添加员工页面
	 * @return
	 */
	public String saveUI(){
		//用于查询出所有的部门信息
		List<Department> list = departmentService.findAll();
		//保存到值栈中
		ActionContext.getContext().getValueStack().set("list",list);
		return "saveUI";
	}
	
	/**
	 * 保存员工
	 * @return
	 */
	public String save(){
		employeeService.save(employee);
		return "saveSuccess";
	}
	
	/**
	 * 编辑员工
	 * @return
	 */
	public String edit(){
		employee = employeeService.edit(employee.getEid());
		List<Department> list = departmentService.findAll();
		ActionContext.getContext().getValueStack().set("list",list);
		return "editSuccess";
	}
	
	/**
	 * 修改员工
	 * @return
	 */
	public String update(){
		employeeService.update(employee);
		return "updateSuccess";
	}
	
	/**
	 * 删除员工
	 * @return
	 */
	public String delete(){
		Employee emp = employeeService.edit(employee.getEid());
		employeeService.delete(emp);
		return "deleteSuccess";
	}

	
}

3、struts.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC 
       "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" 
       "http://struts.apache.org/dtds/struts-2.1.dtd">

<struts>
	<package name="ssh" namespace="/" extends="struts-default">
	
		<action name="employee_*" class="employeeAction" method="{1}">
			<result name="input">/index.jsp</result>
			<result name="success" type="dispatcher">/frame.jsp</result>
			<result name="findAll">/jsp/employee/listEmployee.jsp</result>
			<result name="saveUI">/jsp/employee/addEmployee.jsp</result>
			<result name="saveSuccess" type="redirect">employee_findAll.action</result>
			<result name="editSuccess">/jsp/employee/editEmployee.jsp</result>
			<result name="updateSuccess" type="redirect">employee_findAll.action</result>
			<result name="deleteSuccess" type="redirect">employee_findAll.action</result>
		</action>
		
		<action name="department_*" class="departmentAction" method="{1}">
			<result name="findAll">/jsp/department/listDepartment.jsp</result>
			<result name="saveUI">/jsp/department/addDepartment.jsp</result>
			<result name="saveSuccess" type="redirect">department_findAll.action</result>
			<result name="editSuccess">/jsp/department/editDepartment.jsp</result>
			<result name="updateSuccess" type="redirect">department_findAll.action</result>
			<result name="deleteSuccess" type="redirect">department_findAll.action</result>
		</action>
		
	</package>
	
</struts>

service实现

1、接口

DepartmentService.java

package com.employee.service;

import java.util.List;

import com.employee.domain.Department;
import com.employee.domain.PageBean;

/**
 * 部门管理的service接口
 * @author Administrator
 * @date 2016年12月24日
 */
public interface DepartmentService {
	
	PageBean<Department> findByPage(int currentPage);
	
	void save(Department department);
	
	Department editById(Integer did);
	
	void update(Department department);
	
	void delete(Department department);
	
	List<Department> findAll();
	
}

EmployeeService.java

package com.employee.service;

import com.employee.domain.Employee;
import com.employee.domain.PageBean;

/**
 * 员工管理的service接口
 * @author Administrator
 * @date 2016年12月24日
 */
public interface EmployeeService {
	
	Employee findUserExist(Employee employee);
	
	PageBean<Employee> findAll(int currentPage);
	
	void save(Employee employee);
	
	Employee edit(Integer eid);
	
	void update(Employee employee);

	void delete(Employee employee); 

}

2、实现类

DepartmentServiceImpl.java

package com.employee.service.impl;

import java.util.List;

import org.springframework.transaction.annotation.Transactional;

import com.employee.dao.DepartmentDao;
import com.employee.domain.Department;
import com.employee.domain.PageBean;
import com.employee.service.DepartmentService;
import com.opensymphony.xwork2.ActionContext;

/**
 * 部门的service接口的实现类
 * @author Administrator
 * @date 2016年12月24日
 */
@Transactional
public class DepartmentServiceImpl implements DepartmentService {
	
	//spring注入部门的departmentDaoImpl
	private DepartmentDao departmentDao;
	
	public void setDepartmentDao(DepartmentDao departmentDao) {
		this.departmentDao = departmentDao;
	}
	
	/**
	 * 分页查询部门方法
	 */
	@Override
	public PageBean<Department> findByPage(int currentPage) {
		PageBean<Department> pageBean = new PageBean<Department>();
		//封装当前页数
		pageBean.setCurrentPage(currentPage);
		//封装每页显示记录数
		int pageCount = 3;
		pageBean.setPageCount(pageCount);
		//封装总记录数
		int totalSize = departmentDao.findCount();
		pageBean.setTotalSize(totalSize);
		//封装总页数
		double ts = totalSize;
		Double num = Math.ceil(ts /  pageCount);
		pageBean.setPageSize(num.intValue());
		//封装每页显示的数据
		int begin = (currentPage - 1) * pageCount;
		List<Department> list = departmentDao.findByPage(begin,pageCount);
		pageBean.setList(list);
		ActionContext.getContext().put("list", list);
		return pageBean;
	}
	
	/**
	 * 保存部门
	 */
	@Override
	public void save(Department department) {
		departmentDao.save(department);
	}
	
	/**
	 * 根据ID查询部门
	 */
	@Override
	public Department editById(Integer did) {
		return departmentDao.editById(did);
	}
	
	/**
	 * 修改部门
	 */
	@Override
	public void update(Department department) {
		departmentDao.update(department);
	}
	
	/**
	 * 删除部门
	 */
	@Override
	public void delete(Department dep) {
		departmentDao.delete(dep);
	}
	
	/**
	 * 查询所有部门
	 */
	@Override
	public List<Department> findAll() {
		return departmentDao.findAll();
	}
	
}

EmployeeServiceImpl.java

package com.employee.service.impl;

import java.util.List;

import org.springframework.transaction.annotation.Transactional;

import com.employee.dao.EmployeeDao;
import com.employee.domain.Employee;
import com.employee.domain.PageBean;
import com.employee.service.EmployeeService;

/**
 * 员工管理的service接口的实现类
 * @author Administrator
 * @date 2016年12月24日
 */
@Transactional
public class EmployeeServiceImpl implements EmployeeService {
	
	//使用spring注入的dao
	private EmployeeDao employeeDao;
	
	public void setEmployeeDao(EmployeeDao employeeDao) {
		this.employeeDao = employeeDao;
	}
	
	/**
	 * 业务层的登录的执行方法
	 * @param employee
	 * @return
	 */
	@Override
	public Employee findUserExist(Employee employee) {
		return employeeDao.findUserExist(employee);
	}
	
	/**
	 * 分页查询员工
	 */
	@Override
	public PageBean<Employee> findAll(int currentPage) {
		PageBean<Employee> pageBean = new PageBean<Employee>();
		// 封装当前页数
		pageBean.setCurrentPage(currentPage);
		// 封装每页显示记录数
		int pageCount = 3;
		pageBean.setPageCount(pageCount);
		// 封装总记录数
		int totalSize = employeeDao.findCount();
		pageBean.setTotalSize(totalSize);
		// 封装总页数
		double ts = totalSize;
		Double num = Math.ceil(ts / pageCount);
		pageBean.setPageSize(num.intValue());
		// 封装每页显示的数据
		int begin = (currentPage - 1) * pageCount;
		// 这个方法用于查找出指定页数中的List<Employee>
		List<Employee> list = employeeDao.findAll(begin,pageCount);
		pageBean.setList(list);
		return pageBean;
	}
	
	/**
	 * 保存员工
	 */
	@Override
	public void save(Employee employee) {
		employeeDao.save(employee);
	}
	
	/**
	 * 编辑员工
	 */
	@Override
	public Employee edit(Integer eid) {
		return employeeDao.edit(eid);
	}
	
	/**
	 * 修改员工
	 */
	@Override
	public void update(Employee employee) {
		employeeDao.update(employee);
	}

	/**
	 * 删除员工
	 */
	@Override
	public void delete(Employee employee) {
		employeeDao.delete(employee);
	}

}

dao层实现

1、接口

DepartmentDao.java

package com.employee.dao;


import java.util.List;


import com.employee.domain.Department;


/**
 * 员工管理的dao接口
 * @author Administrator
 * @date 2016年12月24日
 */
public interface DepartmentDao {
	
	int findCount();
	
	List<Department> findByPage(int begin, int pageSize);
	
	void save(Department department);


    Department editById(Integer did);


	void update(Department department);


	void delete(Department department);


	List<Department> findAll();
	
}

EmployeeDao.java

package com.employee.dao;


import java.util.List;


import com.employee.domain.Employee;


/**
 * 员工管理的dao接口
 * @author Administrator
 * @date 2016年12月24日
 */
public interface EmployeeDao {
	
	Employee findUserExist(Employee employee);
	
	int findCount();
	
	List<Employee> findAll(int begin, int pageSize);


	void save(Employee employee);


	Employee edit(Integer eid);


	void update(Employee employee);


	void delete(Employee employee);


}

2、实现类

DepartmentDaoImpl.java

package com.employee.dao.impl;

import java.util.List;

import org.hibernate.criterion.DetachedCriteria;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.employee.dao.DepartmentDao;
import com.employee.domain.Department;

/**
 * 部门的dao接口的实现类
 * @author Administrator
 * @date 2016年12月24日
 */
public class DepartmentDaoImpl extends HibernateDaoSupport implements DepartmentDao {

	@SuppressWarnings("unchecked")
	@Override
	public int findCount() {
		String hql = "select count(*) from Department";
		List<Long> list = this.getHibernateTemplate().find(hql);
		
		if(list.size()>0){
			return list.get(0).intValue();
		}else{
			return 0;
		}
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<Department> findByPage(int begin, int pageCount) {
		//通过分离标准方法得到数据
		DetachedCriteria criteria = DetachedCriteria.forClass(Department.class);
		List<Department> list = this.getHibernateTemplate().findByCriteria(criteria,begin,pageCount);
		return list;
	}

	/**
	 * 保存部门
	 */
	@Override
	public void save(Department department) {
		this.getHibernateTemplate().save(department);
	}

	/**
	 * 根据ID查询部门
	 */
	@Override
	public Department editById(Integer did) {
		return this.getHibernateTemplate().get(Department.class,did);
	}

	/**
	 * 修改部门
	 */
	@Override
	public void update(Department department) {
		this.getHibernateTemplate().update(department);
	}

	/**
	 * 删除部门
	 */
	@Override
	public void delete(Department department) {
		this.getHibernateTemplate().delete(department);
	}

	/**
	 * 查询所有部门
	 */
	@SuppressWarnings("unchecked")
	@Override
	public List<Department> findAll() {
		String hql = "from Department";
		List<Department> list = this.getHibernateTemplate().find(hql);
		return list;
	}
	
}

EmployeeDaoImpl.java

package com.employee.dao.impl;

import java.util.List;

import org.hibernate.criterion.DetachedCriteria;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.employee.dao.EmployeeDao;
import com.employee.domain.Employee;

/**
 * 员工管理的dao接口的实现类
 * @author Administrator
 * @date 2016年12月24日
 */
public class EmployeeDaoImpl extends HibernateDaoSupport implements EmployeeDao {
	
	/**
	 * 查询用户名和密码是否存在
	 */
	@SuppressWarnings("unchecked")
	@Override
	public Employee findUserExist(Employee employee) {
		String hql = " from Employee where username = ? and password = ?";
		List<Employee> list = this.getHibernateTemplate().find(hql,employee.getUsername(),employee.getPassword());
		
		if(list.size() > 0){
			return list.get(0);
		}
		return null;
	}

	/**
	 * 查询总记录数
	 */
	@SuppressWarnings("unchecked")
	@Override
	public int findCount() {
		String hql = "select count(*) from Employee";
		List<Long> list = this.getHibernateTemplate().find(hql);
		
		if(list.size() > 0){
			return list.get(0).intValue();
		}
		return 0;
	}

	/**
	 * 分页查询员工
	 */
	@SuppressWarnings("unchecked")
	@Override
	public List<Employee> findAll(int begin, int pageCount) {
		DetachedCriteria criteria = DetachedCriteria.forClass(Employee.class);
		List<Employee> list = this.getHibernateTemplate().findByCriteria(criteria, begin, pageCount);
		return list;
	}

	/**
	 * 保存员工
	 */
	@Override
	public void save(Employee employee) {
		this.getHibernateTemplate().save(employee);
	}

	/**
	 * 编辑员工
	 */
	@Override
	public Employee edit(Integer eid) {
		return this.getHibernateTemplate().get(Employee.class, eid);
	}

	/**
	 * 修改员工
	 */
	@Override
	public void update(Employee employee) {
		this.getHibernateTemplate().update(employee);
	}

	/**
	 * 删除员工
	 */
	@Override
	public void delete(Employee employee) {
		this.getHibernateTemplate().delete(employee);
	}

}

配置文件

ApplicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:aop="http://www.springframework.org/schema/aop"
        xmlns:tx="http://www.springframework.org/schema/tx"
        xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd">	
	
	<!-- 引入外部的属性文件 -->
	<context:property-placeholder location="classpath:jdbc.properties"/>
	
	<!-- 配置连接池 -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="${jdbc.driverClass}"></property>
		<property name="jdbcUrl" value="${jdbc.url}"></property>
		<property name="user" value="${jdbc.username}"></property>
		<property name="password" value="${jdbc.password}"></property>
	</bean>
	
	<!-- 配置Hibernate的相关属性 -->
	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<!-- 注入连接池 -->
		<property name="dataSource" ref="dataSource"></property>
		<!-- 加载Hibernate相关属性 -->
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.format_sql">true</prop>
				<prop key="hibernate.hbm2ddl.auto">update</prop>
			</props>
		</property>
		<!-- 加载hibernate中的映射文件 -->
		<property name="mappingResources">
			<list>
				<value>com/employee/domain/Department.hbm.xml</value>
				<value>com/employee/domain/Employee.hbm.xml</value>
			</list>
		</property>
	</bean>
	
	<!-- 配置Action的类 -->
	<bean id="employeeAction" class="com.employee.action.EmployeeAction" scope="prototype">
		<property name="employeeService" ref="employeeService"></property>
		<property name="departmentService" ref="departmentService"></property>
	</bean>
	
	<bean id="departmentAction" class="com.employee.action.DepartmentAction" scope="prototype">
		<property name="departmentService" ref="departmentService"></property>
	</bean>
	
	<!-- 配置业务层的类 -->
	<bean id="employeeService" class="com.employee.service.impl.EmployeeServiceImpl">
		<property name="employeeDao" ref="employeeDao"></property>
	</bean>
	
	<bean id="departmentService" class="com.employee.service.impl.DepartmentServiceImpl">
		<property name="departmentDao" ref="departmentDao"></property>
	</bean>
	
	<!-- 配置DAO的类 -->
	<bean id="employeeDao" class="com.employee.dao.impl.EmployeeDaoImpl">
		<property name="sessionFactory" ref="sessionFactory"></property> 
	</bean>	
	
	<bean id="departmentDao" class="com.employee.dao.impl.DepartmentDaoImpl">
		<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	
	<!-- 配置事务管理 -->
	<bean id="transaction" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	
	<!-- 开启注解事务 -->
	<tx:annotation-driven transaction-manager="transaction"></tx:annotation-driven>
	
</beans>

jdbc.properties

jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssh
jdbc.username=root
jdbc.password=root

log4j.properties

log4j.rootLogger = debug, console, E
#level=INFO,all can be output
#console is set to be a ConsoleAppender
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern = [%p] %d{yyyy-MM-dd HH:mm:ss} - %m%n


#file is set to output to a extra file
log4j.appender.E = org.apache.log4j.DailyRollingFileAppender
log4j.appender.E.layout = org.apache.log4j.PatternLayout
log4j.appender.E.Threshold=error
log4j.appender.E.Encoding=UTF-8
log4j.appender.E.layout.ConversionPattern=[%p] %d{yyyy-MM-dd HH:mm:ss} - %m%n
log4j.appender.E.DatePattern='.'yyyy-MM-dd
log4j.appender.E.File = ${catalina.base}/logs/dd/error.log

运行项目：

存在BUG

在员工一端设置了保存更新级联属性，但是好像不起作用，一直没有找到问题出在哪里。而在部门一端设置的级

联删除还是起作用的。

项目源码下载地址：http://download.csdn.net/detail/erlian1992/9735699

life is wonderful

关注

6
点赞
踩
30

收藏

觉得还不错? 一键收藏
6
评论
【SSH】：基于Struts2+HIbernate3+Spring3实现员工管理系统之案例实现篇（下）

还是接着上一篇继续。 web层实现 1、web.xml文件 ssh_employee index.jsp openSessionInViewFilter org.springframework.orm.hibernate3.support.OpenSessionInViewFilter
复制链接

扫一扫

专栏目录