hsql mybatis 表不存在_java mybatis与hsql使用例子

先启动hsql的服务器与客户端，再使用mybatis查询表

package net.highesoft.mybatis.hsql;

import java.util.Map;

import java.util.Map.Entry;

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource;

import org.apache.ibatis.mapping.Environment;

import org.apache.ibatis.session.Configuration;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import org.apache.ibatis.transaction.TransactionFactory;

import org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory;

public class HsqlTest {

//private static Log log=LogFactory.getLog(HsqlTest.class);

private static SqlSessionFactory sqlSessionFactory;

public static void startHsql() {

new Thread() {

public void run() {

org.hsqldb.server.Server.main(new String[] {});

}

}.start();

new Thread() {

public void run() {

org.hsqldb.util.DatabaseManagerSwing.main(new String[] {});

}

}.start();

try {

Thread.sleep(10000);

} catch (InterruptedException e) {

e.printStackTrace();

}

}

public static void main(String[] args) {

startHsql();

UnpooledDataSource ds = new UnpooledDataSource();

ds.setDriver("org.hsqldb.jdbcDriver");

ds.setUrl("jdbc:hsqldb:hsql://localhost");

ds.setUsername("sa");

ds.setPassword("");

TransactionFactory transactionFactory = new JdbcTransactionFactory();

Environment environment = new Environment("Production", transactionFactory, ds);

Configuration configuration = new Configuration(environment);

configuration.setLazyLoadingEnabled(true);

configuration.setUseActualParamName(false); // to test legacy style reference (#{0} #{1})

configuration.getTypeAliasRegistry().registerAlias(TestMybatis.class);

configuration.addMapper(TestMapper.class);

sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);

SqlSession session = sqlSessionFactory.openSession();

TestMapper mapper = session.getMapper(TestMapper.class);

Mapm = mapper.selectTestMybatis("test_mybatis");

for(Entry entry:m.entrySet()) {

System.out.println(entry.getValue().getName());

}

}

}项目pom.xml

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">

4.0.0

net.highersoft

mybatis.hsql

0.0.1-SNAPSHOT

org.mybatis

mybatis

3.5.2

org.javassist

javassist

3.24.1-GA

compile

true

ognl

ognl

3.2.10

compile

true

org.hsqldb

hsqldb

2.5.0