Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
  * &


Ïà¹ØÎĵµ£º

½«ÈÕÖ¾ÎļþдÈëMySqLÖÐ

Ê×ÏȽ¨Ò»¸ö¹¤³Ì£¬×¼±¸ºÃÒ»¸ölog4jµÄjar°üºÍÁ¬½ÓMySqLµÄÇý¶¯°ü¡£ÅäÖÃÈçÏ£º
ÐÞ¸Älog4j.propertiesÎļþ£º
######## #´Ë¾äΪ¶¨ÒåÃûΪstdoutµÄÊä³ö¶ËÊÇÄÄÖÖÀàÐÍ£¬¿ÉÒÔÊÇ
#org.apache.log4j.ConsoleAppender£¨¿ØÖÆÌ¨£©£¬
#org.apache.log4j.FileAppender£¨Îļþ£©£¬
#org.apache.log4j.DailyRollingFileAppender£¨Ã¿Ìì²úÉúÒ» ......

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´æ´¢ÒýÇæ

MySQLÓжàÖÖ´æ´¢ÒýÇæ£º
MyISAM¡¢InnoDB¡¢MERGE¡¢MEMORY(HEAP)¡¢BDB(BerkeleyDB)¡¢EXAMPLE¡¢FEDERATED¡¢ARCHIVE¡¢CSV¡¢BLACKHOLE¡£
MySQLÖ§³ÖÊý¸ö´æ´¢ÒýÇæ×÷Ϊ¶Ô²»Í¬±íµÄÀàÐ͵Ĵ¦ÀíÆ÷¡£MySQL´æ´¢ÒýÇæ°üÀ¨´¦ÀíÊÂÎñ°²È«±íµÄÒýÇæºÍ´¦Àí·ÇÊÂÎñ°²È«±íµÄÒýÇæ£º
¡ô MyISAM¹ÜÀí·ÇÊÂÎñ±í¡£ËüÌṩ¸ßËÙ´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡ ......

JSP¾Å´óÄÚÖöÔÏó¼°Ëĸö×÷ÓÃÓò½éÉÜ

JSP¾Å´ó¶ÔÏó£º
ÄÚÖöÔÏó£¨ÓÖ½ÐÒþº¬¶ÔÏó£¬ÓÐ9¸öÄÚÖöÔÏó£©:²»ÐèÒªÔ¤ÏÈÉùÃ÷¾Í¿ÉÒÔÔڽű¾´úÂëºÍ±í´ïʽÖÐËæÒâʹÓÃ
1-out:
javax.servlet.jsp.JspWriterÀàÐÍ£¬´ú±íÊä³öÁ÷µÄ¶ÔÏó¡£×÷ÓÃÓòΪpage£¨Ò³ÃæÖ´ÐÐÆÚ£©
request£ºjavax.servlet.ServletRequestµÄ×ÓÀàÐÍ£¬´Ë¶ÔÏó·â×°ÁËÓÉWEBä¯ÀÀÆ÷»òÆäËü¿Í»§¶ËÉú³ÉµØHTTP
ÇëÇóµÄϸ½Ú£¨² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ