Spring+SpringMVC+Hibernate+Bootstrap整合

这个是网上找的,但是很久了,找不到链接了,我在这里记录一下,前端的代码太多了就不贴出来了,可以忽略bootstrap部分。

1、整个工程目录结构如下:

2、pom.xml文件

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.ctc</groupId>
    <artifactId>SpringMVC</artifactId>
    <packaging>war</packaging>
    <version>0.0.1-SNAPSHOT</version>
    <name>SpringMVC Maven Webapp</name>
    <url>http://maven.apache.org</url>
    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>3.8.1</version>
            <scope>test</scope>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.22</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>4.2.4.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>4.3.10.Final</version>
        </dependency>

        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>4.2.4.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.14</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>4.2.4.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>commons-dbcp</groupId>
            <artifactId>commons-dbcp</artifactId>
            <version>1.4</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>4.2.4.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjrt</artifactId>
            <version>1.7.2</version>
        </dependency>

        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.7.2</version>
        </dependency>

        <dependency>
            <groupId>jsptags</groupId>
            <artifactId>pager-taglib</artifactId>
            <version>2.0</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>servlet-api</artifactId>
            <version>2.5</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>RELEASE</version>
        </dependency>
        <!--<dependency>-->
        <!--<groupId>com.zte.ume</groupId>-->
        <!--<artifactId>oki</artifactId>-->
        <!--<version>1.0-SNAPSHOT</version>-->
        <!--</dependency>-->

    </dependencies>
    <build>
        <finalName>SpringMVC</finalName>
        <plugins>

            <plugin>

                <groupId>org.apache.maven.plugins</groupId>

                <artifactId>maven-compiler-plugin</artifactId>

                <version>3.1</version>

                <configuration>

                    <source>1.8</source>

                    <target>1.8</target>

                </configuration>

            </plugin>
            <plugin>
                <groupId>org.mortbay.jetty</groupId>
                <artifactId>maven-jetty-plugin</artifactId>
                <version>6.1.25</version>
                <configuration>
                    <!--<connectors>-->
                    <!--<connector implementation="org.mortbay.jetty.nio.SelectChannelConnetor">-->
                    <!--<port>8000</port>-->
                    <!--<maxIdleTime>60000</maxIdleTime>-->
                    <!--</connector>-->
                    <!--</connectors>-->
                    <contextPath>/SpringMVC</contextPath>
                    <scanIntervalSeconds>0</scanIntervalSeconds>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

3、web.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<web-app >

    <!-- 创建Spring的监听器 -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath*:bean.xml</param-value>
    </context-param>

    <servlet>
        <servlet-name>SpringMVC</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <load-on-startup>1</load-on-startup>
    </servlet>

    <servlet-mapping>
        <servlet-name>SpringMVC</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

    <!-- Spring中提供了
    org.springframework.orm.hibernate3.support.OpenSessionInViewFilter;
    这个类来实现OpenSessionInViewer的操作 -->
    <filter>
        <filter-name>openSessionInViewerFilter</filter-name>
        <filter-class>org.springframework.orm.hibernate4.support.OpenSessionInViewFilter</filter-class>

    </filter>
    <filter-mapping>
        <filter-name>openSessionInViewerFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <listener>
        <listener-class>
            org.springframework.web.context.request.RequestContextListener
        </listener-class>
    </listener>

    <filter>
        <filter-name>PageFilter</filter-name>
        <filter-class>com.ctc.Common.PageFilter</filter-class>
    </filter>

    <filter-mapping>
        <filter-name>PageFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

</web-app>

4、SpringMVC-servlet.xml文件,即springMVC的配置文件

<?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:mvc="http://www.springframework.org/schema/mvc"
   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/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">


   <context:component-scan base-package="com.ctc.Controller"/>
   
   <mvc:annotation-driven />
   
   <mvc:default-servlet-handler/>

   <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
      <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
      <property name="prefix" value="/user/"/>
      <property name="suffix" value=".jsp"/>
   </bean>

    <bean id="exceptionResolver" class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">
      <property name="exceptionMappings">
         <props>
            <prop key="com.ctc.Common.UserException">error</prop>
         </props>
      </property>
   </bean>
    
</beans>

5、bean.xml即spring的配置文件

<?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:aop="http://www.springframework.org/schema/aop"
   xmlns:context="http://www.springframework.org/schema/context"
   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/aop
      http://www.springframework.org/schema/aop/spring-aop.xsd
      http://www.springframework.org/schema/context
      http://www.springframework.org/schema/context/spring-context.xsd
      http://www.springframework.org/schema/tx
      http://www.springframework.org/schema/tx/spring-tx.xsd"
      >


   <!-- 打开Spring的Annotation支持 -->
   <context:annotation-config />
   <!-- 设定Spring 去哪些包中找Annotation -->
   <context:component-scan base-package="com.ctc" />
   

   <!-- 导入Src目录下的jdbc.properties文件 -->
   <context:property-placeholder location="classpath:jdbc.properties" />
   
    <bean id="DataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
      <property name="driverClassName" value="${jdbc.driverClassName}" />
      <property name="url" value="${jdbc.url}" />
      <property name="username" value="${jdbc.username}" />
      <property name="password" value="${jdbc.password}" />
    </bean>

    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource" ref="DataSource"/>
        <property name="packagesToScan">
            <list>
                <value>com.ctc.Model</value>
            </list>
        </property>
        <property name="hibernateProperties">
         <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
            <prop key="hibernate.format_sql">false</prop>
         </props>
        </property>
    </bean>
   <!-- 开启HibernateTemplate,并且为其注入SessionFactory
   使用HibernateTemplate不太方便的就是要获取session得通过getSessionFactory()方法获取 -->
   <bean id="hibernateTemplate" class="org.springframework.orm.hibernate4.HibernateTemplate">
      <property name="sessionFactory" ref="sessionFactory"/>
   </bean>
   <!-- 配置Spring的事务处理 -->
   <!-- 创建事务管理器-->
   <bean id="txManager"
      class="org.springframework.orm.hibernate4.HibernateTransactionManager">
      <property name="sessionFactory" ref="sessionFactory" />
   </bean>
<!-- 配置AOP,Spring是通过AOP来进行事务管理的 -->
   <aop:config>
   <!-- 设置pointCut表示哪些方法要加入事务处理 -->
   <!-- 以下的事务是声明在DAO中,但是通常都会在Service来处理多个业务对象逻辑的关系,注入删除,更新等,此时如果在执行了一个步骤之后抛出异常
      就会导致数据不完整,所以事务不应该在DAO层处理,而应该在service,这也就是Spring所提供的一个非常方便的工具,声明式事务 -->
      <aop:pointcut id="allMethods" 
         expression="execution(* com.ctc.ServiceImpl.*.*(..))" />
      <!-- 通过advisor来确定具体要加入事务控制的方法 -->
      <aop:advisor advice-ref="txAdvice" pointcut-ref="allMethods" />
   </aop:config>
<!-- 配置哪些方法要加入事务控制 -->
   <tx:advice id="txAdvice" transaction-manager="txManager">
      <tx:attributes>
      <!-- 让所有的方法都加入事务管理,为了提高效率,可以把一些查询之类的方法设置为只读的事务 -->
         <tx:method name="*" propagation="REQUIRED" read-only="true"/>
         <!-- 以下方法都是可能设计修改的方法,就无法设置为只读 -->
         <tx:method name="add*" propagation="REQUIRED"/>
         <tx:method name="del*" propagation="REQUIRED"/>
         <tx:method name="update*" propagation="REQUIRED"/>
         <tx:method name="save*" propagation="REQUIRED"/>
      </tx:attributes>
   </tx:advice>
</beans>

6、jdbc.properties文件

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/test
jdbc.username = root
jdbc.password = rootroot

7、PageFilter.java

package com.ctc.Common;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;

import com.ctc.Model.PageConstants;


/**
 * 
 * @author Tency
 * 
 * Date 2016/11
 */
public class PageFilter implements Filter {

   @Override
   public void doFilter(ServletRequest req, ServletResponse res,
         FilterChain chain) throws IOException, ServletException {
      int offset = 0;
      try {
         offset = Integer.parseInt(req.getParameter("pager.offset"));
      } catch (NumberFormatException e) {
      }
      try {
         PageConstants.setOffset(offset);
         PageConstants.setSize(5);
         chain.doFilter(req, res);
      }finally {
         PageConstants.removeOffset();
         PageConstants.removeSize();
      }
   }

   @Override
   public void init(FilterConfig arg0) throws ServletException {

   }

   @Override
   public void destroy() {

   }

}

8、UserController.java

package com.ctc.Controller;

import java.util.List;

import javax.annotation.Resource;
import javax.servlet.http.HttpSession;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;

import com.ctc.Model.User;
import com.ctc.Service.UserService;

/**
 * @author Tency
 * <p>
 * Date 2016/11
 */
@Controller
public class UserController {

    @Resource
    UserService userServiceImpl;


    @RequestMapping(value = "/login", method = RequestMethod.GET)
    public String login() {
        return "login";
    }

    @RequestMapping(value = "/login", method = RequestMethod.POST)
    public String login(@RequestParam("userName") String userName,
                        @RequestParam("passWord") String passWord,
                        HttpSession session, Model model) {
        List<User> list = userServiceImpl.checkLogin(userName, passWord);
        boolean flag = list.isEmpty();
        session.setAttribute("flag", flag);
        return !list.isEmpty() ? "redirect:/userManage" : "redirect:/login";
    }

    @RequestMapping(value = "/addUser", method = RequestMethod.GET)
    public String userAdd() {
        return "userAdd";
    }

    @RequestMapping(value = "/addUser", method = RequestMethod.POST)
    public String userAdd(@ModelAttribute("user") User user) {
        userServiceImpl.addUser(user);
        return "redirect:/login";
    }

    @RequestMapping(value = "/userManage", method = RequestMethod.GET)
    public String userManage(Model model) {

        model.addAttribute("pagers", userServiceImpl.userList());
        return "userManage";
    }

    @RequestMapping(value = "/userShow/{id}", method = RequestMethod.GET)
    public String userShow(@PathVariable int id, Model model) {
        User user = userServiceImpl.showUser(id);
        model.addAttribute(user);
        return "userShow";

    }

    @RequestMapping(value = "/userUpdate/{id}", method = RequestMethod.GET)
    public String userUpdate(@PathVariable int id, Model model) {
        User user = userServiceImpl.showUser(id);
        model.addAttribute(user);
        return "userUpdate";

    }

    @RequestMapping(value = "/userUpdate", method = RequestMethod.POST)
    public String userUpdate(@ModelAttribute("user") User user, Model model) {
        userServiceImpl.updateUser(user);
        return "redirect:/userUpdate/" + user.getId();

    }

    @RequestMapping(value = "/userDelete/{id}", method = RequestMethod.GET)
    public String userDelete(@PathVariable int id) {
        userServiceImpl.deleteUser(id);
        return "redirect:/userManage";
    }


}

9、UserDao.java

package com.ctc.Dao;

import java.util.List;

import com.ctc.Model.Pager;
import com.ctc.Model.User;

/**
 * 
 * @author Tency
 * 
 * Date 2016/11
 */
public interface UserDao {

   List<User> retrieve(String userName,String passWord);
   void add(User user);
   Pager<User> retrieveAll();
   User load(int id);
   void update(User user);
   void delete(int id);

}

10、UserDaoImpl.java

package com.ctc.DaoImpl;

import java.util.ArrayList;
import java.util.Collections;
import java.util.List;

import javax.annotation.Resource;

import org.hibernate.Query;
import org.springframework.orm.hibernate4.HibernateTemplate;
import org.springframework.stereotype.Repository;

import com.ctc.Dao.UserDao;
import com.ctc.Model.Pager;
import com.ctc.Model.PageConstants;
import com.ctc.Model.User;


/**
 * @author Tency
 * <p>
 * Date 2016/11
 */
@Repository("userDaoImpl")
public class UserDaoImpl implements UserDao {

    @Resource
    HibernateTemplate hibernateTemplate;

    @Override
    public List<User> retrieve(String userName, String passWord) {
        // TODO Auto-generated method stub

        List<User> list = new ArrayList<>();
        list = (List<User>) hibernateTemplate.find("from User as u where u.userName='" + userName + "' and u.passWord='" + passWord + "'");

        if (list.size() > 0 && list != null)
            return list;
        return Collections.emptyList();
    }

    @Override
    public void add(User user) {

        hibernateTemplate.save(user);

    }

    @Override
    public Pager<User> retrieveAll() {
        // TODO Auto-generated method stub
        int size = PageConstants.getSize();
        int offset = PageConstants.getOffset();
        Query query = this.hibernateTemplate.getSessionFactory().getCurrentSession().createQuery("from User");
        query.setFirstResult(offset).setMaxResults(size);
        List<User> datas = query.list();
        Pager<User> pager = new Pager<User>();
        pager.setDatas(datas);
        pager.setOffset(offset);
        pager.setSize(size);
        long total = (Long) this.hibernateTemplate.getSessionFactory().getCurrentSession()
                .createQuery("select count(*) from User")
                .uniqueResult();
        pager.setTotal(total);
        return pager;
    }

    @Override
    public User load(int id) {
        // TODO Auto-generated method stub
        return hibernateTemplate.load(User.class, id);
    }

    @Override
    public void update(User user) {
        // TODO Auto-generated method stub
        hibernateTemplate.update(user);
    }

    @Override
    public void delete(int id) {
        // TODO Auto-generated method stub
        User user = this.load(id);
        hibernateTemplate.delete(user);
    }


}

11、PageConstants.java

package com.ctc.Model;

/**
 * 
 * @author Tency
 * 
 * Date 2016/11
 */
public class PageConstants {
   private static ThreadLocal<Integer> offset = new ThreadLocal<Integer>();
   private static ThreadLocal<Integer> size = new ThreadLocal<Integer>();
   
   public static Integer getOffset() {
      return offset.get();
   }
   public static void setOffset(Integer _offset) {
      offset.set(_offset);
   }
   public static void removeOffset() {
      offset.remove();
   }
   
   public static Integer getSize() {
      return size.get();
   }
   public static void setSize(Integer _size) {
      size.set(_size);
   }
   public static void removeSize() {
      size.remove();
   }
   
}

12、Pager.java

package com.ctc.Model;

import java.util.List;

/**
 * 
 * @author Tency
 * 
 * Date 2016/11
 */
public class Pager<T> {
   private List<T> datas;
   private int offset;
   private int size;
   private long total;
   public List<T> getDatas() {
      return datas;
   }
   public void setDatas(List<T> datas) {
      this.datas = datas;
   }
   public int getOffset() {
      return offset;
   }
   public void setOffset(int offset) {
      this.offset = offset;
   }
   public int getSize() {
      return size;
   }
   public void setSize(int size) {
      this.size = size;
   }
   public long getTotal() {
      return total;
   }
   public void setTotal(long total) {
      this.total = total;
   }
}

13、User.java

package com.ctc.Model;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;


/**
 * 
 * @author Tency
 * 
 * Date 2016/11
 */
@Entity
@Table(name="user")
public class User {

   private int id;
   private String userName;
   private String passWord;
   
   @Id
   @GeneratedValue
   public int getId() {
      return id;
   }
   public void setId(int id) {
      this.id = id;
   }
   public String getUserName() {
      return userName;
   }
   public void setUserName(String userName) {
      this.userName = userName;
   }
   public String getPassWord() {
      return passWord;
   }
   public void setPassWord(String passWord) {
      this.passWord = passWord;
   }
   @Override
   public String toString() {
      return "User [id=" + id + ", userName=" + userName + ", passWord=" + passWord + "]";
   }
   @Override
   public int hashCode() {
      final int prime = 31;
      int result = 1;
      result = prime * result + id;
      result = prime * result + ((passWord == null) ? 0 : passWord.hashCode());
      result = prime * result + ((userName == null) ? 0 : userName.hashCode());
      return result;
   }
   @Override
   public boolean equals(Object obj) {
      if (this == obj)
         return true;
      if (obj == null)
         return false;
      if (getClass() != obj.getClass())
         return false;
      User other = (User) obj;
      if (id != other.id)
         return false;
      if (passWord == null) {
         if (other.passWord != null)
            return false;
      } else if (!passWord.equals(other.passWord))
         return false;
      if (userName == null) {
         if (other.userName != null)
            return false;
      } else if (!userName.equals(other.userName))
         return false;
      return true;
   }
   
   
}

14、UserService.java

package com.ctc.Service;

import java.util.List;

import com.ctc.Model.Pager;
import com.ctc.Model.User;


/**
 * 
 * @author Tency
 * 
 * Date 2016/11
 */
public interface UserService {

   List<User> checkLogin(String userName,String passWord);
   void addUser(User user);
   User showUser(int id);
   void updateUser(User user);
   void deleteUser(int id);
   Pager<User> userList();
}

15、UserServiceImpl.java

package com.ctc.ServiceImpl;

import java.util.List;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.springframework.stereotype.Service;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;

import com.ctc.Dao.UserDao;
import com.ctc.Model.Pager;
import com.ctc.Model.User;
import com.ctc.Service.UserService;

/**
 * @author Tency
 * <p>
 * Date 2016/11
 */
@Service("userServiceImpl")
public class UserServiceImpl implements UserService {

    @Resource
    UserDao userDaoImpl;
    HttpSession session;
    HttpServletRequest request;

    @Override
    public List<User> checkLogin(String userName, String passWord) {
        // TODO Auto-generated method stub
        List<User> list = userDaoImpl.retrieve(userName, passWord);
        request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
        session = request.getSession();
        if (!list.isEmpty()) {
            session.setAttribute("userName", list.get(0).getUserName());
        }

        return list;
    }

    @Override
    public void addUser(User user) {
        // TODO Auto-generated method stub
        this.userDaoImpl.add(user);
    }

    @Override
    public User showUser(int id) {
        // TODO Auto-generated method stub
        return userDaoImpl.load(id);
    }

    @Override
    public void updateUser(User user) {
        // TODO Auto-generated method stub
        this.userDaoImpl.update(user);
        request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
        session = request.getSession();
        session.setAttribute("userName", user.getUserName());
    }

    @Override
    public void deleteUser(int id) {
        // TODO Auto-generated method stub
        this.userDaoImpl.delete(id);
    }

    @Override
    public Pager<User> userList() {
        // TODO Auto-generated method stub
        return userDaoImpl.retrieveAll();
    }


}

 

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值