前面一篇文章已经分享了搭建spring mvc：http://www.linuxidc.com/linux/2015-02/113103.htm 这一篇来链接数据库postgresql 1、在
前面一篇文章已经分享了搭建spring mvc：
这一篇来链接数据库postgresql
1、在pom.xml添加几个依赖
org.postgresql
postgresql
9.3-1102-jdbc4
org.apache.tomcat
tomcat-jdbc
8.0.9
2、创建jdbc.properties配置文件
ticket.database.driver = org.postgresql.driver
ticket.database.url = jdbc:postgresql://***.dev.cn6.qunar.com:5433/check_result
ticket.database.username = menpiao_dev
ticket.database.password = ***-***-***
3、在dispatcher-servlet.xml里添加数据源
destroy-method=close autowire=no>
4、创建测试service类
package com.qunar.check.service;
import java.sql.connection;
import java.sql.resultset;
import java.sql.statement;
import javax.sql.datasource;
import org.springframework.context.applicationcontext;
import org.springframework.context.support.classpathxmlapplicationcontext;
public class testservice {
public void test() {
try {
applicationcontext ctx = new classpathxmlapplicationcontext(dispatcher-servlet.xml);
datasource ds = ctx.getbean(datasource, datasource.class);
connection conn = ds.getconnection();
statement st = conn.createstatement();
resultset rt = st.executequery(select * from datasource);
while (rt.next()) {
string test1 = rt.getstring(2);
system.out.println(test1);
}
rt.close();
st.close();
conn.close();
} catch (exception e) {
system.out.println(e);
} finally {
}
}
public static void main(string args[]){
testservice t = new testservice();
t.test();
}
}
5、测试：
info: pre-instantiating singletons in : defining beans [org.springframework.web.servlet.mvc.annotation.defaultannotationhandlermapping#0,org.springframework.format.support.formattingconversionservicefactorybean#0,org.springframework.web.servlet.mvc.annotation.annotationmethodhandleradapter#0,org.springframework.web.servlet.handler.mappedinterceptor#0,org.springframework.beans.factory.config.propertyplaceholderconfigurer#0,testcontroller,org.springframework.context.annotation.internalconfigurationannotationprocessor,org.springframework.context.annotation.internalautowiredannotationprocessor,org.springframework.context.annotation.internalrequiredannotationprocessor,org.springframework.context.annotation.internalcommonannotationprocessor,org.springframework.web.servlet.view.internalresourceviewresolver#0,datasource]; root of factory hierarchy
一月 27, 2015 11:46:43 下午 org.springframework.web.servlet.handler.abstracturlhandlermapping registerhandler
info: mapped url path [/index.do] onto handler [com.qunar.check.controller.testcontroller@75be5b6]
test
下载地址：
------------------------------------------分割线------------------------------------------
免费下载地址在
用户名与密码都是
具体下载目录在 /2015年资料/2月/8日/spring mvc 链接 postgresql/
下载方法见
------------------------------------------分割线------------------------------------------
下面的文章您可能也喜欢
centos 6.3环境下yum安装postgresql 9.3
postgresql缓存详述
windows平台编译 postgresql
ubuntu下lapp（linux+apache+postgresql+php)环境的配置与安装
ubuntu上的phppgadmin安装及配置
centos平台下安装postgresql9.3
postgresql配置streaming replication集群
如何在centos 7/6.5/6.4 下安装postgresql 9.3 与 phppgadmin
------------------------------------------分割线------------------------------------------
postgresql 的详细介绍：请点这里
postgresql 的下载地址：请点这里
本文永久更新链接地址：
，