java jdbc properties_java项目中读取jdbc.properties文件操作

java内容

Properties props = Resources.getResourceAsProperties("jdbc.properties");

String url = props.getProperty("jdbc.url");

String driver = props.getProperty("jdbc.driverClass");

String username = props.getProperty("jdbc.username");

String password = props.getProperty("jdbc.password");

Class.forName(driver).newInstance();

Connection conn = (Connection) DriverManager.getConnection(url, username, password);

jdbc.properties文件内容

jdbc.driverClass = com.mysql.jdbc.Driver

jdbc.url = jdbc\:mysql\://127.0.0.1\:3306/LY?useUnicode\=true&characterEncoding\=UTF-8&zeroDateTimeBehavior\=convertToNull&allowMultiQueries\=true

jdbc.username = root

jdbc.password = root

jdbc.minPoolSize=2

jdbc.maxPoolSize=20

jdbc.checkoutTimeout=3000

jdbc.maxStatements=50

jdbc.testConnectionOnCheckin = false

jdbc.idleConnectionTestPeriod =18000

补充知识：模仿com.alibaba.fastjson.JSONObject取值的PropertiesUtils

1.依赖于：fastjson

com.alibaba

fastjson

1.2.39

2.话不多说，上代码

package com.gy.common.util;

import java.io.IOException;

import java.io.InputStream;

import java.math.BigDecimal;

import java.math.BigInteger;

import java.sql.Timestamp;

import java.util.Date;

import java.util.Properties;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import com.alibaba.fastjson.util.TypeUtils;

/**

* java读取配置文件

*

* @author Neo 2017-5-12

* @version 1.1

*

*/

@SuppressWarnings({ "unchecked", "rawtypes" })

public class PropertiesUtils {

private static Logger logger = LoggerFactory.getLogger(PropertiesUtils.class);

private static Properties properties;

private static final String PROPERTIES_EGIS_FILE_NAME = "application/config.properties";

static {

properties = new Properties();

InputStream scmsStream = null;

try {

scmsStream = PropertiesUtils.class.getClassLoader().getResourceAsStream(PROPERTIES_EGIS_FILE_NAME);

properties.load(scmsStream);

logger.info("PropertiesUtils", "staitc init prop", properties.toString());

} catch (Exception e) {

} finally {

try {

if (scmsStream != null) {

scmsStream.close();

}

} catch (Exception e) {

}

}

}

public static String getProperty(String key) {

String result = properties.getProperty(key);

return result;

}

public static String getProperty(String key, String defaultValue) {

String result = properties.getProperty(key, defaultValue);

return result;

}

public static String getProperties(String propertiesName, String key) {

Properties props = new Properties();

InputStream inputStream = null;

try {

inputStream = PropertiesUtils.class.getClassLoader().getResourceAsStream(propertiesName);

props.load(inputStream);

} catch (IOException e) {

} finally {

try {

if (inputStream != null) {

inputStream.close();

}

} catch (Exception e) {

}

}

return props.getProperty(key);

}

public static Object getObject(String key, Class clazz) {

Object obj = getProperty(key);

return TypeUtils.castToJavaBean(obj, clazz);

}

public static Boolean getBoolean(String key) {

Object value = getProperty(key);

if (value == null)

return null;

else

return TypeUtils.castToBoolean(value);

}

public static byte[] getBytes(String key) {

Object value = getProperty(key);

if (value == null)

return null;

else

return TypeUtils.castToBytes(value);

}

public static boolean getBooleanValue(String key) {

Object value = getProperty(key);

if (value == null)

return false;

else

return TypeUtils.castToBoolean(value).booleanValue();

}

public static Byte getByte(String key) {

Object value = getProperty(key);

return TypeUtils.castToByte(value);

}

public static byte getByteValue(String key) {

Object value = getProperty(key);

if (value == null)

return 0;

else

return TypeUtils.castToByte(value).byteValue();

}

public static Short getShort(String key) {

Object value = getProperty(key);

return TypeUtils.castToShort(value);

}

public static short getShortValue(String key) {

Object value = getProperty(key);

if (value == null)

return 0;

else

return TypeUtils.castToShort(value).shortValue();

}

public static Integer getInteger(String key) {

Object value = getProperty(key);

return TypeUtils.castToInt(value);

}

public static int getIntValue(String key) {

Object value = getProperty(key);

if (value == null)

return 0;

else

return TypeUtils.castToInt(value).intValue();

}

public static Long getLong(String key) {

Object value = getProperty(key);

return TypeUtils.castToLong(value);

}

public static long getLongValue(String key) {

Object value = getProperty(key);

if (value == null)

return 0L;

else

return TypeUtils.castToLong(value).longValue();

}

public static Float getFloat(String key) {

Object value = getProperty(key);

return TypeUtils.castToFloat(value);

}

public static float getFloatValue(String key) {

Object value = getProperty(key);

if (value == null)

return 0.0F;

else

return TypeUtils.castToFloat(value).floatValue();

}

public static Double getDouble(String key) {

Object value = getProperty(key);

return TypeUtils.castToDouble(value);

}

public static double getDoubleValue(String key) {

Object value = getProperty(key);

if (value == null)

return 0.0D;

else

return TypeUtils.castToDouble(value).doubleValue();

}

public static BigDecimal getBigDecimal(String key) {

Object value = getProperty(key);

return TypeUtils.castToBigDecimal(value);

}

public static BigInteger getBigInteger(String key) {

Object value = getProperty(key);

return TypeUtils.castToBigInteger(value);

}

public static String getString(String key) {

Object value = getProperty(key);

if (value == null)

return null;

else

return value.toString();

}

public static Date getDate(String key) {

Object value = getProperty(key);

return TypeUtils.castToDate(value);

}

public static java.sql.Date getSqlDate(String key) {

Object value = getProperty(key);

return TypeUtils.castToSqlDate(value);

}

public static Timestamp getTimestamp(String key) {

Object value = getProperty(key);

return TypeUtils.castToTimestamp(value);

}

public static void main(String[] args) {

if(getBooleanValue("isNeedLogin"))

System.out.println("aaa");

}

}

以上这篇java项目中读取jdbc.properties文件操作就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持脚本之家。