81,092
社区成员
发帖
与我相关
我的任务
分享
driver=org.postgresql.Driver
url=jdbc:postgresql://127.0.0.1:5432/enmia
username=test
password=test
<configuration>
<properties resource="db.properties"></properties>
<typeAliases>
<typeAlias alias="Step" type="com.test.obj.Step"/>
</typeAliases>
<environments default="enmia">
<environment id="enmia">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="url" value="${url}" />
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
<property name="driver" value="${driver}"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/test/obj/Step.xml"/>
</mappers>
</configuration>
public class ServiceTest {
private static SqlSessionFactory sqlSessionFactory;
private static Reader reader;
static{
try{
reader = Resources.getResourceAsReader("Configuration.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
}catch(Exception e){
e.printStackTrace();
}
}
public static void main(String[] args) {
SqlSession session = sqlSessionFactory.openSession();
try {
StepService stepservice = session.getMapper(StepService.class);
List<Step> steps = stepservice.selectStepByStatus(0);
for(Step step:steps){
System.out.println(step.getId());
System.out.println(step.getStatus());
}
} finally {
session.close();
}
}