derby spring mybatis 集成

来源:互联网 发布:php array sort 排序 编辑:程序博客网 时间:2024/05/29 11:22

derby运行环境搭建:

derby 10.13

jdk1.8

Centos7.2


搭建方法:

1.derby上传到服务器上目录

    /home/xx/db-derby-10.13.1.1-bin/db-derby-10.13.1.1-bin/

2.修改环境变量

vim /etc/profile

export DERBY_HOME=/home/youedata/db-derby-10.13.1.1-bin/db-derby-10.13.1.1-bin

export PATH=$PATH:$DERBY_HOME/bin


3.使其生效

source /etc/profile


4.启动derby

进入$DERBY_HOME/bin目录执行

./NetworkServerControl start -h 192.168.0.142 -p 1527


5.创建数据库

语句略


derby mybatis  spring 集成

1.maven依赖

<!-- https://mvnrepository.com/artifact/org.apache.derby/derby -->
<dependency>
   <groupId>org.apache.derby</groupId>
   <artifactId>derby</artifactId>
   <version>10.13.1.1</version>
</dependency>

<!-- https://mvnrepository.com/artifact/org.apache.derby/derbyclient -->
<dependency>
   <groupId>org.apache.derby</groupId>
   <artifactId>derbyclient</artifactId>
   <version>10.13.1.1</version>
</dependency>


2.配置文件

<!-- 链接derby -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"   destroy-method="close" abstract="false" scope="singleton" lazy-init="false">   
   <property name="driverClass" value="org.apache.derby.jdbc.ClientDriver" />  
   <property name="jdbcUrl" value="jdbc:derby://192.168.0.142:1527/dedb;user=root;password=root" /> 
</bean> 


3.java代码和mysql mybatis spring代码一样 自行百度一下

0 0
原创粉丝点击