先启动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