Delphi2007中用DbExpress连接MySql的例子

2008-04-18 08:56:47　来源:中国自学编程网　作者:佚名点击:

新建数据库/**//*
MySQL Data Transfer
Source Host: localhost
Source Database: blog
Target Host: localhost
Target Database: blog
Date: 2008/04/15 16:18:41
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for posts
-- ----------------------------
CREATE TABLE `posts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(50) default NULL,
  `body` text,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `posts` VALUES (’1’, ’The title’, ’This is the post body.’, ’2008-04-08 11:51:46’, null);
INSERT INTO `posts` VALUES (’2’, ’A title once again’, ’And the post body follows.’, ’2008-04-08 11:51:46’, null);
INSERT INTO `posts` VALUES (’3’, ’Title strikes back’, ’This is really exciting! Not.’, ’2008-04-08 11:51:46’, null);

Delphi2007中新建工程，页面上追加TSimpleDataSet及TDataSource控件。

然后做如下设置