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

时间:2021-05-19

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.Driverjdbc.url = jdbc\:mysql\://127.0.0.1\:3306/LY?useUnicode\=true&characterEncoding\=UTF-8&zeroDateTimeBehavior\=convertToNull&allowMultiQueries\=truejdbc.username = rootjdbc.password = rootjdbc.minPoolSize=2jdbc.maxPoolSize=20jdbc.checkoutTimeout=3000jdbc.maxStatements=50jdbc.testConnectionOnCheckin = falsejdbc.idleConnectionTestPeriod =18000

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

1.依赖于:fastjson

<dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>1.2.39</version></dependency>

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文件操作就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持。

声明:本页内容来源网络,仅供用户参考;我单位不保证亦不表示资料全面及准确无误,也不保证亦不表示这些资料为最新信息,如因任何原因,本网内容或者用户因倚赖本网内容造成任何损失或损害,我单位将不会负任何法律责任。如涉及版权问题,请提交至online#300.cn邮箱联系删除。

相关文章