druid数据源例子

来源：互联网发布：全民淘宝客是真的吗编辑：程序博客网时间：2024/04/29 07:37

引入所需要的jar包

 <dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>1.0.11</version></dependency>

创建属性文件

druid_system_dev.propertiesdriverClassName = com.mysql.jdbc.Driverurl = jdbc:mysql://ip:3306/db?useUnicode=true&characterEncoding=utf8username = testpassword = WI9nfppbYoWXxB6iVcdXWk3BJM+qfOkBNgDdEZ3yeYEyPWniw8hLcDG6k#这个密码是通过加密后的密码，加密方法：找到 druid-0.2.9.jar所在目录，#执行 java -cp druid-0.2.9.jar com.alibaba.druid.filter.config.ConfigTools you_password #加密initialSize = 5maxActive = 10minIdle = 3maxWait = 60000removeAbandoned = trueremoveAbandonedTimeout = 180timeBetweenEvictionRunsMillis = 60000minEvictableIdleTimeMillis = 300000validationQuery = SELECT 1 FROM DUALtestWhileIdle = truetestOnBorrow = falsetestOnReturn = falsepoolPreparedStatements = truemaxPoolPreparedStatementPerConnectionSize = 50filters = configconnectionProperties = config.decrypt=true

java代码

InputStream in = Database.class.getClassLoader().getResourceAsStream();Properties props = new Properties("druid_system_dev.properties");props.load(in);DataSource ds = DruidDataSourceFactory.createDataSource(props);Connection connection = ds.getConnection();String sql = "select * from a";PreparedStatement prepstmt = connection.prepareStatement(sql);ResultSet rs = prepstmt.executeQuery(sql);

0 0