BasicDataSource连接池
来源:互联网 发布:淘宝产品后期视频 编辑:程序博客网 时间:2024/05/22 11:44
package org.apache.nutch.fetcher;
import org.apache.commons.dbcp.BasicDataSource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.mozilla.universalchardet.UniversalDetector;
/**
*
* @author hu
*/
public class DBHelper {
public static JdbcTemplate template;
public static String guessEncoding(byte[] bytes) {
String DEFAULT_ENCODING = "UTF-8";
UniversalDetector detector = new UniversalDetector(null);
detector.handleData(bytes, 0, bytes.length);
detector.dataEnd();
String encoding = detector.getDetectedCharset();
detector.reset();
if (encoding == null) {
encoding = DEFAULT_ENCODING;
}
return encoding;
}
static {
/*
Logger logger = Logger.getLogger("org.springframework.jdbc.core.JdbcTemplate");
ConsoleAppender ca = new ConsoleAppender();
ca.setName("default");
ca.setWriter(new PrintWriter(System.out));
ca.setLayout(new PatternLayout("%d{yyyy-MM-dd HH:mm:ss} %p %c %x - %m%n "));
logger.addAppender(ca);
Logger.getLogger("org.springframework.jdbc.datasource.DataSourceUtils").addAppender(ca);
*/
BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/nutch?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf8");
dataSource.setUsername("root");
dataSource.setPassword("");
dataSource.setInitialSize(10);
dataSource.setMaxActive(25);
template = new JdbcTemplate(dataSource);
}
public static int addArticle(String url,byte[] content) throws Exception{
String charset=guessEncoding(content);
String html=new String(content,charset);
return template.update("insert into tb_content (url,html) value (?,?)",url,html);
}
}
import org.apache.commons.dbcp.BasicDataSource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.mozilla.universalchardet.UniversalDetector;
/**
*
* @author hu
*/
public class DBHelper {
public static JdbcTemplate template;
public static String guessEncoding(byte[] bytes) {
String DEFAULT_ENCODING = "UTF-8";
UniversalDetector detector = new UniversalDetector(null);
detector.handleData(bytes, 0, bytes.length);
detector.dataEnd();
String encoding = detector.getDetectedCharset();
detector.reset();
if (encoding == null) {
encoding = DEFAULT_ENCODING;
}
return encoding;
}
static {
/*
Logger logger = Logger.getLogger("org.springframework.jdbc.core.JdbcTemplate");
ConsoleAppender ca = new ConsoleAppender();
ca.setName("default");
ca.setWriter(new PrintWriter(System.out));
ca.setLayout(new PatternLayout("%d{yyyy-MM-dd HH:mm:ss} %p %c %x - %m%n "));
logger.addAppender(ca);
Logger.getLogger("org.springframework.jdbc.datasource.DataSourceUtils").addAppender(ca);
*/
BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/nutch?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf8");
dataSource.setUsername("root");
dataSource.setPassword("");
dataSource.setInitialSize(10);
dataSource.setMaxActive(25);
template = new JdbcTemplate(dataSource);
}
public static int addArticle(String url,byte[] content) throws Exception{
String charset=guessEncoding(content);
String html=new String(content,charset);
return template.update("insert into tb_content (url,html) value (?,?)",url,html);
}
}
0 0
- BasicDataSource连接池
- BasicDataSource连接池使用
- BasicDataSource\DruidDataSource连接池使用
- Jakarta的公共连接池实现 - BasicDataSource
- DBCP连接池:BasicDataSource源码解读
- dbcp BasicDataSource 连接池获取连接过程源码分析
- org.apache.commons.dbcp.BasicDataSource连接池配备属性
- org.apache.commons.dbcp.BasicDataSource连接池配备属性
- org.apache.commons.dbcp.BasicDataSource连接池配备属性
- hibernate中dbcp.BasicDataSource连接池配备属性
- hibernate中dbcp.BasicDataSource连接池配备属性
- org.apache.commons.dbcp.BasicDataSource连接池配备属性
- BasicDataSource
- BasicDataSource
- org.apache.commons.dbcp.BasicDataSource 连接池配备属性解析及范例
- MySQL---数据库从入门走向大神系列(十三)-BasicDataSource创建DataSource(DBCP连接池配置)
- java读取properties文件,通过数据池(BasicDataSource)连接mysql数据库
- BasicDataSource的池配置属性
- 数据库为何要建立索引的原因说明
- 阿里面试 事件委托
- angular与datatables 的结合(二)
- linux环境下java swing中文乱码
- 忆苦思甜之飘香猪尾
- BasicDataSource连接池
- Oracle分析函数入门
- 【Financail Markets】3. Spot Rate Curve及衍生出的Par Yield Curve和Instantaneous Forward Curve 【基于ECB数据】
- WebView设置适应屏幕和缩放
- db2 "list applications"
- MySQL数据库服务器双机热备的实现方法两则
- Linux主机信任关系配置(无密码登陆)
- wince 5.0 Platform Builder 5.0 下载地址
- jsp文件报错