从config文件中读取数据库信息

原创

wx62e9cee37942d 2022-08-04 16:59:02 博主文章分类：Spring ©著作权

文章标签 config文件 config读取数据库 spring xml oracle 文章分类 后端开发

©著作权归作者所有：来自51CTO博客作者wx62e9cee37942d的原创作品，请联系作者获取转载授权，否则将追究法律责任

13.1新建一个数据库实体类;
 package com.eduask.util;
 import java.sql.Connection;
 import java.sql.DriverManager;
 import java.sql.SQLException;
 //数据库的实体类;
 public class Demo2 {
 private static String url;
 private static String user;
 private static String pwd;
 private static String driverClass;
 public static Connection getconn(){
 Connection conn=null;
 try {
 conn=DriverManager.getConnection(url, user, pwd);
 } catch (SQLException e) {
 System.out.println(e.getMessage());
 }
 return conn;
 }
 public String getUrl() {
 return url;
 }
 public void setUrl(String url) {
 this.url = url;
 }
 public String getUser() {
 return user;
 }
 public void setUser(String user) {
 this.user = user;
 }
 public String getPwd() {
 return pwd;
 }
 public void setPwd(String pwd) {
 this.pwd = pwd;
 }
 public String getDriverClass() {
 return driverClass;
 }
 public void setDriverClass(String driverClass) {
 try {
 Class.forName(driverClass);
 this.driverClass = driverClass;
 } catch (ClassNotFoundException e) {
 // TODO Auto-generated catch block
 e.printStackTrace();
 }
 }
 @Override
 public String toString() {
 return "Demo2 \n[url=" + url + "]\n[user=" + user + "]\n[pwd=" + pwd
 + "]\n[driverClass=" + driverClass + "]";
 }
 public Demo2(String url, String user, String pwd, String driverClass) {
 super();
 this.url = url;
 this.user = user;
 this.pwd = pwd;
 this.driverClass = driverClass;
 }
 public Demo2() {
 super();
 // TODO Auto-generated constructor stub
 }
 }
 13.2 新建一个TestDemo1的测试类;
 package com.eduask.util;
 import org.springframework.context.support.ClassPathXmlApplicationContext;
 public class TestDemo2 {
 public static void main(String[] args) {
 ClassPathXmlApplicationContext cx=new ClassPathXmlApplicationContext("util/demo2.xml");
 Demo2 demo2=(Demo2) cx.getBean("demo2");
 System.out.println(demo2);
 }
 }
 13.3 新建一个config的源文件下的db.properties
 url=jdbc:oracle:thin:@localhost:1521/orcl
 user=scott
 pwd=tiger
 driverClass=oracle.jdbc.driver.OracleDriver
 13.4 新建一个demo2.xml的配置文件
 <?xml version="1.0" encoding="UTF-8"?>
 <beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:p="http://www.springframework.org/schema/p"  xmlns:util="http://www.springframework.org/schema/util"    xmlns:context="http://www.springframework.org/schema/context"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
         http://www.springframework.org/schema/util    http://www.springframework.org/schema/util/spring-util-4.0.xsd
         http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
         ">
 <context:property-placeholder location="classpath:db.properties"/>
 <bean id="demo2" class="com.eduask.util.Demo2"
 p:url="${url}"
 p:user="${user}"
 p:pwd="${pwd}"
 p:driverClass="${driverClass}"
 />
 </beans>
 13.5 程序运行如下:
 Demo2
 [url=jdbc:oracle:thin:@localhost:1521/orcl]
 [user=scott]
 [pwd=tiger]
 [driverClass=oracle.jdbc.driver.OracleDriver]