Struts+Hibernate+MySqlÖÐÎÄÂÒÂë½â¾ö·½°¸
1¡¢ÐÞ¸ÄMySqlÊý¾Ý¿âµÄmy.iniÅäÖÃÎļþ¡¢
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3306
default-character-set=GBK
#´Ë´¦Ä¬ÈϱàÂëÐÞ¸ÄΪGBK»òutf-8
# SERVER SECTION
# ----------------------------------------------------------------------
#
2¡¢´´½¨Êý¾Ý±íµÄʱºò
# Ö÷»ú: localhost
# Êý¾Ý¿â: cits
# ±í: 'article'
#
CREATE TABLE `article` (
`article_id` varchar(100) NOT NULL default '0',
`article_title` varchar(100) default NULL,
`domain_id` varchar(100) default NULL,
`article_text` varchar(100) default '',
`good_flg` tinyint(1) default NULL,
`lock_flg` tinyint(1) default NULL,
`top_flg` tinyint(1) default NULL,
`read_times` int(11) default NULL,
`reply_times` int(11) default NULL,
`last_reply` char(6) default NULL,
`last_reply_time` datetime default NULL,
`add_user` varchar(30) default NULL,
`add_date` datetime default NULL,
`upd_user` varchar(30) default NULL,
`upd_date` datetime default NULL,
PRIMARY KEY (`article_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
´Ë´¦ÒªÓÃGBK±àÂë
3¡¢ÔÚjspÒ³ÃæÖÐʹÓÃUTF-8±àÂë
<%
Object init = request.getAttribute("init");
String domainId = (String)request.getAttribute("domainId");
if ((init == null) || (init.equals("")) || (init.equals("null"))) {
response.sendRedirect("./listArticle.do?domainId="+domainId);
} else {
%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import ="java.util.HashMap"%>
<%@ page import ="java.util.List"%>
<%@ page impo
Ïà¹ØÎĵµ£º
Ó¢ÎÄÔÎÄ£º
http://www.packtpub.com/article/visual-mysql-database-design-in-mysql-workbench
ÏÂÃæÊDz¿·Ö·Òë¹ýÀ´µÄ£¬×ªÔØ×Ô£ºhttp://zuolo.info/2008/11/%e4%bd%bf%e7%94%a8-mysql-workbench-%e5%8f%af%e8%a7%86%e5%8c%96%e7%9a%84%e8%ae%be%e8%ae%a1-mysql-%e6%95%b0%e6%8d%ae%e5%ba%93-1%e8%af%91%e6%96%87/
MySQL ......
1¡¢´ò¿ªMyEclipse6.6
2¡¢Ñ¡Ôñ²Ëµ¥£ºWindow/Open Perspective/MyEclipse Database Explorer£¬µã»÷OK£¬ÔÚ×ó±ß´ò¿ªDB Brower´°¿Ú¡£
3¡¢ÔÚDB Brower´°¿ÚÄÚÈÎÒâ¿Õ°×´¦»÷ÓÒ¼ü£¬Ñ¡ÔñNewÃüÁµ¯³öDatabase Driver´°¿Ú
4¡¢±¾´°¿Ú¸÷Ïî˵Ã÷£º
Driver template: MySQL Connector/J Ñ¡ÔñÇý¶¯Ä£°å
& ......
×ܽáÁËһЩMySQLÓÅ»¯·½ÃæµÄ¼¼ÇÉ
Ò». Æô¶¯²ÎÊýÓÅ»¯
ÐÞ¸Ä my.cnf (»òÕßmy.ini)£¬¼ÓÈë/ÐÞ¸ÄÒÔϼ¸ÐÐ
#É趨»º´æµÄÁ¬½ÓÊý,½ÚÊ¡Á¬½ÓʱµÄ¿ªÏú
back_log = 64
#½ûÓÃÎļþϵͳÍâ²¿Ëø
external-locking = 0
#½ûÓÃBDB,Èç¹ûÄãȷʵ²»ÐèÒªµÄ»°,innodbÒ²ÊÇÈç´Ë
skip-bdb
#Ë÷Òý»º³å,Èç¹ûÊÇרÓõÄÊý¾Ý¿â·þÎñÆ÷,¿ÉÒÔÉèÖøߴï·þÎñÆ÷ÄÚ´ ......
Ò»Ö±ÒÔÀ´ÎÒµÄÎÄÕ¶¼ÊÇÒÔ¹¤×÷±Ê¼ÇµÄÐÎʽ´æÔÚ¡£Õâ¶ÔÓÚ×Ô¼º¶ÁÆðÀ´Ã»Ê²Ã´´ó°£¬µ«ÊǶÔÓÚÆäËû¶ÁÕß¿ÉÄܾÍÓÐЩÃÔã¡£ÎÒ¾¡Á¿¸Ä¸Ä£¬»»ÖÖ·½Ê½¡£
1. MySQL µÄ°æ±¾
Èç¹ûÒªÖ§³Ö·ÖÇø±í£¬ÔòÓ¦¸ÃʹÓà 5.1.x ÒÔÉϵİ汾¡£Èç
mysql> show variables like '%version%';
+-------------------------+------------------------------ ......