小试Hibernate

最新推荐文章于 2019-07-29 15:14:29 发布
最新推荐文章于 2019-07-29 15:14:29 发布
阅读量147 收藏
点赞数
分类专栏： Hibernate mysql Maven
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_43656119/article/details/96441253
版权
mysql 同时被 3 个专栏收录
5 篇文章 0 订阅
订阅专栏
Maven
4 篇文章 0 订阅
订阅专栏
Hibernate
2 篇文章 0 订阅
订阅专栏

小试Hibernate

maven下的hibernate

pom.xml配置

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

<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/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>com.wanmait</groupId>
  <artifactId>hibernateDemo</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>hibernateDemo Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>

    <!--注入灵魂-->
    <dependency>
      <groupId>org.hibernate</groupId>
      <artifactId>hibernate-core</artifactId>
      <version>4.3.11.Final</version>
    </dependency>

    <!--mysql连接-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.16</version>
      <scope>runtime</scope>
    </dependency>
  </dependencies>

  <build>
    <finalName>hibernateDemo</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.8.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>

hibernate.cfg.xml

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>
    <session-factory>
        <property name="dialect">
            <!--方言翻译处Hhhhhh,例如用的是Oracle数据库的话改为OracleDialect-->
            org.hibernate.dialect.MySQLDialect
        </property>
        <property name="connection.password">123456</property>
        <property name="connection.username">root</property>
        <property name="connection.url">
            jdbc:mysql://localhost:3306/hospital?useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=Asia/Shanghai
        </property>
        <!--注册一下驱动呗-->
        <property name="connection.driver_class">
            com.mysql.cj.jdbc.Driver
        </property>
        <!--是否在控制台上显示sql语句-->
        <property name="show_sql">true</property>
        <!--打印的sql语句按梯形进行显示-->
        <property name="format_sql">true</property>
        <property name="current_session_context_class">thread</property>
        <!--注册映射文件-->
        <mapping resource="mapping/Doctor.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

HibernateSessionFactory util类

package com.wanmait.demo.util;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;


public class HibernateSessionFactory {


	private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
    private static org.hibernate.SessionFactory sessionFactory;
	
    private static Configuration configuration = new Configuration();
    private static ServiceRegistry serviceRegistry; 

	static {
    	try {
			configuration.configure();
			serviceRegistry = new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildServiceRegistry();
			sessionFactory = configuration.buildSessionFactory(serviceRegistry);
		} catch (Exception e) {
			System.err.println("%%%% Error Creating SessionFactory %%%%");
			e.printStackTrace();
		}
    }
    private HibernateSessionFactory() {
    }
	
	/**
     * Returns the ThreadLocal Session instance.  Lazy initialize
     * the <code>SessionFactory</code> if needed.
     *
     *  @return Session
     *  @throws HibernateException
     */
    public static Session getSession() throws HibernateException {
        Session session = (Session) threadLocal.get();

		if (session == null || !session.isOpen()) {
			if (sessionFactory == null) {
				rebuildSessionFactory();
			}
			session = (sessionFactory != null) ? sessionFactory.openSession()
					: null;
			threadLocal.set(session);
		}

        return session;
    }

	/**
     *  Rebuild hibernate session factory
     *
     */
	public static void rebuildSessionFactory() {
		try {
			configuration.configure();
			serviceRegistry = new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildServiceRegistry();
			sessionFactory = configuration.buildSessionFactory(serviceRegistry);
		} catch (Exception e) {
			System.err.println("%%%% Error Creating SessionFactory %%%%");
			e.printStackTrace();
		}
	}

	/**
     *  Close the single hibernate session instance.
     *
     *  @throws HibernateException
     */
    public static void closeSession() throws HibernateException {
        Session session = (Session) threadLocal.get();
        threadLocal.set(null);

        if (session != null) {
            session.close();
        }
    }

	/**
     *  return session factory
     *
     */
	public static org.hibernate.SessionFactory getSessionFactory() {
		return sessionFactory;
	}
	/**
     *  return hibernate configuration
     *
     */
	public static Configuration getConfiguration() {
		return configuration;
	}

}

映射文件

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!--
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.wanmait.hibernate.pojo.Doctor" table="doctor">
        <!--标识属性-->
        <id name="id" type="java.lang.Integer">
            <column name="id"/>
            <!--主键的生成方式 identity表示自增长 native表示按着数据库底层的生成方式来决定属性的生成方式-->
            <generator class="identity"/>
        </id>

        <property name="name" type="java.lang.String">
            <column name="name" length="20"/>
        </property>

      <!--  <property name="department" type="com.wanmait.hibernate.pojo.Department">
            <column name="department_id" length=""
        </property>-->

        <!--insert="false"表示有默认值 添加时不用管该属性-->
        <property name="scope" type="java.lang.String">
            <column name="scope" length="50"/>
        </property>

        <property name="info" type="java.lang.String">
            <column name="info" length="100"/>
        </property>

        <property name="visible" type="java.lang.Boolean" insert="false">
            <column name="visible" />
        </property>
    </class>

</hibernate-mapping>

Doctor.hbm.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!--
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.wanmait.hibernate.pojo.Doctor" table="doctor">
        <!--标识属性-->
        <id name="id" type="java.lang.Integer">
            <column name="id"/>
            <!--主键的生成方式 identity表示自增长 native表示按着数据库底层的生成方式来决定属性的生成方式-->
            <generator class="identity"/>
        </id>

        <property name="name" type="java.lang.String">
            <column name="name" length="20"/>
        </property>

      <!--  <property name="department" type="com.wanmait.hibernate.pojo.Department">
            <column name="department_id" length=""
        </property>-->

        <!--insert="false"表示有默认值 添加时不用管该属性-->
        <property name="scope" type="java.lang.String">
            <column name="scope" length="50"/>
        </property>

        <property name="info" type="java.lang.String">
            <column name="info" length="100"/>
        </property>

        <property name="visible" type="java.lang.Boolean" insert="false">
            <column name="visible" />
        </property>
    </class>

</hibernate-mapping>

DoctorDAO

package com.wanmait.hibernate.dao;

import com.wanmait.hibernate.pojo.Doctor;
import com.wanmait.hibernate.util.HibernateSessionFactory;
import org.hibernate.Query;
import org.hibernate.ScrollableResults;
import org.hibernate.Session;
import org.hibernate.Transaction;

import java.util.List;

public class DoctorDAO {

    /*默认查全部*/
    public List<Doctor> findAll()
    {
        List<Doctor> doctors = null;
        Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
        session.beginTransaction();

        /*Doctor为类名,visible为属性名,区分大小写*/
        /*String hql = "from Doctor where visible=true";*/
        /*String hql = "from Doctor d where d.visible=true";*/
        String hql = "select d from Doctor d where d.visible=true";
        /*创建查询语句*/
        Query query = session.createQuery(hql);
        /*执行查询*/
        doctors = query.list();
        session.getTransaction().commit();

        return doctors;
    }

    /*模糊查询*/
    public List<Doctor> findByLike(String s)
    {
        List<Doctor>doctors = null;
        Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
        session.beginTransaction();

        String hql = "from Doctor where visible=true and info like :info";
        Query query = session.createQuery(hql);
        query.setString("info","%"+s+"%");
        doctors = query.list();
        session.getTransaction().commit();

        return doctors;
    }

    /*只查想要的几列数据*/
    public List<Doctor> findAll2()
    {
        List<Doctor>doctors = null;
        Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
        session.beginTransaction();

        /*异常:org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class xxx*/
        /*pojo中构造方法*/
        String hql= "select new Doctor(name,visible) from Doctor where visible=true";
        Query query = session.createQuery(hql);
        doctors = query.list();
        session.getTransaction().commit();

        return doctors;
    }

    /*分页*/
    public List<Doctor> findAll(Integer pageSize,Integer pageNum)
    {
        List<Doctor>doctors = null;
        Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
        session.beginTransaction();

        String hql = "from Doctor where visible=true order by id desc";
        Query query = session.createQuery(hql);
        /*设置从第几条开始查询*/
        query.setFirstResult((pageNum-1)*pageSize);
        /*设置查询条数*/
        query.setMaxResults(pageSize);

        doctors = query.list();
        session.getTransaction().commit();

        return doctors;
    }

    /*查询数据总数*/
    public Integer findDataCount()
    {
        Integer i = null;
        Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
        session.beginTransaction();

        String hql = "select count(*) from Doctor where visible=true";
        Query query = session.createQuery(hql);
        //查询结果最多只能有一条数据 如果能查询出来多条数据会报异常
        i = ((Long) query.uniqueResult()).intValue();
        session.getTransaction().commit();

        return i;
    }

    /*分组查询*/
    public void findGroup()
    {
        Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
        session.beginTransaction();

        String hql = "select visible,count(*) from Doctor group by visible";
        Query query = session.createQuery(hql);
        ScrollableResults rs = query.scroll();
        while (rs.next())
        {
            System.out.println(rs.get(0));
            System.out.println(rs.get(1));
            System.out.println("======================");
        }
        session.getTransaction().commit();
    }

    /*单个参数查询*/
    public Doctor findById(Integer id)
    {
        Doctor doctor = null;
        Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
        session.beginTransaction();

        doctor =(Doctor) session.get(Doctor.class,id);
        session.getTransaction().commit();

        return doctor;
    }

    /*增加一条新数据1*/
    public void insert(Doctor doctor)
    {
        //打开session
        //需要在hibernate.cfg.xml配置文件中添加属性current_session_context_class为thread
        //通过getCurrentSession()获得的session 增删改查都需要加事务处理
        //事务结束自动关闭session
        Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
        /*开始事务*/
        Transaction transaction = null;
        transaction = session.beginTransaction();
        session.save(doctor);
        /*提交事务*/
        transaction.commit();
    }

    /*增加一条新数据2*/
    public void insert2(Doctor doctor)
    {
        /*打开session*/
        Session session = HibernateSessionFactory.getSession();
        /*通过openSession()方法获得的session，增删改都需要加事务处理,查询不需要事务处理*/
        /*开始事务*/
        Transaction transaction = null;
        transaction = session.beginTransaction();
        session.save(doctor);
        /*提交事务*/
        transaction.commit();
        /*关闭session*/
        HibernateSessionFactory.closeSession();
    }

    /*更新数据*/
    public void update(Doctor doctor)
    {
        Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
        /*开始事务*/
        Transaction transaction = null;
        transaction = session.beginTransaction();
        session.update(doctor);
        /*提交事务*/
        transaction.commit();
    }

    /*假删除*/
    public void deleteFalse(Integer id)
    {
        Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
        /*开始事务*/
        Transaction transaction = session.beginTransaction();
        /*修改和删除也可以使用query*/
        /*String hql = "delete from Doctor where id=:id";*/
        String hql = "update Doctor set visible=false where id=:id";
        Query query = session.createQuery(hql);
        query.setInteger("id",id);
        query.executeUpdate();
        /*提交事务*/
        transaction.commit();
    }

    /*真删除*/
    // 传进来的对象如果只设置id，不设置非空属性会报异常
    public void delete(Doctor doctor)
    {
        Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
        /*开始事务*/
        Transaction transaction = session.beginTransaction();
        session.delete(doctor);
        /*提交事务*/
        transaction.commit();
    }
}

test

package com.wanmait.hibernate.dao.test;

import com.wanmait.hibernate.dao.DoctorDAO;
import com.wanmait.hibernate.pojo.Doctor;
import org.junit.BeforeClass;
import org.junit.Test;

import java.util.List;

public class DoctorDAOTest {

    private static DoctorDAO doctorDAO;
    @BeforeClass
    public static void init()
    {
        doctorDAO = new DoctorDAO();
    }

    /*默认查全部*/
    @Test
    public void testFindAll()
    {
        List<Doctor> doctors = doctorDAO.findAll();
        System.out.println(doctors.get(0).getName());
    }

    /*模糊查询*/
    @Test
    public void testFindByLike()
    {
        String s = "病";
        List<Doctor>doctors = doctorDAO.findByLike(s);
        System.out.println(doctors.get(0).getScope());

    }

    /*只查想要的几列的值*/
    @Test
    public void testFindAll2()
    {
        List<Doctor>doctors = doctorDAO.findAll2();
        doctors.forEach(doctor -> System.out.println(doctor.getName()+doctor.getVisible()));
    }

    /*分页*/
    @Test
    public void testFindPage()
    {
        List<Doctor>doctors = doctorDAO.findAll(5,1);
        doctors.forEach(doctor -> System.out.println(doctor.getName()));
    }

    /*查询数据总数*/
    @Test
    public void testFindCount()
    {
        Integer i = doctorDAO.findDataCount();
        System.out.println(i);
    }

    /*分组查询*/
    @Test
    public void testFindByGroup()
    {
        doctorDAO.findGroup();
    }

    /*单个参数查询*/
    @Test
    public void testFindById()
    {
        System.out.println(doctorDAO.findById(1).getName());
    }

    /*增加一条新数据1*/
    @Test
    public void insert()
    {
        Doctor doctor = new Doctor();
        doctor.setName("甜甜");
        doctor.setScope("俩字,甜");
        doctorDAO.insert(doctor);
    }

    /*增加一条新数据2*/
    @Test
    public void insert2()
    {
        Doctor doctor = new Doctor();
        doctor.setName("冷檬");
        doctor.setScope("俩字,美");
        doctorDAO.insert(doctor);
    }

    /*更新数据*/
    @Test
    public void update()
    {
        Doctor doctor = doctorDAO.findById(22);
        doctor.setScope("我的女神冷檬");
        doctorDAO.update(doctor);
    }

    /*假删除*/
    @Test
    public void deleteFalse()
    {
        doctorDAO.deleteFalse(13);
    }

    /*真删除*/
    @Test
    public void testDelete()
    {
        Doctor doctor = new Doctor();
        doctor.setId(15);
        doctorDAO.delete(doctor);
    }
}
麻衣Protector
关注
专栏目录
hibernate小试
12-06
**hibernate小试** 在Java开发中，Hibernate是一个非常重要的对象关系映射（ORM）框架，它极大地简化了数据库操作。本资源旨在为初学者提供一个基础的Hibernate使用示例，通过非注解的方式展示如何创建实体类、配置...
Hibernate小试牛刀
08-04
【标题】：“Hibernate小试牛刀” 在Java开发领域，Hibernate是一个非常重要的对象关系映射（ORM）框架，它极大地简化了数据库操作。本篇内容将深入探讨Hibernate的基本概念、安装配置以及简单应用，帮助初学者快速...
Hibernate小试
qq_25100133的博客
10-21 195
Hibernate框架​ hibernate是一个对象关系映射框架(object relation mapping)，主要完成对象和关系模型之间的相互转化，对象可以持久化到关系型数据库中，关系型数据库中的模型也可以转换为实体对象。​
hibernate小试牛刀
wtsusheng的专栏
11-15 107
这两天对着本教材看struts+hibernate+spring,看得很痛苦，因为既不提供jar包，步骤写得又不清不楚，download了一个例子，[url]http://www.roseindia.net/hibernate/HIbernateGettingStarted.shtml[/url] 这个例子倒不错，什么东西都全了，但想用Hibernate Synchronizer这个插件在Ecl...
Hibernate Search牛刀小试
garyli
01-16 111
  Hibernate Search牛刀小试 分类： Java2007-09-30 14:16 5300人阅读 评论(4) 收藏 举报 hibernatesearchimportexceptionclasslucene 前几天看到Hibernate与Lucene的整合框架Hiberate Search3.0.0.GA版出来了，昨天试这写了一个Demo，感觉用起来的确很方便的，...
hibernate Search牛刀小试 （转）
fncj
01-12 83
前几天看到Hibernate与Lucene的整合框架Hiberate Search3.0.0.GA版出来了，昨天试这写了一个Demo，感觉用起来的确很方便的，贴出来与大家分享一下。 1、创建POJO package com.yehui; import javax.persistence.CascadeType; import javax.persistence.Column; i...
Hibernate Criteria对象详解
codepython的专栏
08-18 599
1.序言 Hibernate框架是目前JavaEE软件开发的企业主流框架，学习Hibernate必然要掌握ORM（对象关系映射Object/Relation Mapping）的概念思想， Hibernate拥有完全的ORM理念，我们在操作数据库时，可以通过面向对象的方式就可以完成数据库的CRUD（创建（Create）、更新（Update）、读取（Read）和删除（Delete））操作。
Hibernate Criteria详解
风致岚珊的博客
09-06 850
转自：http://bbs.itcast.cn/article-211-1.html 1.序言 Hibernate框架是目前JavaEE软件开发的企业主流框架，学习Hibernate必然要掌握ORM（对象关系映射Object/Relation Mapping）的概念思想， Hibernate拥有完全的ORM理念，我们在操作数据库时，可以通过面向对象的方式就可以完成数据库的CRUD（创建
1.Hibernate小试牛刀 Hibernate项目环境搭建、Hibernate项目开发示例
sgyhl18的专栏
04-19 700
1.导入19个jar包http://pan.baidu.com/s/1sjlxsbb 2.部署两个xml hibernate.cfg.xml <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hib
Hibernate入门：下载配置与持久化类设置
第1章：Hibernate小试牛刀 首先，我们接触Hibernate框架的基本概念。ORM（Object-Relational Mapping）是一种编程技术，它使得面向对象编程语言能够与关系型数据库无缝集成。Hibernate作为ORM的代表，通过提供...
一次Insert插入多条数据的方法
qq_43656119的博客
07-29 8773
一次Insert插入多条数据的方法 插入的数据为 List类型 <insert id="insertEveryDay" parameterType="java.lang.Integer"> insert into attendance_record(userinfo_id) values <foreach collection="list" index="inde...
mysql数据库插入一条新数据,返回新插入数据的主键Id
qq_43656119的博客
07-17 5332
mysql数据库插入一条新数据,返回新插入数据的主键Id mapping映射文件的sql语句 <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.wanmait.hospital.pojo.Doctor" useGeneratedKeys="true"> insert i...
增删改--数据库dao的封装
qq_43656119的博客
05-06 209
数据库增删改功能的封装使用 连接数据库,生成一个配置文件方便修改 dbconfig.properties 配置文件的格式后缀为.properties 文件中写键值对 driver = com.mysql.cj.jdbc.Driver url = jdbc:mysql://127.0.0.1:3306/Shopping?useUnicode=true&characterEncoding=UT...
mysql数据库
qq_43656119的博客
05-05 165
mysql数据库 增: insert into user(username,userpass) values(?,?) insert into 表名(列名,列名…) values(值,值… )
Kafka 17道面试题和答案（2025最新版）.docx
最新发布
10-20
Kafka 17道面试题和答案（2025最新版）
基于Vue的智能停车计费系统.js+SpringBoot+MySQL开发，高分成品毕业设
10-20
基于Vue的智能停车计费系统.js+SpringBoot+MySQL开发，高分成品毕业设计，附带往届论文、启动教程、讲解视频、二次开发教程和配套安装包文件，拿到就 可以作为计算机毕业设计或课程设计，
Flex3与Hibernate整合及MyEclipse配置教程
9. **登录功能实现**：虽然教程没有深入介绍，但提到的“小试牛刀”可能意味着实现一个简单的登录功能，这通常涉及到用户凭证验证和安全控制，可能使用Flex的HTTPService或 BlazeDS的RemotingDestination来调用后端...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值