JavaÊý¾Ý¿âÁ¬½Ó³Ø
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Enumeration;
import java.util.Vector;
/*ËäÈ»ÏÖÔÚÓÃAPACHE COMMONS DBCP¿ÉÒԷdz£·½±ãµÄ½¨Á¢Êý¾Ý¿âÁ¬½Ó³Ø£¬
µ«ÊÇÏñÕâÆªÎÄÕ°ÑÊý¾Ý¿âÁ¬½Ó³ØµÄÄÚ²¿ÔÀíдµÄÕâô͸³¹£¬×¢ÊÓÕâôÍêÕû£¬
ÕæÊǷdz£Äѵã¬Èÿª·¢ÈËÔ±¿ÉÒÔ¸üÉî²ã´ÎµÄÀí½âÊý¾Ý¿âÁ¬½Ó³Ø£¬ÕæÊǷdz£¸Ð
лÕâÆªÎÄÕµÄ×÷Õß¡£*/
public class ConnectionPool {
private String jdbcDriver = ""; // Êý¾Ý¿âÇý¶¯
private String dbUrl = ""; // Êý¾Ý URL
private String dbUsername = ""; // Êý¾Ý¿âÓû§Ãû
private String dbPassword = ""; // Êý¾Ý¿âÓû§ÃÜÂë
private String testTable = ""; // ²âÊÔÁ¬½ÓÊÇ·ñ¿ÉÓõIJâÊÔ±íÃû£¬Ä¬ÈÏûÓвâÊÔ±í
private int initialConnections = 10; // Á¬½Ó³ØµÄ³õʼ´óС
private int incrementalConnections = 5;// Á¬½Ó³Ø×Ô¶¯Ôö¼ÓµÄ´óС
private int maxConnections = 50; // Á¬½Ó³Ø×î´óµÄ´óС
private Vector connections = null; // ´æ·ÅÁ¬½Ó³ØÖÐÊý¾Ý¿âÁ¬½ÓµÄÏòÁ¿ , ³õʼʱΪ null
// ËüÖдæ·ÅµÄ¶ÔÏóΪ PooledConnection ÐÍ
/**
* ¹¹Ô캯Êý
*
* @param jdbcDriver String JDBC Çý¶¯Àà´®
* @param dbUrl String Êý¾Ý¿â URL
* @param dbUsername String Á¬½ÓÊý¾Ý¿âÓû§Ãû
* @param dbPassword String Á¬½ÓÊý¾Ý¿âÓû§µÄÃÜÂë
*
*/
public ConnectionPool(String jdbcDriver, String dbUrl, String dbUsername,
String dbPassword) {
this.jdbcDriver = jdbcDriver;
this.dbUrl = dbUrl;
this.dbUsername = dbUsername;
this.dbPassword = dbPassword;
try {
createPool();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* ·µ»ØÁ¬½Ó³ØµÄ³õʼ´óС
*
* @return ³õʼÁ¬½Ó³ØÖпɻñµÃµÄÁ¬½ÓÊýÁ¿
*/
public int getInitialConnections() {
return this.initialConnections;
}
/**
* ÉèÖÃÁ¬½Ó³ØµÄ³õʼ´óС
*
* @param ÓÃÓÚÉèÖóõʼÁ¬½Ó³ØÖÐÁ¬½ÓµÄÊýÁ¿
*/
public void setInitialConnections(int initialConnections) {
this.initialConnections = initialConnections;
}
/**
* ·µ»ØÁ¬½Ó³Ø×Ô¶¯Ôö¼ÓµÄ´óС
Ïà¹ØÎĵµ£º
ÔÎijö´¦£ºhttp://developers.sun.com/techtopics/mobility/midp/articles/wtk23beta/
Sun Java Wireless ToolkitÔ½À´Ô½ºÃ£¬2.3beta°æ±¾Ôö¼ÓÁ˶ÔÓÚÈýÖÖеÄAPIµÄÖ§³Ö£º
l The Security and Trust Services APIs (SATSA, ......
StrutsME Ò»¸öÇáÁ¿¼¶µÄÐòÁл¯ÐÒ飬ʹJ2ME¿Í»§¶ËÄܵ÷ÓÃStruts WebÓ¦ÓóÌÐò¡£
http://www.strutsme.org/
JsonME ÇáÁ¿¼¶ÊµÏÖJ2ME Json¡£
http://www.json.org/java/org.json.me.zip
MicroLog ÇáÁ¿¼¶µÄLOG
http://microlog.sourceforge.net/snapshot
Mobile Ajax for Java ME °üÀ¨ÁËXmlHttpRequest£¬jsonµÄÒ ......
Mysql
sudo netstat -tap | grep mysql
µ±ÄúÔËÐиÃÃüÁîʱ£¬Äú¿ÉÒÔ¿´µ½ÀàËÆÏÂÃæµÄÐУº
linuxidc@linuxidc-laptop:~$">linuxidc@linuxidc-laptop:~$ sudo netstat -tap | grep mysql
[sudo] password for linuxidc:
tcp &n ......
Java ¾²Ì¬´úÀíºÍ¶¯Ì¬´úÀí
http://kuangbaoxu.javaeye.com/blog/192804
¹Ø¼ü×Ö: ¾²Ì¬´úÀíÓ붯̬´úÀí
1. ´úÀíģʽÖ÷ÒªÓÐÁ½ÖÖ£º¾²Ì¬´úÀíºÍ¶¯Ì¬´úÀí
2. ¾²Ì¬´úÀí£º
±ÈÈçÒªÔÚÊä³ö“HelloWorld”ǰ´òÓ¡Ò»¸ö×Ö·û´®“Welcome”
A:Ïȶ¨ÒåÒ»¸ö½Ó¿ÚÀà
Java´úÂë
pac ......
package com.chinacache.boss.queryservice.service.impl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import com.chinacache.boss.queryservice.excepti ......