Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

JDBC+MySQLÁ¬½Ó³Ø

1.´´½¨Ò»¸öjava projectÏîÄ¿pooling
2.ΪÏîÄ¿Ìí¼ÓMySQLÁ¬½ÓÇý¶¯
3.ΪÏîÄ¿Ìí¼ÓÒ»¸öÅäÖÃÎļþdbpool.proprerties
Code
driverClassName=com.mysql.jdbc.Driver
username=root
password=
url=jdbc:mysql://localhost:3306/work
poolSize=10
 
4.·Ö±ð´´½¨Ò»¸öÁ¬½ÓÀàConnectionPool.javaºÍÒ»¸ö²âÊÔÀàConnectionPoolTest.java(´úÂë)
 
Code
package webbook.util;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import java.util.Vector;
public class ConnectionPool {
    private Vector<Connection> pool;
    private String url;
    private String username;
    private String password;
    private String driverClassName;
    /**
     * Á¬½Ó³ØµÄ´óС£¬Ò²¾ÍÊÇÁ¬½Ó³ØÖÐÓжàÉÙ¸öÊý¾Ý¿âÁ¬½Ó¡£
     */
    private int poolSize = 1;
    private static ConnectionPool instance = null;
    /**
     * Ë½ÓеĹ¹Ôì·½·¨£¬½ûÖ¹Íⲿ´´½¨±¾ÀàµÄ¶ÔÏó£¬ÒªÏë»ñµÃ±¾ÀàµÄ¶ÔÏó£¬Í¨¹ý<code>getIstance</code>·½·¨¡£
     * Ê¹ÓÃÁËÉè¼ÆÄ£Ê½Öеĵ¥×Óģʽ¡£
     */
    private ConnectionPool() {
        init();
    }
    /**
     * Á¬½Ó³Ø³õʼ»¯·½·¨£¬¶ÁÈ¡ÊôÐÔÎļþµÄÄÚÈÝ ½¨Á¢Á¬½Ó³ØÖеijõʼÁ¬½Ó
     */
    private void init() {
        pool = new Vector<Connection>(poolSize);
    &nb


Ïà¹ØÎĵµ£º

phpѧϰ±Ê¼Ç£¨12£©:PHP+MYSQLÁôÑ԰壨ÏÂ

1¡¢Ìá½»±íµ¥JavascriptÑéÖ¤
<form action="" method="post" name="myform" onsubmit="return CheckPost();">
SCRIPT language=javascript>
function CheckPost()
{
 
if (myform.user.value=="")
 {
  alert("ÇëÌîдÓû§");
  myform.user.focus();
  return f ......

ÓÃpythonÁ¬½ÓmysqlÊý¾Ý¿â


#
-*- encoding: gb2312 -*-
import
os, sys, string
import
MySQLdb
#
Á¬½ÓÊý¾Ý¿â
try
:
conn
=
MySQLdb.connect(host
=
'
localhost
'
,user
=
'
root
'
,passwd
=
'
xxxx
'
,db
=
'
test1
'
)
except
Exception, e:
print
e
sys.exit()
......

MySQLÊÂÎñ´¦Àí

START TRANSACTION, COMMITºÍROLLBACKÓï·¨
START TRANSACTION | BEGIN [WORK]
COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
SET AUTOCOMMIT = {0 | 1}
START
TRANSACTION»òBEGINÓï¾ä¿ÉÒÔ¿ªÊ¼Ò»ÏîеÄÊÂÎñ¡£COMMIT¿ÉÒÔÌá½»µ±Ç°ÊÂÎñ£¬ÊDZä¸ü³ÉΪÓÀ¾Ã±ä¸ü¡£ROLLBACK ......

MysqlÖÐÎÄÂÒÂëÎÊÌâµÄС½á

¸ÅÊö£º
1.ÂÒÂëÎÊÌâ¹é¸ùµ½µ×ÊÇ×Ö·û¼¯µÄÎÊÌâ,ÄǾʹÓ×Ö·û¼¯ÉèÖ÷½Ã濼ÂÇ,²»ÍâºõÏÂÃæ¼¸·½Ã棺
  server(Mysql·þÎñÆ÷),client,database(Êý¾Ý¿â),connection(Á¬½Ó),result
  MySQLµÄ×Ö·û¼¯´¦ÀíÊÇÕâÑùµÄ£º
 £¨1£©·¢ËÍÇëÇó
      ¿Í»§¶Ë(character_set_client£©=¡·Êý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ