mysql2derby

mofeichen

将mysql数据库中的数据导入到derby数据库
1.将Mysql中的数据导出为sql文件（c:\>mysqldump -h localhost -u root -p mydb >e:\mysql\mydb.sql ）
    -- MySQL dump 10.10---- Host: localhost    Database: j2ee-- -------------------------------------------------------- Server version    5.0.22-community-nt/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `t_accountitem`--DROP TABLE IF EXISTS `t_accountitem`;CREATE TABLE `t_accountitem` (  `id` varchar(255) NOT NULL,  `transcode` varchar(255) default NULL,  `transDate` varchar(255) default NULL,  `transTime` varchar(255) default NULL,  `itemAmount` varchar(50) default NULL,  `acountType` varchar(255) default NULL,  `accountID` varchar(255) default NULL,  `projectTypeID` varchar(255) default NULL,  PRIMARY KEY  (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;---- Dumping data for table `t_accountitem`--/*!40000 ALTER TABLE `t_accountitem` DISABLE KEYS */;LOCK TABLES `t_accountitem` WRITE;INSERT INTO `t_accountitem` VALUES ('SNAI20090725000004','SNAI20090725000004','2009-07-25','14:24:17','200','1','SNTA20090724000000','SNPI20090725000004'),('SNAI20090725000005','SNAI20090725000005','2009-07-17','14:24:38','6000','1','SNTA20090724000000','SNPI20090724000000'),('SNAI20090725000006','SNAI20090725000006','2009-07-16','20:10:04','900','1','SNTA20090724000000','SNPI20090725000004'),('SNAI20090725000007','SNAI20090725000007','2009-07-23','20:10:16','500','0','SNTA20090724000000','SNPI20090724000002'),('SNAI20090729000008','SNAI20090729000008','2005-07-08','09:54:03','4000','1','SNTA20090724000000','SNPI20090724000000'),('SNAI20090729000009','SNAI20090729000009','2005-07-08','09:54:23','500','0','SNTA20090724000000','SNPI20090724000003'),('SNAI20090729000010','SNAI20090729000010','2006-07-11','09:54:44','6000','1','SNTA20090724000000','SNPI20090724000001'),('SNAI20090729000012','SNAI20090729000012','2007-07-14','10:00:09','5000','1','SNTA20090724000000','SNPI20090724000000'),('SNAI20090729000013','SNAI20090729000013','2007-07-20','10:00:22','800','0','SNTA20090724000000','SNPI20090724000003'),('SNAI20090729000014','SNAI20090729000014','2007-07-19','10:04:57','800','0','SNTA20090724000000','SNPI20090724000002'),('SNAI20090729000015','SNAI20090729000015','2008-07-04','10:05:11','9000','1','SNTA20090724000000','SNPI20090724000000'),('SNAI20090729000016','SNAI20090729000016','2009-07-14','10:05:25','1200','0','SNTA20090724000000','SNPI20090724000002'),('SNAI20090729000017','SNAI20090729000017','2008-07-23','10:11:44','900','0','SNTA20090724000000','SNPI20090724000002'),('SNAI20090729000018','SNAI20090729000018','2008-07-09','10:31:00','500','1','SNTA20090724000000','SNPI20090724000001'),('SNAI20090729000019','SNAI20090729000019','2007-07-09','10:31:13','300','0','SNTA20090724000000','SNPI20090724000003'),('SNAI20090729000020','SNAI20090729000020','2006-07-10','10:31:32','600','1','SNTA20090724000000','SNPI20090724000001'),('SNAI20090729000022','SNAI20090729000022','2009-07-12','10:31:51','600','1','SNTA20090724000000','SNPI20090724000001'),('SNAI20090729000023','SNAI20090729000023','2009-07-16','12:42:06','3000','1','SNTA20090724000000','SNPI20090724000000'),('SNAI20090806000022','SNAI20090806000022','2009-08-05','15:16:25','900','0','SNTA20090724000000','SNPI20090724000003');UNLOCK TABLES;/*!40000 ALTER TABLE `t_accountitem` ENABLE KEYS */;---- Table structure for table `t_projectitem`--DROP TABLE IF EXISTS `t_projectitem`;CREATE TABLE `t_projectitem` (  `id` varchar(255) NOT NULL,  `projectID` varchar(255) default NULL,  `projectName` varchar(255) default NULL,  `acountType` varchar(255) default NULL,  PRIMARY KEY  (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;---- Dumping data for table `t_projectitem`--/*!40000 ALTER TABLE `t_projectitem` DISABLE KEYS */;LOCK TABLES `t_projectitem` WRITE;INSERT INTO `t_projectitem` VALUES ('SNPI20090724000000','2009072413:19:18','工资','1'), ('SNPI20090724000001','2009072413:30:41','奖金','1'), ('SNPI20090724000002','2009072413:30:48','交通','0'), ('SNPI20090724000003','2009072413:30:57','食宿','0'), ('SNPI20090725000004','2009072514:23:51','压岁钱','1'), ('SNPI20090729000005','2009072921:15:44','旅游','0');UNLOCK TABLES;/*!40000 ALTER TABLE `t_projectitem` ENABLE KEYS */;---- Table structure for table `t_totalaccount`--DROP TABLE IF EXISTS `t_totalaccount`;CREATE TABLE `t_totalaccount` (  `id` varchar(255) NOT NULL,  `accountID` varchar(255) default NULL,  `customerName` varchar(255) default NULL,  `amount` varchar(255) default NULL,  PRIMARY KEY  (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;---- Dumping data for table `t_totalaccount`--/*!40000 ALTER TABLE `t_totalaccount` DISABLE KEYS */;LOCK TABLES `t_totalaccount` WRITE;INSERT INTO `t_totalaccount` VALUES ('SNTA20090724000000','20090724','sjs','31100');UNLOCK TABLES;/*!40000 ALTER TABLE `t_totalaccount` ENABLE KEYS */;---- Table structure for table `t_user`--DROP TABLE IF EXISTS `t_user`;CREATE TABLE `t_user` (  `id` varchar(255) NOT NULL,  `uname` varchar(255) default NULL,  `password` varchar(255) default NULL,  PRIMARY KEY  (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;---- Dumping data for table `t_user`--/*!40000 ALTER TABLE `t_user` DISABLE KEYS */;LOCK TABLES `t_user` WRITE;INSERT INTO `t_user` VALUES ('SNUS20090724000000','sjs','sjs'),('SNUS20090724000001','lx','lx'), ('SNUS20090729000002','孙萌','123456'),('SNUS20090729000003','王璐 ','123458'),('SNUS20090729000004','张立','789456'),('SNUS20090729000005',' 孙亮','456789'),('SNUS20090729000006','田亮','123654'), ('SNUS20090729000007','周正','789654'),('SNUS20090729000008','朱芳 ','456987'),('SNUS20090801000009','qqq','qqq');UNLOCK TABLES;/*!40000 ALTER TABLE `t_user` ENABLE KEYS */;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 


2.修改导出的mydb.sql文件
 
  （1）去掉注释部分的的内容（即--和/**/）
  （2）删除DROP TABLE IF EXISTS `t_totalaccount`;和LOCK TABLES `t_user` WRITE;
  （3）对于剩余部分的内容，表名和字段名需要去掉“`”(即Esc键子下方的字符)
  （4）去掉ENGINE=InnoDB DEFAULT CHARSET=utf8;字符部分