本指南將引導您完成使用Leopard Jdbc操作MySQL。

你可以從頭開始并完成每一個步驟,或者您可以繞過你已經熟悉的基本設置步驟。無論哪種方式,你最終都可以得到可工作的代碼。

在dao模塊的pom.xml加入

<dependencies>    [...]    <dependency>        <groupId>io.leopard.data4j</groupId>        <artifactId>data4j-jdbc</artifactId>        <version>0.0.1-SNAPSHOT</version>    </dependency>    [...]</dependencies><repositories>    <repository>        <id>leopard-snapshots</id>        <name>Leopard Snapshots</name>        <url>http://leopard.io/nexus/content/repositories/snapshots/</url>    </repository></repositories>

src/main/resources/applicationContext-dao.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" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd"><bean id="userDao" class="io.leopard.guides.dao.UserDao" /><bean id="jdbc" class="io.leopard.data4j.jdbc.JdbcMysqlImplFactoryBean"><property name="host" value="112.126.75.27" /><property name="database" value="example" /><property name="user" value="example" /><property name="passWord" value="leopard" /></bean></beans>

創建src/main/java/io/leopard/guides/dao/UserDao.java

package io.leopard.guides.dao;import io.leopard.data4j.jdbc.Jdbc;import io.leopard.data4j.jdbc.builder.InsertBuilder;import io.leopard.guides.model.User;import javax.annotation.Resource;public class UserDao {@Resourceprivate Jdbc jdbc;/** * 添加用戶. *  * @param user * @return 添加成功返回true，出錯拋異常 */public boolean add(User user) {InsertBuilder builder = new InsertBuilder("user");builder.setLong("uid", user.getUid());builder.setString("nickname", user.getNickname());builder.setDate("posttime", user.getPosttime());return this.jdbc.insertForBoolean(builder);}/** * 根據uid獲取用戶信息. *  * @param uid * @return 用戶存在則返回用戶對象，不存在則返回null. */public User get(long uid) {String sql = "select * from user where uid=?";return this.jdbc.query(sql, User.class, uid);}/** * 刪除用戶 *  * @param uid * @return 成功刪除記錄就返回true，記錄不存在則返回false，出錯則拋異常. */public boolean delete(long uid) {String sql = "delete from user where uid=?";return this.jdbc.updateForBoolean(sql, uid);}}

了解Leopard更多功能模塊，請訪問http://leopard.io/

恭喜你！您已經可以在舊項目配置使用Leopard Jdbc，雖然功能比較簡單，你可以在這個基礎上擴展出你的業務系統，祝您好運。