易截截图软件、单文件、免安装、纯绿色、仅160KB

JSP数据库连接疑问(Mysql)

package com.wxpn.tutorial.db;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.SQLWarning;
import java.sql.Statement;
import java.util.Date;
/**
 * 描述: 数据库连接池类
 * 
 * 
 * @version 1.0
 */
public class ConnectionPool implements Runnable {
 private boolean _debug = false;
 private Thread runner;
 private Connection[] connPool;
 private int[] connStatus; // (0) available; (1) locked by the client; (2)
 // locked by the housekeeping thread
 private long[] connLockTime;
 private long[] connCreateTime;
 private String[] connID;
 private String dbdriver, dbserver, dbuser, dbpassword;
 private int currConnections, connLast, minconns, maxconns, maxconnMSec;
 // available: set to false on destroy, checked by getConnection()
 private boolean available = true;
 private SQLWarning currSQLWarning;
 /**
  * Creates a new Connection Broker<br>
  *
  * @param dbdriver
  *            JDBC driver. e.g. 'oracle.jdbc.driver.OracleDriver'<br>
  * @param dbserver
  *            JDBC connect string. e.g.
  *            'jdbc:oracle:thin:@203.92.21.109:1526:orcl'<br>
  * @param dbuser
  *            Database login name. e.g. 'Scott'<br>
  * @param dbpassword
  *            Database password. e.g. 'Tiger'<br>
  * @param minconns
  *            Minimum number of connections to start with.<br>
  * @param maxconns
  * &


相关文档:

JSP语法详解

HTML 注释
在客户端显示一个注释.
JSP 语法
<!-- comment [ <%= expression %> ] -->
例子 1
<!-- This file displays the user login screen -->
在客户端的HTML源代码中产生和上面一样的数据:
<!-- This file displays the user login screen -->
例子 2
<!-- This page was ......

如何提高mysql load data infile的速度


版权声明
:转载时请以超链接形式标明文章原始出处和作者信息及本声明
http://bbayou.blogbus.com/logs/37045617.html
测试数据2.5G,共有数据9427567条。用的mysql的large服务器的配置。
load
一次需要大概10分钟左右。
建的表用的是MYISAM,调整了几个session的参数值
SET

SESSION

BULK_INSERT_BUFFER_S ......

一个 mysql server 上的小技巧

转自http://www.linuxbyte.org/yi-ge-mysql-server-shang-de-xiao-ji-qiao.html
在my.cnf 的 mysql 端 添加如下设置
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
prompt="(\u:mysql1@linuxbyte.org \R:\m)[\d]: "
会产生如下效果:
root@ubuntu:/home/hew# mysql -u hew -p
Enter pass ......

mysql流程函数

MySQL中的流程函数
函数
功能
IF(value,t ,f)
如果value为真,返回t,否则返回f
IFNULL(value1,value2)
如果value1不为空返回value1,否则返回value2
CASE WHEN [value1] THEN [result1] … ELSE [default] END
如果value1为真 返回result2 否则返回default
CASE [expr] WHEN [value1] THEN [result1] &helli ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号