spring mvc 链接 postgresql-白红宇

spring mvc 链接 postgresql

阅读量：7006 次

发布时间：2019-06-28

本文共 3190 字，大约阅读时间需要 10 分钟。

上一篇文章已经分享了搭建springmvc：http://www.cnblogs.com/liqiu/p/4252788.html

这一篇来链接数据库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.Driverticket.database.url = jdbc:postgresql://***.dev.cn6.qunar.com:5433/check_resultticket.database.username = menpiao_devticket.database.password = ***-***-***

3、在dispatcher-servlet.xml里添加数据源

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 org.springframework.beans.factory.support.DefaultListableBeanFactory@ff7f824: 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 registerHandlerINFO: Mapped URL path [/index.do] onto handler [com.qunar.check.Controller.TestController@75be5b6]test

下载地址：http://files.cnblogs.com/files/liqiu/check_result_db.tar.gz

你可能感兴趣的文章