Tablestore:Use Hibernate to query data by executing SQL statements

You can install the JDBC driver by using one of the following methods:

• Download the JDBC driver for Tablestore and import the JDBC driver to the project. For more information about the download path, see JDBC driver for Tablestore.

• Add dependencies to a Maven project.

  To use the JDBC driver for Tablestore in Maven, you need to only add the corresponding dependencies to the pom.xml file. In this example, JDBC driver 5.17.0 is used. Add the following content to <dependencies>:

  <dependency>  <groupId>com.aliyun.openservices</groupId>  <artifactId>tablestore-jdbc</artifactId>  <version>5.17.0</version></dependency>

You can install Hibernate by using one of the following methods:

• Download the Hibernate installation package hibernate-core-x.x.x.jar and import the package to the project. For more information about the download path, see Hibernate installation package.

  In hibernate-core-x.x.x.jar, x.x.x indicates the version number of Hibernate. Download a Hibernate installation package based on your business requirements.

• Add dependencies to a Maven project.

  To use Hibernate in Maven, you need to only add the corresponding dependencies to the pom.xml file. In this example, the 3.6.3.Final version is used. Add the following content to <dependencies>:

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

After you create a Java Bean that contains member variables whose names are the same as the names of fields in the data table, create a mapping configuration file to map the member variables in the Java Bean to the fields in the data table.

1. Create a Java Bean that contains member variables whose names are the same as the names of fields in the data table.

   package hibernate;public class Trip {    private long tripId;    private long duration;    private String startDate;    private String endDate;    private long startStationNumber;    private long endStationNumber;    private String startStation;    private String endStation;    private String bikeNumber;    private String memberType;        // Add the methods that are used to specify field names and return field values.     // In this example, the tripId field is used. You can add the methods that are used to specify field names and return field values for other fields in a similar manner based on your business requirements.     public void setTripId(Long tripId){        this.tripId =tripId    }    public Long getTripId() {        return tripId;    }}

2. Create a mapping configuration file to map the member variables in the Java Bean to the fields in the data table. The following sample code shows how to create a mapping configuration file named Trip.hbm.xml in the hibernate directory.

   Important

   Tablestore SQL does not support data insert and update. Therefore, you must set the insert property and the update property to false. For information about supported data types in SQL, see Data type mappings in SQL. For information about supported SQL features, see SQL features.

   <?xml version="1.0" encoding="utf-8"?><!DOCTYPE hibernate-mapping PUBLIC        "-//Hibernate/Hibernate Mapping DTD//EN"        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"><hibernate-mapping>    <!--Specify the actual class name. -->    <class name="hibernate.Trip" table="trips">        <!-- The field that is configured in the id element is the primary key column of the data table. -->        <id name="tripId" column="trip_id" type="long"/>        <!-- The fields that are configured in the property element are attribute columns of the data table. You must set the insert property and the update property to false because insert and update operations are prohibited for attribute columns. -->        <property name="duration" column="duration" type="long" insert="false" update="false"/>        <property name="startDate" column="start_date" type="string" insert="false" update="false"/>        <property name="endDate" column="end_date" type="string" insert="false" update="false"/>        <property name="startStationNumber" column="start_station_number" type="long" insert="false" update="false"/>        <property name="endStationNumber" column="end_station_number" type="long" insert="false" update="false"/>        <property name="startStation" column="start_station" type="string" insert="false" update="false"/>        <property name="endStation" column="end_station" type="string" insert="false" update="false"/>        <property name="bikeNumber" column="bike_number" type="string" insert="false" update="false"/>        <property name="memberType" column="member_type" type="string" insert="false" update="false"/>    </class></hibernate-mapping>

Step 4: Build the SessionFactory

Step 5: Create a session to query data

Session session = factory.openSession();Trip trip = (Trip) session.get(Trip.class, 99L); System.out.println("trip id: " + trip.getTripId());System.out.println("start date: " + trip.getStartDate());System.out.println("end date: " + trip.getEndDate());System.out.println("duration: " + trip.getDuration());session.close();factory.close();