jboss+mysqlÅäÖÃÊÖ²á
×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳ(jboss)°²×°Î¬»¤ÊÖ²á
1.Èí¼þ¸ÅÊö
1.1×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳÊÇ»ùÓÚASPÔËӪģʽµÄÆóÒµÔËÓª¹ÜÀíƽ̨ϵͳ£¬ÓɶÀÁ¢µÄÓ¦Ó÷þÎñÆ÷·Ö±ðÌṩͳһÔËÓª¹ÜÀí¹¦ÄÜ¡¢
¸÷²úÆ·ÔËӪϵͳµÄ¹¦ÄÜ¡£
1.2¿ª·¢ÓïÑÔ
±¾ÏµÍ³²ÉÓÃJ2EE¼¼Êõ¼Ü¹¹£¬Ê¹Óõ½java, xml, xsl£¬javascript£¬htmlµÈ¸÷Ïî¼¼Êõ£¬Êý¾Ý¿âʹÓÃMySQL
2.ÔËÐл·¾³¼°°²×°ËµÃ÷
2.1Ó²¼þ˵Ã÷ËùÐèÓ²¼þÉ豸Áбí
Ó²Å̿ռ䣺80GB
CPU£ºË«ÖÁÇ¿2GHZ
RAM£º2GB
2.2 Èí¼þϵͳ˵Ã÷
²Ù×÷ϵͳ£º °æ±¾
redhat AS4
JAVA£¨J2SDK£© °æ±¾
SUN J2SDK For Linux 1.4.2_06
Ó¦Ó÷þÎñÆ÷ °æ±¾
jboss Application Server 4.0.1
Êý¾Ý¿â·þÎñÆ÷ °æ±¾
MySQL 5.0.21
¿Í»§¶Ëä¯ÀÀÆ÷ °æ±¾
Internet Explorer 5.0(°æ±¾£º5.00.3700.1000)»òÒÔÉÏ
2.3 Linux»·¾³°²×°²½Öè˵Ã÷
·ÖÇø &nb
Ïà¹ØÎĵµ£º
ÔÚÎÒÃÇ»ú·¿ÉϿεÄʱºò£¬ÀÏʦÈÃ×Ô¼º×ö ͼͼƬ ³ö¿â ºÍÈë¿â £¬°¥ £¬ ×ø×Å×ø×Å £¬½¨±íMYSQL ÃüÁîÐÐģʽ£¬Óиö´æ´¢ ͼƬµÄ×ֶΠ×Ô¼º²»ÊìϤ£¬ÓÐûÓÐMysql µÄAPIÎĵµ£¬ ÈçºÎ°ì ÎÊͬѧ ͬѧҲ²»ÖªµÀ¡£
ºÇºÇ ÏëÆðÁË DOSµÄ°ïÖú ´òÁËÒ»¸ö Help ºÇºÇ ³öÏÖÁË ºÃ¶à¶«Î÷
ÔÙ°´ÕÕÌáʾ £ºhelp create table ºÇºÇ Ï ......
½¨Á¢Êý¾Ý¿â£º
ÎÒµÄÊý¾Ý¿âimages
create table img (
id int primary key auto_increment,
name varchar(80),
pic longblob
)
Òª±£Ö¤ÍøÕ¾¸ùĿ¼ Óиö images Îļþ¼Ð
²åÈëÊý¾Ý¿â ´Ó±¾µØÎļþ¼Ð
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*,java.io.*" ......
×¢Ò⣺֮ǰÎÒÔÚÍøÉÏÕÒÁ˺öàµÄ×ÊÁÏ NND¶¼²»ÄÜÕý³£ÅäÖóɹ¦ ¸ãµÃÎÒÊǷdz£µØÓôÃÆ£¡
ÕÒµ½ÕâƪÎÄÕÂÖ®ºóÎÒÖÕÓÚÅäÖóɹ¦ÁË£¡ÍÛºÃˬѽ£¡Ö»Òª°´ÕÕ ÉÏÃæµÄ²½Öè¾ÍÒ»¶¨Äܹ»³É¹¦µÄ£¡
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XPϵÄApache+PHP+MySQL°²×°£¬Í¬Ê±Ò²ÊÊÓÃÓÚWindows 2003ϵͳϵݲװºÍÅäÖá£
1. °²×°»·¾³
²Ù×÷ϵͳÊÇ Window ......
¹²3¸öÎļþ
IncDB.phpÊý¾Ý¿âÁ¬½Ó
index.phpÊ×Ò³
InsetToDB.phpÊý¾Ý¿â²Ù×÷
Êý¾Ý¿âlguestbookÀïÃ潨±í
CREATE TABLE `intd` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) character set utf8 collate utf8_bin N ......
Ìí¼Ó×ֶΣº
MYSQL
alter table tb add col2 varchar(10)
MSSQL2000
alter table tb add col2 varchar(10)
ÐÞ¸Ä×ֶΣº
MYSQL
alter table tb modify col2 varchar(20)
MSSQL2000
alter table tb alter column col2 varchar(20)
ɾ³ý×ֶΣº
MYSQL
alter table tb drop column col ......