Ò»¸öMYsqlÀà
<?php
class mysql {
/*+++++++++++++++Êý¾Ý¿â·ÃÎÊÀà++++++++++++++++++++++++++
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
*/
//=================================================
//Á¬½ÓÊý¾Ý
private $Host = "localhost"; //·þÎñÆ÷µØÖ·
private $Database = "sansu"; //Êý¾Ý¿âÃû³Æ
private $User = "root"; //Óû§Ãû
private $Password = "czq339403229"; //Óû§ÃÜÂë
private $Char_Set = "utf8"; //ÉèÖÃÊý¾Ý¿â×Ö·û¼¯
//½á¹ûÊý¾Ý
public $Link_ID = 0; //Êý¾Ý¿âÁ¬½Ó
public $Query_ID = 0; //²éѯ½á¹û
public $Row_Result = array(); //½á¹û½Ú×é³ÉµÄÊý×é
public $Field_Result = array(); //½á¹û¼¯×Ö¶Î×é³ÉµÄÊý×é
// public $Affected_Rows=null; //Ó°ÏìµÄÐÐÊý
// public $Rows = null; //½á¹û¼¯ÐÐÊý
// public $Fields = null; //½á¹û¼¯×Ö¶ÎÊý
// public $Row_Position = null; //¼Ç¼ָÕëλÖÃË÷Òý
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
// _______________________________________________________________
/*
+++++++++++¹¹Ô캯Êý++++++++++++++++
+++++++++++++++
Ïà¹ØÎĵµ£º
Ê×ÏȰ²×°phpMyadmin
[root@aladdin phpMyAdmin]# uname -a
Linux aladdin.leadtek.com.cn 2.6.32.11-99.fc12.i686.PAE #1 SMP Mon Apr 5 16:15:03 EDT 2010 i686 i686 i386 GNU/Linux
[root@aladdin phpMyAdmin]# yum info phpmyadmin
Loaded plugins: presto, refresh-packagekit
Installed Packages
Name &nbs ......
<!--
/* Font Definitions */
@font-face
{font-family:Courier;
panose-1:2 7 4 9 2 2 5 2 4 4;
mso-font-alt:"Courier New";
mso-font-charset:0;
mso-generic-font-family:modern;
mso-font-format:other;
mso-font-pitch:fixed;
mso-font-signature:3 0 0 0 1 0;}
@font-face
{f ......
°²×° MySQL£¬¿ÉÒÔÔÚÖÕ¶ËÌáʾ·ûºóÔËÐÐÏÂÁÐÃüÁ
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install php5-mysql
// °²×°php5-mysql Êǽ«phpºÍmysqlÁ¬½ÓÆðÀ´
Ò»µ©°²×°Íê³É£¬MySQL ·þÎñÆ÷Ó¦¸Ã×Ô¶¯Æô¶¯¡£Äú¿ÉÒÔÔÚÖÕ¶ËÌáʾ·ûºóÔËÐÐÒÔÏÂÃüÁîÀ´¼ì²é MySQL ·þÎñÆ÷ÊÇ·ñÕýÔÚÔËÐУº
s ......
ÓÉÓÚǰ¶Îʱ¼äÒªÓÃpowerdesignerÉè¼ÆÊý¾Ý¿â£¬¿ÉÊý¾Ý¿âÉè¼ÆºÃºóºÃµ¼ÈëMysQLʱÐèÒªODBCÁ¬½Ó£¬¶øMysQL5.0ÒÔÉϵľùÒªÐÞ¸ÄÃÜÂ루ÎÒÔÚÍøÉϲé¹ý£©£¬°´ËûÃǵÄÒâ˼ÐÞ¸ÄÁËrootÃÜÂ룬½á¹ûÊÇÖ±½Ó½ø²»ÁËMysQLÁË£¬ÎÒÄǸöÓôÃÆ£¬ÔÚÍøÉϲéÕÒ×ÊÁÏ£¬Ò²°´ËûÃǵķ½·¨×öÁË£¬¿É»¹ÊDz»ÐУ¨±¾È˶Ôdos²»Ê죩¡£µ«×îÖÕ»¹ÊÇ¿ÉÒÔÁË£¬ÏÂÃæËµÏ¾ßÌå·½·¨
1¡¢w ......
tomcat °²×°Ä¿Â¼ÏµÄconfĿ¼ÖеÄcontext.xmlÓëweb.xmlÎļþ·Ö±ðÐÞ¸ÄÈçÏ£º
context.xml мÓÈçÏÂÄÚÈÝ£º
<Resource name="jdbc/mysql"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://Êý¾Ý¿âµØÖ·:3306/Êý¾Ý¿âà ......