【Mon Aug 29 2016 13:34:21 GMT+0800】
1 CREATE TABLE `customers` ( 2 `id` int(11) NOT NULL auto_increment, 3 `name` varchar(30) NOT NULL, 4 `address` varchar(30) default ‘‘, 5 `phone` varchar(30) default ‘‘, 6 `email` varchar(30) default ‘‘, 7 `birth` date default NULL, 8 PRIMARY KEY (`id`), 9 UNIQUE KEY `name` (`name`) 10 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
001-通过Driver接口获取数据库连接
Driver 是一个接口: 数据库厂商必须提供实现的接口. 能从其中获取数据库连接。
可以通过 Driver的实现类对象获取数据库连接。
1. 加入MySQL驱动
⑴解压"mysql-connector-java-5.1.7.zip"。
⑵在当前项目下新建"lib"目录。
⑶把"mysql-connector-java-5.1.7-bin.jar"复制到lib目录下。
⑷右键"Build Path"→"Add to Build Path"加入到类路径下。
1 package com.atguigu.jdbc; 2 3 import java.sql.Connection; 4 import java.sql.Driver; 5 import java.sql.SQLException; 6 import java.util.Properties; 7 8 import org.junit.Test; 9 10 public class JDBCTest1 { 11 @Test 12 public void testDriver() throws SQLException { 13 //1. 创建一个 Driver实现类的对象 14 Driver driver = new com.mysql.jdbc.Driver(); 15 //2. 准备连接数据库的基本信息: url、user、password 16 String url = "jdbc:mysql://localhost:3306/atguigu"; 17 Properties info = new Properties(); 18 info.put("user", "root"); 19 info.put("password", "123456"); 20 //3. 调用 Driver 接口的 connect(url, info) 获取数据库连接 21 Connection connection = driver.connect(url, info); 22 System.out.println(connection); 23 } 24 }
第8行，需要加入单元测试：右键“Properties”在窗口中，首先在左边选择“Java Build Path”，然后到右上选择“Libraries”标签，之后在最右边点击“Add Library…”按钮，选择“JUnit4”。
第16行，数据库的库名：atguigu。
编写一个通用的方法, 在不修改源程序的情况下, 可以获取任何数据库的连接
解决方案: 把数据库驱动Driver实现类的全类名、url、user、password 放入一个配置文件（jdbc.properties）中, 通过修改配置文件的方式实现和具体的数据库解耦。
1 package com.atguigu.jdbc; 2 3 import java.io.InputStream; 4 import java.sql.Connection; 5 import java.sql.Driver; 6 import java.util.Properties; 7 8 import org.junit.Test; 9 10 public class JDBCTest2 { 11 public Connection getConnection() throws Exception { 12 String driverClass = null; 13 String jdbcUrl = null; 14 String user = null; 15 String password = null; 16 //读取类路径下的jdbc.properties文件（在src下） 17 InputStream in = getClass().getClassLoader().getResourceAsStream("jdbc.properties"); 18 Properties properties = new Properties(); 19 properties.load(in); 20 driverClass = properties.getProperty("driver"); 21 jdbcUrl = properties.getProperty("jdbcUrl"); 22 user = properties.getProperty("user"); 23 password = properties.getProperty("password"); 24 //通过反射常见Driver对象 25 Driver driver = (Driver) Class.forName(driverClass).newInstance(); 26 Properties info = new Properties(); 27 info.put("user", user); 28 info.put("password", password); 29 //通过Driver的connect方法获取数据库连接. 30 Connection connection = driver.connect(jdbcUrl, info); 31 return connection; 32 } 33 @Test 34 public void testGetConnection() throws Exception{ 35 System.out.println(getConnection()); 36 } 37 }
DriverManager是驱动的管理类
⑴可以通过重载的 getConnection()方法获取数据库连接. 较为方便。
⑵可以同时管理多个驱动程序: 若注册了多个数据库连接, 则调用 getConnection()方法时传入的参数不同, 即：返回不同的数据库连接。
1 package com.atguigu.jdbc; 2 3 import java.sql.Connection; 4 import java.sql.DriverManager; 5 6 import org.junit.Test; 7 8 public class JDBCTest3 { 9 @Test 10 public void testDriverManager() throws Exception { 11 //1. 准备连接数据库的4个字符串. 12 String driverClass = "com.mysql.jdbc.Driver"; //驱动的全类名 13 String jdbcUrl = "jdbc:mysql:///atguigu"; //JDBC URL 14 String user = "root"; //user 15 String password = "123456"; //password 16 17 //2. 加载数据库驱动程序(对应的 Driver 实现类中有注册驱动的静态代码块.) 18 Class.forName(driverClass); 19 20 //3. 通过 DriverManager 的 getConnection() 方法获取数据库连接. 21 Connection connection = DriverManager.getConnection(jdbcUrl, user, password); 22 System.out.println(connection); 23 } 24 }
1 package com.atguigu.jdbc; 2 3 import java.io.InputStream; 4 import java.sql.Connection; 5 import java.sql.DriverManager; 6 import java.util.Properties; 7 8 import org.junit.Test; 9 10 public class JDBCTest4 { 11 public Connection getConnection2() throws Exception{ 12 //1. 准备连接数据库的4个字符串. 13 //⑴创建Properties对象 14 Properties properties = new Properties(); 15 //⑵ 获取jdbc.properties对应的输入流 16 InputStream in = this.getClass().getClassLoader().getResourceAsStream("jdbc.properties"); 17 //⑶加载⑵对应的输入流 18 properties.load(in); 19 //⑷具体决定user、password 等4个字符串. 20 String user = properties.getProperty("user"); 21 String password = properties.getProperty("password"); 22 String jdbcUrl = properties.getProperty("jdbcUrl"); 23 String driver = properties.getProperty("driver"); 24 //2. 加载数据库驱动程序(对应的Driver实现类中有注册驱动的静态代码块) 25 Class.forName(driver); 26 //3. 通过DriverManager的getConnection()方法获取数据库连接. 27 return DriverManager.getConnection(jdbcUrl, user, password); 28 } 29 @Test 30 public void testGetConnection2() throws Exception{ 31 System.out.println(getConnection2()); 32 } 33 }
通过JDB 向指定的数据表中插入一条记录.
1. Statement: 用于执行SQ 语句的对象
⑴通过Connectio的createStatement()方法来获取。
⑵通过executeUpdate(sql)可以执行SQL语句。
⑶传入的SQL可以是INSRET、UPDATE或DELETE。但不能是SELECT。
2. Connection、Statement都是应用程序和数据库服务器的连接资源. 使用后一定要关闭。需要在finally中关闭Connection和Statement对象。
3. 关闭的顺序是: 先关闭后获取的， 即：先关闭Statement后关闭Connection。
1 package com.atguigu.jdbc; 2 3 import java.io.InputStream; 4 import java.sql.Connection; 5 import java.sql.DriverManager; 6 import java.sql.Statement; 7 import java.util.Properties; 8 import org.junit.Test; 9 10 public class JDBCTest5 { 11 @Test 12 public void testStatement() throws Exception{ 13 //1. 获取数据库连接 14 Connection conn = null; 15 Statement statement = null; 16 try { 17 conn = getConnection2(); 18 //3. 准备插入的SQL语句 19 String sql = null; 20 sql = "INSERT INTO customers (name, email, birth) VALUES(‘Jerry‘, ‘jerry@atguigu.com‘, ‘1991-2-12‘)"; 21 // sql = "DELETE FROM customers WHERE id = 1"; 22 // sql = "UPDATE customers SET name = ‘TOM‘ WHERE id = 4"; 23 System.out.println(sql); 24 //4. 执行插入 25 //⑴获取操作SQL语句的Statement对象: 26 statement = conn.createStatement();//调用Connection的createStatement()方法来获取 27 //⑵调用Statement对象的executeUpdate(sql)执行SQL语句进行插入 28 statement.executeUpdate(sql); 29 } catch (Exception e) { 30 e.printStackTrace(); 31 } finally{ 32 try { 33 //5. 关闭Statement对象 34 if(statement != null) 35 statement.close(); 36 } catch (Exception e) { 37 // TODO Auto-generated catch block 38 e.printStackTrace(); 39 } finally { 40 //2. 关闭连接 41 if(conn != null) 42 conn.close(); 43 } 44 } 45 } 46 47 public Connection getConnection2() throws Exception { 48 //1. 准备连接数据库的4个字符串. 49 //⑴创建Properties对象 50 Properties properties = new Properties(); 51 //⑵获取jdbc.properties对应的输入流 52 InputStream in = this.getClass().getClassLoader().getResourceAsStream("jdbc.properties"); 53 //⑶加载⑵对应的输入流 54 properties.load(in); 55 //⑷具体决定 user、password等4个字符串. 56 String user = properties.getProperty("user"); 57 String password = properties.getProperty("password"); 58 String jdbcUrl = properties.getProperty("jdbcUrl"); 59 String driver = properties.getProperty("driver"); 60 //2. 加载数据库驱动程序(对应的Driver实现类中有注册驱动的静态代码块) 61 Class.forName(driver); 62 //3. 通过DriverManager的getConnection() 方法获取数据库连接. 63 return DriverManager.getConnection(jdbcUrl, user, password); 64 } 65 66 @Test 67 public void testGetConnection2() throws Exception{ 68 System.out.println(getConnection2()); 69 } 70 }
版本1：通用的更新的方法（包括 INSERT、UPDATE、DELETE）版本1
******************************
ORACLE
******************************
【Tue Oct 11 2016 09:37:50 GMT+0800】
使用Oracle的plsqldev.exe之前需要启动这两个服务：OracleServiceORCL和OracleOraDb10g_home1TNSListener，在Widows命令行
net start oracleserviceorcl 和 net start OracleOraDb10g_home1TNSListener（lsnrctl start）
C:\Users\admin>net start oracleserviceorcl
OracleServiceORCL 服务正在启动 ......
OracleServiceORCL 服务已经启动成功。
C:\Users\admin>net start OracleOraDb10g_home1TNSListener
OracleOraDb10g_home1TNSListener 服务正在启动 .
OracleOraDb10g_home1TNSListener 服务已经启动成功。
【Sat Oct 22 2016 21:56:08 GMT+0800】
1 -- phpMyAdmin SQL Dump 2 -- version 3.5.3 3 -- http://www.phpmyadmin.net 4 -- 5 -- 主机: localhost 6 -- 生成日期: 2016 年 10 月 22 日 21:19 7 -- 服务器版本: 5.5.20 8 -- PHP 版本: 5.3.5 9 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 11 SET time_zone = "+00:00"; 12 13 14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 17 /*!40101 SET NAMES utf8 */; 18 19 -- 20 -- 数据库: `ecshop` 21 -- 22 23 -- -------------------------------------------------------- 24 25 -- 26 -- 表的结构 `goods` 27 -- 28 29 CREATE TABLE IF NOT EXISTS `ec_goods` ( 30 `goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 31 `cat_id` smallint(5) unsigned NOT NULL DEFAULT ‘0‘, 32 `goods_sn` varchar(60) NOT NULL DEFAULT ‘‘, 33 `goods_name` varchar(120) NOT NULL DEFAULT ‘‘, 34 `goods_name_style` varchar(60) NOT NULL DEFAULT ‘+‘, 35 `click_count` int(10) unsigned NOT NULL DEFAULT ‘0‘, 36 `brand_id` smallint(5) unsigned NOT NULL DEFAULT ‘0‘, 37 `provider_name` varchar(100) NOT NULL DEFAULT ‘‘, 38 `goods_number` smallint(5) unsigned NOT NULL DEFAULT ‘0‘, 39 `goods_weight` decimal(10,3) unsigned NOT NULL DEFAULT ‘0.000‘, 40 `market_price` decimal(10,2) unsigned NOT NULL DEFAULT ‘0.00‘, 41 `shop_price` decimal(10,2) unsigned NOT NULL DEFAULT ‘0.00‘, 42 `promote_price` decimal(10,2) unsigned NOT NULL DEFAULT ‘0.00‘, 43 `promote_start_date` int(11) unsigned NOT NULL DEFAULT ‘0‘, 44 `promote_end_date` int(11) unsigned NOT NULL DEFAULT ‘0‘, 45 `warn_number` tinyint(3) unsigned NOT NULL DEFAULT ‘1‘, 46 `keywords` varchar(255) NOT NULL DEFAULT ‘‘, 47 `goods_brief` varchar(255) NOT NULL DEFAULT ‘‘, 48 `goods_desc` text NOT NULL, 49 `goods_thumb` varchar(255) NOT NULL DEFAULT ‘‘, 50 `goods_img` varchar(255) NOT NULL DEFAULT ‘‘, 51 `original_img` varchar(255) NOT NULL DEFAULT ‘‘, 52 `is_real` tinyint(3) unsigned NOT NULL DEFAULT ‘1‘, 53 `extension_code` varchar(30) NOT NULL DEFAULT ‘‘, 54 `is_on_sale` tinyint(1) unsigned NOT NULL DEFAULT ‘1‘, 55 `is_alone_sale` tinyint(1) unsigned NOT NULL DEFAULT ‘1‘, 56 `is_shipping` tinyint(1) unsigned NOT NULL DEFAULT ‘0‘, 57 `integral` int(10) unsigned NOT NULL DEFAULT ‘0‘, 58 `add_time` int(10) unsigned NOT NULL DEFAULT ‘0‘, 59 `sort_order` smallint(4) unsigned NOT NULL DEFAULT ‘100‘, 60 `is_delete` tinyint(1) unsigned NOT NULL DEFAULT ‘0‘, 61 `is_best` tinyint(1) unsigned NOT NULL DEFAULT ‘0‘, 62 `is_new` tinyint(1) unsigned NOT NULL DEFAULT ‘0‘, 63 `is_hot` tinyint(1) unsigned NOT NULL DEFAULT ‘0‘, 64 `is_promote` tinyint(1) unsigned NOT NULL DEFAULT ‘0‘, 65 `bonus_type_id` tinyint(3) unsigned NOT NULL DEFAULT ‘0‘, 66 `last_update` int(10) unsigned NOT NULL DEFAULT ‘0‘, 67 `goods_type` smallint(5) unsigned NOT NULL DEFAULT ‘0‘, 68 `seller_note` varchar(255) NOT NULL DEFAULT ‘‘, 69 `give_integral` int(11) NOT NULL DEFAULT ‘-1‘, 70 `rank_integral` int(11) NOT NULL DEFAULT ‘-1‘, 71 `suppliers_id` smallint(5) unsigned DEFAULT NULL, 72 `is_check` tinyint(1) unsigned DEFAULT NULL, 73 PRIMARY KEY (`goods_id`), 74 KEY `goods_sn` (`goods_sn`), 75 KEY `cat_id` (`cat_id`), 76 KEY `last_update` (`last_update`), 77 KEY `brand_id` (`brand_id`), 78 KEY `goods_weight` (`goods_weight`), 79 KEY `promote_end_date` (`promote_end_date`), 80 KEY `promote_start_date` (`promote_start_date`), 81 KEY `goods_number` (`goods_number`), 82 KEY `sort_order` (`sort_order`) 83 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ; 84 85 -- 86 -- 转存表中的数据 `goods` 87 -- 88 89 INSERT INTO `ec_goods` (`goods_id`, `cat_id`, `goods_sn`, `goods_name`, `goods_name_style`, `click_count`, `brand_id`, `provider_name`, `goods_number`, `goods_weight`, `market_price`, `shop_price`, `promote_price`, `promote_start_date`, `promote_end_date`, `warn_number`, `keywords`, `goods_brief`, `goods_desc`, `goods_thumb`, `goods_img`, `original_img`, `is_real`, `extension_code`, `is_on_sale`, `is_alone_sale`, `is_shipping`, `integral`, `add_time`, `sort_order`, `is_delete`, `is_best`, `is_new`, `is_hot`, `is_promote`, `bonus_type_id`, `last_update`, `goods_type`, `seller_note`, `give_integral`, `rank_integral`, `suppliers_id`, `is_check`) VALUES 90 (1, 4, ‘ECS000000‘, ‘KD876‘, ‘+‘, 7, 8, ‘‘, 1, ‘0.110‘, ‘1665.60‘, ‘1388.00‘, ‘0.00‘, 0, 0, 1, ‘LG 3g 876 支持 双模 2008年04月 灰色 GSM,850,900,1800,1900‘, ‘‘, ‘<p> 很多朋友都已经抢先体验了3G网络的可视通话、高速上网等功能。LG KD876手机<span style="font-size: x-large;"><span style="color: rgb(255, 0, 0);"><strong>支持TD-SCDMA/GSM双模单待</strong></span></span>，便于测试初期GSM网络和TD网络之间的切换和共享。</p>\r\n<p> LG KD876手机整体采用银色塑料材质，<strong><span style="font-size: x-large;"><span style="color: rgb(255, 0, 0);">特殊的旋转屏设计是本机的亮点</span></span></strong>，而机身背部的300万像素摄像头也是首发的六款TD-SCDMA手机中配置最高的。LG KD876手机屏幕下方设置有外键盘，该键盘由左/右软键、通话/挂机键、返回键、五维摇杆组成，摇杆灵敏度很高，定位准确。KD876的内键盘由标准12个电话键和三个功能键、一个内置摄像头组成。三个功能键分别为视频通话、MP3、和菜单键，所有按键的手感都比较一般，键程适中，当由于按键排列过于紧密，快速发短信时很容易误按，用户在使用时一定要多加注意。LG KD876手机机身周边的接口设计非常简洁，手机的厚度主要来自屏幕旋转轴的长度，如果舍弃旋屏设计的话，估计<span style="font-size: x-large;"><strong><span style="color: rgb(255, 0, 0);">厚度可以做到10mm以下</span></strong></span>。</p>‘, ‘images/200905/thumb_img/1_thumb_G_1240902890710.jpg‘, ‘images/200905/goods_img/1_G_1240902890755.jpg‘, ‘images/200905/source_img/1_G_1240902890895.gif‘, 1, ‘‘, 1, 1, 0, 13, 1240902890, 100, 0, 1, 1, 1, 0, 0, 1269589545, 9, ‘‘, -1, -1, NULL, NULL), 91 (4, 8, ‘ECS000004‘, ‘诺基亚N85原装充电器‘, ‘+‘, 0, 1, ‘‘, 17, ‘0.000‘, ‘69.60‘, ‘58.00‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘images/200905/thumb_img/4_thumb_G_1241422402467.jpg‘, ‘images/200905/goods_img/4_G_1241422402722.jpg‘, ‘images/200905/source_img/4_G_1241422402919.jpg‘, 1, ‘‘, 1, 0, 0, 0, 1241422402, 100, 0, 0, 0, 0, 0, 0, 1242110662, 6, ‘‘, -1, -1, NULL, NULL), 92 (3, 8, ‘ECS000002‘, ‘诺基亚原装5800耳机‘, ‘+‘, 3, 1, ‘‘, 24, ‘0.000‘, ‘81.60‘, ‘68.00‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘images/200905/thumb_img/3_thumb_G_1241422082679.jpg‘, ‘images/200905/goods_img/3_G_1241422082168.jpg‘, ‘images/200905/source_img/3_G_1241422082367.jpg‘, 1, ‘‘, 1, 1, 0, 0, 1241422082, 100, 0, 0, 0, 0, 0, 0, 1241972255, 6, ‘‘, -1, -1, NULL, NULL), 93 (5, 11, ‘ECS000005‘, ‘索爱原装M2卡读卡器‘, ‘+‘, 3, 7, ‘‘, 8, ‘0.000‘, ‘24.00‘, ‘20.00‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘images/200905/thumb_img/5_thumb_G_1241422518886.jpg‘, ‘images/200905/goods_img/5_G_1241422518773.jpg‘, ‘images/200905/source_img/5_G_1241422518470.jpg‘, 1, ‘‘, 1, 1, 0, 0, 1241422518, 100, 0, 1, 1, 0, 0, 0, 1241972241, 2, ‘‘, -1, -1, NULL, NULL), 94 (6, 11, ‘ECS000006‘, ‘胜创KINGMAX内存卡‘, ‘+‘, 0, 0, ‘‘, 15, ‘0.000‘, ‘50.40‘, ‘42.00‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘‘, ‘‘, ‘‘, 1, ‘‘, 1, 0, 0, 0, 1241422573, 100, 0, 0, 0, 0, 0, 0, 1241972238, 6, ‘‘, -1, -1, NULL, NULL), 95 (7, 8, ‘ECS000007‘, ‘诺基亚N85原装立体声耳机HS-82‘, ‘+‘, 0, 1, ‘‘, 20, ‘0.000‘, ‘120.00‘, ‘100.00‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘images/200905/thumb_img/7_thumb_G_1241422785492.jpg‘, ‘images/200905/goods_img/7_G_1241422785856.jpg‘, ‘images/200905/source_img/7_G_1241422785657.jpg‘, 1, ‘‘, 1, 1, 0, 1, 1241422785, 100, 0, 0, 0, 0, 0, 0, 1241972232, 2, ‘‘, -1, -1, NULL, NULL), 96 (8, 3, ‘ECS000008‘, ‘飞利浦9@9v‘, ‘+‘, 9, 4, ‘‘, 1, ‘0.075‘, ‘478.79‘, ‘399.00‘, ‘385.00‘, 1241366400, 1417276800, 1, ‘双模 2008年春 黑色 直板 中低档‘, ‘‘, ‘<p align="left">作为一款性价比极高的入门级<font size="3" color="#ff0000"><strong>商务手机</strong></font>，飞利浦<a href="mailto:9@9v">Xenium 9@9v</a>三围大小为105×44×15.8mm，机身重量仅为<strong><font size="3" color="#ff0000">75g</font></strong>，装配了一块低规格1.75英寸128×160像素65000色CSTN显示屏。身正面采用月银色功能键区与屏幕数字键区相分隔，键盘设计较为<font size="3"><strong><font color="#ff0000">别</font><font color="#ff0000">致</font></strong></font>，中部导航键区采用钛金色的“腰带”彰显出浓郁的商务气息。</p>\r\n<p align="left"> </p>\r\n<p align="left">此款手机采用<strong><font size="3" color="#ff0000">触摸屏</font></strong>设计，搭配精致的手写笔，可支持手写中文和英文两个版本。增强的内置系统还能识别潦草字迹，确保在移动中和匆忙时输入文字的识别率。手写指令功能还支持特定图案的瞬间调用，独特的手写记事本功能，可以在触摸屏上随意绘制个性化的图案并进行<strong><font size="3" color="#ff0000">记事提醒</font></strong>，让商务应用更加随意。</p>\r\n<p align="left"> </p>\r\n<p align="left"> 作为入门级为数不多支持<strong><font size="3" color="#ff0000">双卡功能</font></strong>的手机，可以同时插入两张SIM卡，通过菜单随意切换，只需开启漫游自动切换模式，<a href="mailto:9@9V">9@9V</a>在该模式下能够判断网络情况，自动切换适合的手机号。</p>\r\n<p align="left"> </p>\r\n<p align="left"> </p>‘, ‘images/200905/thumb_img/8_thumb_G_1241425513488.jpg‘, ‘images/200905/goods_img/8_G_1241425513055.jpg‘, ‘images/200905/source_img/8_G_1241425513518.jpg‘, 1, ‘‘, 1, 1, 0, 3, 1241425512, 100, 0, 1, 1, 1, 1, 0, 1269589533, 9, ‘‘, -1, -1, NULL, NULL), 97 (9, 3, ‘ECS000009‘, ‘诺基亚E66‘, ‘+‘, 20, 1, ‘‘, 4, ‘0.121‘, ‘2757.60‘, ‘2298.00‘, ‘0.00‘, 0, 0, 1, ‘SMS EMS MMS 短消息群发 语音 阅读器 SMS,EMS,MMS,短消息群发语音合成信息阅读器 黑色 白色 滑盖‘, ‘‘, ‘<p>在机身材质方面，诺基亚E66大量采用金属材质，刨光的金属表面光泽动人，背面的点状效果规则却又不失变化，时尚感总是在不经意间诠释出来，并被人们所感知。E66机身尺寸为<span style="color: rgb(255, 0, 0);"><span style="font-size: larger;"><strong>107.5×49.5×13.6毫米，重量为121克</strong></span></span>，滑盖的造型竟然比E71还要轻一些。</p>\r\n<p> </p>\r\n<div>诺基亚E66机身正面是<span style="color: rgb(255, 0, 0);"><span style="font-size: larger;"><strong>一块2.4英寸1600万色QVGA分辨率（240×320像素）液晶显示屏</strong></span></span>。屏幕上方拥有光线感应元件，能够自适应周 围环境光调节屏幕亮度；屏幕下方是方向功能键区。打开滑盖，可以看到传统的数字键盘，按键的大小、手感、间隔以及键程适中，手感非常舒适。</div>\r\n<div> </div>\r\n<div>诺基亚为E66配备了一颗320万像素自动对焦摄像头，带有LED 闪光灯，支持多种拍照尺寸选择。</div>\r\n<p> </p>‘, ‘images/200905/thumb_img/9_thumb_G_1241511871555.jpg‘, ‘images/200905/goods_img/9_G_1241511871574.jpg‘, ‘images/200905/source_img/9_G_1241511871550.jpg‘, 1, ‘‘, 1, 1, 0, 22, 1241511871, 100, 0, 1, 1, 1, 0, 0, 1269589743, 9, ‘‘, -1, -1, NULL, NULL), 98 (10, 3, ‘ECS000010‘, ‘索爱C702c‘, ‘+‘, 11, 7, ‘‘, 7, ‘0.000‘, ‘1593.60‘, ‘1328.00‘, ‘1250.00‘, 1243785600, 1277827200, 1, ‘2008年05月 GSM,850,900,1800,1900 直板‘, ‘‘, ‘<p>C702可以说是一种在外观上复古的产物，不仅延续T系列早期的直板造型，而且在屏幕和键盘的组合分布上都继承了前辈的精髓。C702的机身尺寸为106×48×15.5毫米，重量为105克。此外索尼爱立信为C702融入了<font size="3" color="#ff0000"><strong>三防特性，即防尘、防滑和防水溅</strong></font>，这款新的C702搭载了索尼爱立信经典A200平台，界面布局与W908c、K858c一致，典型的特征就是配备左右软键、中央确定键和通话/挂机键。</p>\r\n<p>索尼爱立信C702配备一块<strong><font size="3" color="#ff0000">2.2英寸26万色TFT液晶显示屏</font></strong>，分辨率为240×320像素(QVGA)，显示效果属于目前主流水准。C702可以说是索尼爱立信首批<strong><font size="3" color="#ff0000">内置GPS模块</font></strong>的 手机产品之一，C702的搜星、定位一气呵成，十分精准，误差大约在10米之内。基本上定位后可以将有效卫星数量控制在4—6颗，可以说可以满足我们的需 要了。C702还提供了“影像定位”功能，配合内置的AGPS全球定位辅助系统，只须启动Geo-Tagging智能影像定位功能，便可将拍摄地点记录在 照片内，方便用户随时查询。</p>\r\n<p> </p>\r\n<p>作为一款Cyber-shot系列影像手机，索尼爱立信C702在拍照功能方面同样有不俗的表现。并且手机内置的<strong><font size="3" color="#ff0000">320万像素摄像头</font></strong>也 同样在拍照功能上也不错的表现。不仅支持自动聚焦和双LED闪光功能，而且还拥有2倍数码变焦、防红眼、Photo fix优画及场景模式等功能。索尼爱立信C702除了配备的是最大光圈为F3.2的4.2毫米镜头之外，该机也如同门中的旗舰C902一样增加了对脸部有 先自动聚焦功能的支持。</p>\r\n<p> </p>‘, ‘images/200905/thumb_img/10_thumb_G_1242973436403.jpg‘, ‘images/200905/goods_img/10_G_1242973436141.jpg‘, ‘images/200905/source_img/10_G_1242973436172.jpg‘, 1, ‘‘, 1, 1, 0, 13, 1241965622, 100, 0, 0, 0, 1, 1, 0, 1245290333, 9, ‘‘, -1, -1, NULL, NULL), 99 (11, 3, ‘ECS000011‘, ‘索爱C702c‘, ‘+‘, 0, 7, ‘‘, 1, ‘0.000‘, ‘0.00‘, ‘1300.00‘, ‘0.00‘, 0, 0, 1, ‘直板‘, ‘‘, ‘‘, ‘‘, ‘‘, ‘‘, 1, ‘‘, 0, 1, 0, 0, 1241966951, 100, 1, 0, 0, 0, 0, 0, 1241966960, 7, ‘‘, -1, -1, NULL, NULL), 100 (12, 3, ‘ECS000012‘, ‘摩托罗拉A810‘, ‘+‘, 13, 2, ‘‘, 8, ‘0.000‘, ‘1179.60‘, ‘983.00‘, ‘960.00‘, 1241107200, 1255104000, 1, ‘SMS EMS MMS pda 摄像 智能 音乐 SMS,EMS,MMS‘, ‘‘, ‘<p>全机使用的材质除去电池盖部分采用了金属以外，其它均使用了ABS工程塑料作为主材，这款手机的三围是105×51×14毫米，有着100克的轻量级重量，拿在手中的感觉还是非常不错的。A810手机作为一款<strong><font size="3" color="#ff0000">PDA手机</font></strong>在设计的时候取消了键盘配置，一切数字键都要依靠手机内提供的虚拟键盘进行操作，在手机的左上侧是一个<strong><font size="3" color="#ff0000">3.5mm的标准耳机插口</font></strong>，这种设计可以让用户使用自己习惯或者喜欢的耳机去欣赏音乐。</p>\r\n<p> </p>\r\n<p>这款摩托罗拉A810手机配置了一块<font size="3" color="#ff0000"><strong>26万色的2.2英寸TFT全触摸屏幕</strong></font>，其分辨率达到了主流的QVGA水平（240×320像素），摩托罗拉A810采用了内部核心为2.6.10的<strong><font size="3" color="#ff0000">LINUX操作系统</font></strong>，菜单上依然采用传统的9宫格的显示方式，一般手机的名片式电话本只能支持诸如电话、邮件、传真、公司等一些基本信息，而A810手机的电话本除了这些还支持公司地址，配偶信息、子女姓名、上司名称、助手等等，对于一款手机来说，电话本不可谓不强大。A810的<strong><font size="3" color="#ff0000">手写识别能力相当的惊人</font></strong>，对连笔、草书和倒插笔的识别率都相当的高，同时还为左右手设置了不同的书写习惯选择，并支持手写速度的调节。</p>\r\n<p>这款A810手机<strong><font size="3" color="#ff0000">内置的音乐播放功能</font></strong>可以支持MP3、WAV、AMR、AAC等格式的音乐播放，<font size="3" color="#ff0000"><strong>支持后台播放</strong></font>。视频方面，这款A810支持MP4、3GP、H.263格式的播放，视频播放器同样简约，操作方便，这款摩托罗拉A810还内置了6款游戏，每一款都有很高的耐玩性，而且都是支持触摸屏操作的，同时这款手机还内置了<strong><font size="3" color="#ff0000">FM收音机</font></strong>，支持自动搜索，并提供了20个频道供用户存储，不过收音机并不支持后台播放。</p>\r\n<p> </p>‘, ‘images/200905/thumb_img/12_thumb_G_1241965978410.jpg‘, ‘images/200905/goods_img/12_G_1241965978209.jpg‘, ‘images/200905/source_img/12_G_1241965978878.jpg‘, 1, ‘‘, 1, 1, 0, 9, 1245297652, 100, 0, 0, 1, 0, 1, 0, 1245297670, 3, ‘‘, -1, -1, NULL, NULL), 101 (13, 3, ‘ECS000013‘, ‘诺基亚5320 XpressMusic‘, ‘+‘, 13, 1, ‘‘, 8, ‘0.000‘, ‘1573.20‘, ‘1311.00‘, ‘0.00‘, 0, 0, 1, ‘摄像 智能 音乐 蓝色 红色 舒适 直板 中档 2008年07月 黑色 GSM,850,900,1800,1900‘, ‘‘, ‘<p>诺基亚5320XpressMusic音乐手机采用XpressMusic系列常见的黑红、黑蓝配色方案，而材质方便则选用的是经过<strong><font size="3" color="#ff0000">抛光处理</font></strong>的工程塑料；三围/体重为，为108×46×15mm/<strong><font size="3" color="#ff0000">90g</font></strong>，手感舒适。</p>\r\n<p> </p>\r\n<p>诺基亚5320采用的是一块可视面积为2.0英寸的<font size="3" color="#ff0000"><strong>1600万色</strong></font>屏幕，分辨率是常见的240×320像素（QVGA）。虽然屏幕不是特别大，但效果非常精细，色彩还原不错。</p>\r\n<p> </p>\r\n<p>手机背面，诺基亚为5320XM配备一颗<strong><font size="3" color="#ff0000">200W像素</font></strong>的摄像头，并且带有<strong><font size="3" color="#ff0000">两个LED的补光灯</font></strong>，可以实现拍照、摄像功能，并能通过彩信、邮件方式发送给朋友。</p>\r\n<p> </p>‘, ‘images/200905/thumb_img/13_thumb_G_1241968002527.jpg‘, ‘images/200905/goods_img/13_G_1241968002233.jpg‘, ‘images/200905/source_img/13_G_1241968002732.jpg‘, 1, ‘‘, 1, 1, 0, 13, 1241967762, 100, 0, 0, 0, 1, 0, 0, 1269589198, 9, ‘‘, -1, -1, NULL, NULL), 102 (14, 4, ‘ECS000014‘, ‘诺基亚5800XM‘, ‘+‘, 6, 1, ‘‘, 1, ‘0.000‘, ‘3150.00‘, ‘2625.00‘, ‘0.00‘, 0, 0, 1, ‘GSM 64和弦 2009年2月 320万摄像头 GPS 直板 工程塑料 支持 2008年10月 黑色‘, ‘‘, ‘‘, ‘images/200905/thumb_img/14_thumb_G_1241968492116.jpg‘, ‘images/200905/goods_img/14_G_1241968492932.jpg‘, ‘images/200905/source_img/14_G_1241968492305.jpg‘, 1, ‘‘, 1, 1, 0, 26, 1241968492, 100, 0, 0, 0, 1, 0, 0, 1269589186, 9, ‘‘, -1, -1, NULL, NULL), 103 (15, 3, ‘ECS000015‘, ‘摩托罗拉A810‘, ‘+‘, 8, 2, ‘‘, 3, ‘0.000‘, ‘945.60‘, ‘788.00‘, ‘0.00‘, 0, 0, 1, ‘600 直板 工程塑料 蓝牙 视频拍摄 音乐 黑色 白色‘, ‘‘, ‘‘, ‘images/200905/thumb_img/15_thumb_G_1242973362970.jpg‘, ‘images/200905/goods_img/15_G_1242973362318.jpg‘, ‘images/200905/source_img/15_G_1242973362751.jpg‘, 1, ‘‘, 1, 1, 0, 5, 1241968703, 100, 1, 0, 1, 1, 0, 0, 1245297631, 9, ‘‘, -1, -1, NULL, NULL), 104 (16, 2, ‘ECS000016‘, ‘恒基伟业G101‘, ‘+‘, 3, 11, ‘‘, 0, ‘0.000‘, ‘988.00‘, ‘823.33‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘images/200905/thumb_img/16_thumb_G_1241968949103.jpg‘, ‘images/200905/goods_img/16_G_1241968949002.jpg‘, ‘images/200905/source_img/16_G_1241968949402.jpg‘, 1, ‘‘, 0, 1, 0, 8, 1241968949, 100, 0, 0, 0, 0, 0, 0, 1245290562, 2, ‘‘, -1, -1, NULL, NULL), 105 (17, 3, ‘ECS000017‘, ‘夏新N7‘, ‘+‘, 2, 5, ‘‘, 1, ‘0.000‘, ‘2760.00‘, ‘2300.00‘, ‘0.00‘, 0, 0, 1, ‘2008年01月 GSM,900,1800,1900,2100 直板 262144万 240×400 像素 SMS,EMS,MMS,超长信息发送,短消息群发 黑色 CDMA‘, ‘‘, ‘‘, ‘images/200905/thumb_img/17_thumb_G_1241969394587.jpg‘, ‘images/200905/goods_img/17_G_1241969394677.jpg‘, ‘images/200905/source_img/17_G_1241969394844.jpg‘, 1, ‘‘, 1, 1, 0, 23, 1241969394, 100, 0, 1, 0, 1, 0, 0, 1269589169, 9, ‘‘, -1, -1, NULL, NULL), 106 (18, 4, ‘ECS000018‘, ‘夏新T5‘, ‘+‘, 0, 5, ‘‘, 1, ‘0.000‘, ‘3453.60‘, ‘2878.00‘, ‘0.00‘, 0, 0, 1, ‘2008年04月 3G(GSM,900,1800,1900,TD-SCDMA ) 直板 262144万 320×240 像素 是 银色‘, ‘‘, ‘<p> TD-SCDMA/GSM两种模式任意切换，中国3G手机先驱，支持大陆特有3G网络，轻松实现可视电话、视频留言、视频会议功能，2.6英寸Q屏，手写、键盘双输入，内置移动证券，支持手机邮箱、手机地图、无驱U盘</p>‘, ‘‘, ‘‘, ‘‘, 1, ‘‘, 1, 1, 0, 28, 1241969533, 100, 1, 0, 0, 0, 0, 0, 1241969533, 2, ‘‘, -1, -1, NULL, NULL), 107 (19, 3, ‘ECS000019‘, ‘三星SGH-F258‘, ‘+‘, 7, 6, ‘‘, 12, ‘0.000‘, ‘1029.60‘, ‘858.00‘, ‘0.00‘, 0, 0, 1, ‘滑盖 GSM 258 时尚 蓝牙 黑色 金色 白色‘, ‘从整体来看，三星SGH-F258比较时尚可爱，三围尺寸为94×46×17.5mm，重量为96克，曲线柔和具有玲珑美感\r\n‘, ‘<p>从整体来看，三星SGH-F258比较<font size="3" color="#ff0000"><strong>时尚</strong></font>可爱，三围尺寸为94×46×17.5mm，重量为96克，曲线柔和具有玲珑美感。</p>\r\n<p> </p>\r\n<p>三星F258的前面板整体应用<strong><font size="3" color="#ff0000">镜面效果</font></strong>，2.0英寸显示屏幕略显窄小，导航键与功能键在滑盖滑开之前是前面板的全部控制键，没有挂断和接听键，不过，五向键有<font size="3"><strong><font color="#ff0000">音乐操</font><font color="#ff0000">作</font></strong></font>功能，明确显示了F258音乐手机的定位。</p>\r\n<p> </p>\r\n<p>F258的数字键键区采用了极具金属质感的平板式设计，每颗按键的面积足够大，按键与按键之间的间隔明显，操作起来手感舒适。</p>‘, ‘images/200905/thumb_img/19_thumb_G_1241970175208.jpg‘, ‘images/200905/goods_img/19_G_1241970175091.jpg‘, ‘images/200905/source_img/19_G_1241970175549.jpg‘, 1, ‘‘, 1, 1, 0, 8, 1241970139, 100, 0, 1, 1, 1, 0, 0, 1269589154, 9, ‘‘, -1, -1, NULL, NULL), 108 (20, 3, ‘ECS000020‘, ‘三星BC01‘, ‘+‘, 14, 6, ‘‘, 12, ‘0.000‘, ‘336.00‘, ‘280.00‘, ‘238.00‘, 1241884800, 1251648000, 1, ‘GSM 直板 40和弦 金属材质 2008年07月 黑色 GSM,900,1800,1900,2100‘, ‘‘, ‘‘, ‘images/200905/thumb_img/20_thumb_G_1242106490058.jpg‘, ‘images/200905/goods_img/20_G_1242106490663.jpg‘, ‘images/200905/source_img/20_G_1242106490922.jpg‘, 1, ‘‘, 1, 1, 0, 2, 1241970417, 100, 0, 1, 1, 1, 1, 0, 1269589110, 9, ‘‘, -1, -1, NULL, NULL), 109 (21, 3, ‘ECS000021‘, ‘金立 A30‘, ‘+‘, 4, 10, ‘‘, 40, ‘0.000‘, ‘2400.00‘, ‘2000.00‘, ‘0.00‘, 0, 0, 1, ‘2008年03月 GSM,900,1800,1900,2100 直板 1600万 240×400 像素 2007年12月 200万摄像头 黑色‘, ‘‘, ‘<p> </p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">标准配置: 标准锂电池两块,充电器两个,立体声耳机一个,数据线,说明书送256TF</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">通讯功能 输入法 短信功能 话机通讯录 通话记录</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">输入法: 中文输入法</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">短信功能: 支持短信300条和彩信100条</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">话机通讯录: 1000组名片式电话存储 来电防火墙功能 来电大头贴及来电铃声识别</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">通话记录：支持电话录音,恢复/静音,双音多频,免提</font></span></p>\r\n<p> </p>\r\n<p><font size="3">高级功能</font></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">多媒体娱乐: 200万像素，最大支持10240*960，11级数码变焦,多种效果设置,连拍可全屏查看拍摄或下载的图片.支持有声MP4短片拍摄，录像时间根据内存 大小而定，拍摄录像,TV电视可跟朋友家人一起分享。支持网络摄像头功能 支持MPEG4、3GP(H.263)等视频格式 支持MP3等音频格式播放， 支持歌词播放</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">内置游戏:智能拼图</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">扩展存储功能:支持TF扩展,支持U盘功能,本机内置1M,随机赠送256TF卡</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">高级功能:直板/智能PDA手写/键盘输入 超长待机 WAP上网 录音 蓝牙 FM收音机 电子书 Java扩展 TV电视输出 声控语音拨号 免费电视 来电防火墙 </font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">附加功能: 日历 计算器 闹钟 记事本 日程表 秒表 单位换算</font></span></p>\r\n<p><span style="font-size: medium;"><font size="3">提醒 以上性能均为本公司员工试机后所写,产品资料仅供参考,请以收到实物为准</font></span></p>‘, ‘images/200905/thumb_img/21_thumb_G_1242109298150.jpg‘, ‘images/200905/goods_img/21_G_1242109298873.jpg‘, ‘images/200905/source_img/21_G_1242109298831.jpg‘, 1, ‘‘, 1, 1, 0, 20, 1241970634, 100, 0, 0, 0, 0, 0, 0, 1269589102, 9, ‘‘, -1, -1, NULL, NULL), 110 (22, 3, ‘ECS000022‘, ‘多普达Touch HD‘, ‘+‘, 15, 3, ‘‘, 1, ‘0.000‘, ‘7198.80‘, ‘5999.00‘, ‘0.00‘, 0, 0, 1, ‘500万摄像头 蓝牙 手写 GPS 办公应用 语音拨号 2008年12月 黑色 GSM,850,900,1800,1900 直板‘, ‘‘, ‘<p><img src="http://xgone.xgou.com/xgoumanage/upload/20090325/2009032502045081100887.jpg" /></p>\r\n<p> </p>\r\n<p><img src="http://www.ouku.com/upimg/ouku/Image/002(1).jpg" /></p>\r\n<p> </p>\r\n<p> </p>‘, ‘images/200905/thumb_img/22_thumb_G_1241971076803.jpg‘, ‘images/200905/goods_img/22_G_1241971076358.jpg‘, ‘images/200905/source_img/22_G_1241971076130.jpg‘, 1, ‘‘, 1, 1, 0, 59, 1241971076, 100, 0, 1, 1, 0, 0, 0, 1269589090, 9, ‘‘, -1, -1, NULL, NULL), 111 (23, 5, ‘ECS000023‘, ‘诺基亚N96‘, ‘+‘, 17, 1, ‘‘, 8, ‘0.000‘, ‘4440.00‘, ‘3700.00‘, ‘0.00‘, 0, 0, 1, ‘500万摄像头 microSD 工程塑料 蓝牙 数码相机 内置游戏 滑盖 高档 2008年09月 320×240 像素 黑色‘, ‘‘, ‘<p>诺基亚N96采用了<strong><font size="3" color="#ff0000">双向滑盖</font></strong>设计，机身整体呈灰黑色，沉稳、大气，机身材质采用了高强度的塑料材质，手机背面采用了抛光面板的设计风格。N96三维体积103*55*20mm，重量为125g。屏幕方面，诺基亚N96配备一块<strong><font size="3" color="#ff0000">2.8英寸</font></strong>的屏幕，支持<strong><font size="3" color="#ff0000">1670万色</font></strong>显示，分辨率达到QVGA（320×240）水准。</p>\r\n<p><img src="file:///C:/DOCUME~1/user/LOCALS~1/Temp/moz-screenshot.jpg" /></p>\r\n<p> </p>\r\n<p> <img src="http://img2.zol.com.cn/product/21/896/ceN6LBMCid3X6.jpg" /></p>\r\n<p>诺基亚N96设置有专门的<strong><font size="3" color="#ff0000">音乐播放键</font></strong>和标准的3.5毫米音频插口，支持多格式音乐播放。内置了<strong><font size="3" color="#ff0000">多媒体播放器</font></strong>，支持FM调频收音机等娱乐功能。N96手机支持<strong><font size="3" color="#ff0000">N-Gage游戏平台</font></strong>，内置包括<font size="3" color="#ff0000"><strong>《PinBall》完整版</strong></font>在内的四款N-Gage游戏，除了手机本身内置的游戏，还可以从N-Gage的网站下载或者购买最新的游戏，而且可以在论坛里和其他玩家一起讨论。</p>\r\n<p><img src="http://img2.zol.com.cn/product/21/898/cekkw57qJjSI.jpg" /></p>\r\n<p> </p>‘, ‘images/200905/thumb_img/23_thumb_G_1241971556399.jpg‘, ‘images/200905/goods_img/23_G_1241971556855.jpg‘, ‘images/200905/source_img/23_G_1241971556256.jpg‘, 1, ‘‘, 1, 1, 0, 37, 1241971488, 100, 0, 1, 1, 0, 0, 0, 1269589078, 9, ‘‘, -1, -1, NULL, NULL), 112 (24, 3, ‘ECS000024‘, ‘P806‘, ‘+‘, 35, 9, ‘‘, 100, ‘0.000‘, ‘2400.00‘, ‘2000.00‘, ‘1850.00‘, 1243785600, 1277827200, 1, ‘旅行充电器 图形菜单 Wap 上网 红外接口 移动 MSN 支持 2008年06月 灰色‘, ‘‘, ‘<div>\r\n<div>\r\n<div><font size="4">规格参数</font></div>\r\n<p><font size="4"><span>上市时间：</span><span>2008年06月</span></font></p>\r\n<p><font size="4"><span>网络频率：</span><span>GSM/GPRS；900/1800MHz</span></font></p>\r\n<p><font size="4"><span>重 量 ：</span><span>未知</span></font></p>\r\n<p><font size="4"><span>尺寸/体积：</span><span>未知</span></font></p>\r\n<p><font size="4"><span>可选颜色：</span><span>银色</span></font></p>\r\n<p><font size="4"><span>屏幕参数：</span><span>26万色TFT彩色屏幕；</span></font></p>\r\n<p><font size="4"><span>WAP上网：</span><span>支持飞笺</span></font></p>\r\n<p><font size="4"><span>基本配置:<em><strong><font size="5" color="#ff00ff">二电(1760毫安) 一充 数据线 耳机 手写笔 512M内存卡</font></strong></em></span></font></p>\r\n<p> </p>\r\n</div>\r\n</div>\r\n<div><font size="4">基本功能</font></div>\r\n<p><font size="4"><span>『时钟』</span><span>『内置振动』</span><span>『录音』</span><span>『可选铃声』</span></font></p>\r\n<p><font size="4"><span>『和弦铃声』</span><span>『MP3铃声』</span><span>『来电铃声识别』</span><span>『来电图片识别』</span></font></p>\r\n<p><font size="4"><span>『情景模式』</span><span>『待机图片』</span><span>『图形菜单』</span><span>『触摸屏』</span></font></p>\r\n<p><span><font size="4">『手写输入』</font></span></p>\r\n<div><font size="4">通信功能</font></div>\r\n<p><font size="4"><span>『双卡双待』</span><span>『内置天线』</span><span>『输入法』</span><span>『中文短信』</span></font></p>\r\n<p><font size="4"><span>『短信群发』</span><span>『多媒体短信』</span><span>『话机通讯录』</span><span>『通话记录』</span></font></p>\r\n<p><font size="4"><span>『免提通话』</span><span>『飞行模式』</span></font></p>\r\n<div><font size="4">多媒体娱乐 :支持3GP、MP4文件播放</font></div>\r\n<p><font size="4"><span>『视频播放』</span><span>『MP3播放器』</span></font></p>\r\n<p><font size="4"><span>多媒体卡扩展：</span><span>支持microSD卡扩展 </span></font></p>\r\n<p><font size="4"><span>摄像头：</span><span>内置</span></font></p>\r\n<p><font size="4"><span>摄像头像素：</span><span>30万像素</span></font></p>\r\n<p><font size="4"><span>传感器类型：</span><span>CMOS</span></font></p>\r\n<p><font size="4"><span>变焦模式：</span><span>数码变焦</span></font></p>\r\n<p><font size="4"><span>照片分辨率：</span><span>多种照片分辨率选择</span></font></p>\r\n<p><font size="4"><span>拍摄模式：</span><span>多种拍摄模式选择</span></font></p>\r\n<p><font size="4"><span>照片质量：</span><span>多种照片质量选择</span></font></p>\r\n<p><font size="4"><span>视频拍摄：</span><span>有声视频拍摄</span></font></p>\r\n<div><font size="4">数据传输</font></div>\r\n<p><font size="4"><span>『WAP浏览器』</span><span>『数据线接口』</span></font></p>\r\n<div><font size="4">个人助理</font></div>\r\n<p><font size="4"><span>『闹钟』</span><span>『日历』</span><span>『计算器』</span></font></p>‘, ‘images/200905/thumb_img/24_thumb_G_1241971981429.jpg‘, ‘images/200905/goods_img/24_G_1241971981284.jpg‘, ‘images/200905/source_img/24_G_1241971981107.jpg‘, 1, ‘‘, 1, 1, 0, 20, 1241971981, 100, 0, 1, 1, 1, 1, 0, 1269589064, 9, ‘‘, -1, -1, NULL, NULL), 113 (25, 13, ‘ECS000025‘, ‘小灵通/固话50元充值卡‘, ‘+‘, 0, 0, ‘‘, 2, ‘0.000‘, ‘57.59‘, ‘48.00‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘images/200905/thumb_img/25_thumb_G_1241972709885.jpg‘, ‘images/200905/goods_img/25_G_1241972709544.jpg‘, ‘images/200905/source_img/25_G_1241972709750.jpg‘, 0, ‘virtual_card‘, 1, 1, 0, 0, 1241972709, 100, 0, 1, 0, 1, 0, 0, 1245047546, 0, ‘‘, -1, -1, NULL, NULL), 114 (26, 13, ‘ECS000026‘, ‘小灵通/固话20元充值卡‘, ‘+‘, 0, 0, ‘‘, 2, ‘0.000‘, ‘22.80‘, ‘19.00‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘images/200905/thumb_img/26_thumb_G_1241972789393.jpg‘, ‘images/200905/goods_img/26_G_1241972789293.jpg‘, ‘images/200905/source_img/26_G_1241972789353.jpg‘, 0, ‘virtual_card‘, 1, 1, 0, 0, 1241972789, 100, 0, 0, 0, 1, 0, 0, 1245047540, 0, ‘‘, -1, -1, NULL, NULL), 115 (27, 15, ‘ECS000027‘, ‘联通100元充值卡‘, ‘+‘, 0, 0, ‘‘, 2, ‘0.000‘, ‘100.00‘, ‘95.00‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘images/200905/thumb_img/27_thumb_G_1241972894068.jpg‘, ‘images/200905/goods_img/27_G_1241972894061.jpg‘, ‘images/200905/source_img/27_G_1241972894069.jpg‘, 0, ‘virtual_card‘, 1, 1, 0, 0, 1241972894, 100, 0, 1, 1, 1, 0, 0, 1245047557, 0, ‘‘, -1, -1, NULL, NULL), 116 (28, 15, ‘ECS000028‘, ‘联通50元充值卡‘, ‘+‘, 0, 0, ‘‘, 0, ‘0.000‘, ‘50.00‘, ‘45.00‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘images/200905/thumb_img/28_thumb_G_1241972976986.jpg‘, ‘images/200905/goods_img/28_G_1241972976313.jpg‘, ‘images/200905/source_img/28_G_1241972976695.jpg‘, 0, ‘virtual_card‘, 1, 1, 0, 0, 1241972976, 100, 0, 0, 0, 1, 0, 0, 1245047542, 0, ‘‘, -1, -1, NULL, NULL), 117 (29, 14, ‘ECS000029‘, ‘移动100元充值卡‘, ‘+‘, 0, 0, ‘‘, 0, ‘0.000‘, ‘0.00‘, ‘90.00‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘images/200905/thumb_img/29_thumb_G_1241973022239.jpg‘, ‘images/200905/goods_img/29_G_1241973022206.jpg‘, ‘images/200905/source_img/29_G_1241973022514.jpg‘, 0, ‘virtual_card‘, 1, 1, 0, 0, 1241973022, 100, 0, 1, 0, 1, 0, 0, 1245047543, 0, ‘‘, -1, -1, NULL, NULL), 118 (30, 14, ‘ECS000030‘, ‘移动20元充值卡‘, ‘+‘, 1, 0, ‘‘, 9, ‘0.000‘, ‘21.00‘, ‘18.00‘, ‘0.00‘, 0, 0, 1, ‘‘, ‘‘, ‘‘, ‘images/200905/thumb_img/30_thumb_G_1241973114800.jpg‘, ‘images/200905/goods_img/30_G_1241973114234.jpg‘, ‘images/200905/source_img/30_G_1241973114587.jpg‘, 0, ‘virtual_card‘, 1, 1, 0, 0, 1241973114, 100, 0, 1, 0, 1, 0, 0, 1245047549, 0, ‘‘, -1, -1, NULL, NULL), 119 (31, 3, ‘ECS000031‘, ‘摩托罗拉E8 ‘, ‘+‘, 5, 2, ‘‘, 1, ‘0.000‘, ‘1604.39‘, ‘1337.00‘, ‘0.00‘, 0, 0, 1, ‘直板‘, ‘‘, ‘‘, ‘images/200905/thumb_img/31_thumb_G_1242110412996.jpg‘, ‘images/200905/goods_img/31_G_1242110412332.jpg‘, ‘images/200905/source_img/31_G_1242110412519.jpg‘, 1, ‘‘, 0, 1, 0, 13, 1242110412, 100, 0, 0, 0, 0, 0, 0, 1242140652, 7, ‘‘, -1, -1, NULL, NULL); 120 INSERT INTO `ec_goods` (`goods_id`, `cat_id`, `goods_sn`, `goods_name`, `goods_name_style`, `click_count`, `brand_id`, `provider_name`, `goods_number`, `goods_weight`, `market_price`, `shop_price`, `promote_price`, `promote_start_date`, `promote_end_date`, `warn_number`, `keywords`, `goods_brief`, `goods_desc`, `goods_thumb`, `goods_img`, `original_img`, `is_real`, `extension_code`, `is_on_sale`, `is_alone_sale`, `is_shipping`, `integral`, `add_time`, `sort_order`, `is_delete`, `is_best`, `is_new`, `is_hot`, `is_promote`, `bonus_type_id`, `last_update`, `goods_type`, `seller_note`, `give_integral`, `rank_integral`, `suppliers_id`, `is_check`) VALUES 121 (32, 3, ‘ECS000032‘, ‘诺基亚N85‘, ‘+‘, 9, 1, ‘‘, 4, ‘0.000‘, ‘3612.00‘, ‘3010.00‘, ‘2750.00‘, 1243785600, 1417276800, 1, ‘2008年10月 GSM,850,900,1800,1900 黑色‘, ‘‘, ‘<p>诺基亚N85参数</p>\r\n<div> </div>\r\n<div>\r\n<table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td bgcolor="#f1f7fc" colspan="2">\r\n <p><b>基本参数</b></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">手机昵称</td>\r\n <td width="450" bgcolor="#ffffff">N85</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">上市日期</td>\r\n <td width="450" bgcolor="#ffffff">2008年10月</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">手机类型</td>\r\n <td width="450" bgcolor="#ffffff">3G手机；拍照手机；智能手机</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">手机制式</td>\r\n <td width="450" bgcolor="#ffffff">GSM</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">支持频段</td>\r\n <td width="450" bgcolor="#ffffff">GSM850/900/1800/1900MHz</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">数据传输</td>\r\n <td width="450" bgcolor="#ffffff">GPRS、EDGE</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">屏幕材质</td>\r\n <td width="450" bgcolor="#ffffff">AMOLED</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">屏幕色彩</td>\r\n <td width="450" bgcolor="#ffffff">1600万色</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">主屏尺寸</td>\r\n <td width="450" bgcolor="#ffffff">2.6英寸</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">主屏参数</td>\r\n <td width="450" bgcolor="#ffffff">QVGA 320×240像素</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">铃音描述</td>\r\n <td width="450" bgcolor="#ffffff">可选MP3、WAV、AAC或和弦Midi铃声等格式</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">操作系统</td>\r\n <td width="450" bgcolor="#ffffff">Symbian OS v9.3操作系统与S60 v3.2平台的组合</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">机身内存</td>\r\n <td width="450" bgcolor="#ffffff">74MB 内部动态存储空间<br />\r\n 78MB 内置NAND闪存</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">存储卡</td>\r\n <td width="450" bgcolor="#ffffff">支持MicroSD(T-Flash)卡扩展最大至8GB</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">电池规格</td>\r\n <td width="450" bgcolor="#ffffff">1200毫安时锂电池</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">标配</td>\r\n <td width="450" bgcolor="#ffffff">诺基亚 N85<br />\r\n 诺基亚电池（BL-5K）<br />\r\n 诺基亚旅行充电器（AC-10）<br />\r\n 诺基亚视频数据线（CA-75U）<br />\r\n 诺基亚数据线（CA-101）<br />\r\n 诺基亚音乐耳机（HS-45、AD-54）<br />\r\n 诺基亚 8 GB microSD 卡（MU-43）<br />\r\n 《用户手册》<br />\r\n 《快速入门》</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">理论通话时间</td>\r\n <td width="450" bgcolor="#ffffff">6.9 小时</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">理论待机时间</td>\r\n <td width="450" bgcolor="#ffffff">363 小时</td>\r\n </tr>\r\n <tr>\r\n <td bgcolor="#f1f7fc" colspan="2">\r\n <p><b>产品外形</b></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">外观设计</td>\r\n <td width="450" bgcolor="#ffffff">双向滑盖</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">产品尺寸</td>\r\n <td width="450" bgcolor="#ffffff">103×50×16mm<br />\r\n 体积：76 立方厘米</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">手机重量</td>\r\n <td width="450" bgcolor="#ffffff">128克</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">产品天线</td>\r\n <td width="450" bgcolor="#ffffff">内置</td>\r\n </tr>\r\n <tr>\r\n <td bgcolor="#f1f7fc" colspan="2">\r\n <p><b>拍照功能</b></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n <tbody>\r\n <tr>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">定时器</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">摄像头</td>\r\n <td width="450" bgcolor="#ffffff">内置</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">摄像头像素</td>\r\n <td width="450" bgcolor="#ffffff">500万像素</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">连拍功能</td>\r\n <td width="450" bgcolor="#ffffff">支持</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">LED闪光灯</td>\r\n <td width="450" bgcolor="#ffffff">双LED 闪光灯</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">数码变焦</td>\r\n <td width="450" bgcolor="#ffffff">20 倍数码变焦</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">拍摄模式</td>\r\n <td width="450" bgcolor="#ffffff">静止、连拍、自动定时器、摄像</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">照片特效</td>\r\n <td width="450" bgcolor="#ffffff">正常、怀旧、黑白、负片、逼真</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">拍照描述</td>\r\n <td width="450" bgcolor="#ffffff">支持最大2592×1944分辨率照片拍摄<br />\r\n 支持JPEG、Exif格式<br />\r\n 白平衡模式：自动、阳光、阴天、白炽灯、荧光灯<br />\r\n 感光度模式：高、中、低、自动</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">视频拍摄</td>\r\n <td width="450" bgcolor="#ffffff">最高支持640 x 480 像素（VGA）、30 帧/秒</td>\r\n </tr>\r\n <tr>\r\n <td bgcolor="#f1f7fc" colspan="2">\r\n <p><b>娱乐功能</b></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n <tbody>\r\n <tr>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">收音机</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">TV-OUT</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">录音功能</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">电子书</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">视频播放</td>\r\n <td width="450" bgcolor="#ffffff">内置RealPlayer播放器, 支持MPEG4、H.264/AVC、H.263/3GP、RealVideo等视频格式全屏播放</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">音乐播放</td>\r\n <td width="450" bgcolor="#ffffff">内置播放器, 支持mp3、.wma、.aac、eAAC、eAAC+格式</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">游戏</td>\r\n <td width="450" bgcolor="#ffffff">内置</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">Java功能</td>\r\n <td width="450" bgcolor="#ffffff">支持Java MIDP 2.0 CLDC 1.1</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">Flash功能</td>\r\n <td width="450" bgcolor="#ffffff">第3.0版Flash lite播放器</td>\r\n </tr>\r\n <tr>\r\n <td bgcolor="#f1f7fc" colspan="2">\r\n <p><b>数据功能</b></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n <tbody>\r\n <tr>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">蓝牙功能</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">数据线接口</td>\r\n <td width="450" bgcolor="#ffffff">USB数据线 3.5mm立体声耳机插孔</td>\r\n </tr>\r\n <tr>\r\n <td bgcolor="#f1f7fc" colspan="2">\r\n <p><b>基本功能</b></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n <tbody>\r\n <tr>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">短信(SMS)</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">彩信(MMS)</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">免提通话</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">情景模式</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">闹钟功能</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">日历功能</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">输入方式</td>\r\n <td width="450" bgcolor="#ffffff">键盘</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">通话记录</td>\r\n <td width="450" bgcolor="#ffffff">未接来电+已接来电+已拨电话记录</td>\r\n </tr>\r\n <tr>\r\n <td width="100" valign="center" bgcolor="#ffffff" align="left">通讯录</td>\r\n <td width="450" bgcolor="#ffffff">S60标准化名片式通讯录</td>\r\n </tr>\r\n <tr>\r\n <td bgcolor="#f1f7fc" colspan="2">\r\n <p><b>网络功能</b></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n <tbody>\r\n <tr>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">电子邮件</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">WWW浏览器</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">WAP浏览器</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td bgcolor="#f1f7fc" colspan="2">\r\n <p><b>商务功能</b></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n <tbody>\r\n <tr>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">飞行模式</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">语音拨号</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">备忘录</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">日程表</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">世界时间</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="100" style="padding: 5px 0px 5px 10px;"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td bgcolor="#f1f7fc" colspan="2">\r\n <p><b>其他功能</b></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n <tbody>\r\n <tr>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">GPS功能</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">电子词典</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">待机图片</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">计算器</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">来电铃声识别</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">来电图片识别</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">来电防火墙</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">动画屏保</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">图形菜单</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">秒表</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n <tbody>\r\n <tr>\r\n <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">单位换算</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n <td width="100" style="padding: 5px 0px 5px 10px;">\r\n <table width="100%" cellspacing="1" cellpadding="0" border="0">\r\n <tbody>\r\n <tr>\r\n <td width="100%" align="middle" style="padding: 2px; float: none;"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n</div>\r\n<p> </p>‘, ‘images/200905/thumb_img/32_thumb_G_1242110760196.jpg‘, ‘images/200905/goods_img/32_G_1242110760868.jpg‘, ‘images/200905/source_img/32_G_1242110760437.jpg‘, 1, ‘‘, 1, 1, 0, 30, 1242110760, 100, 0, 0, 1, 1, 1, 0, 1269589051, 9, ‘‘, -1, -1, NULL, NULL); 122 123 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 124 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 125 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1 ######################################## 2 # MySQL Crash Course 3 # http://www.forta.com/books/0672327120/ 4 # Example table creation scripts 5 ######################################## 6 7 8 ######################## 9 # Create crash_customers table 10 ######################## 11 CREATE TABLE crash_customers 12 ( 13 cust_id int NOT NULL AUTO_INCREMENT, 14 cust_name char(50) NOT NULL , 15 cust_address char(50) NULL , 16 cust_city char(50) NULL , 17 cust_state char(5) NULL , 18 cust_zip char(10) NULL , 19 cust_country char(50) NULL , 20 cust_contact char(50) NULL , 21 cust_email char(255) NULL , 22 PRIMARY KEY (cust_id) 23 ) ENGINE=InnoDB; 24 25 ######################### 26 # Create crash_orderitems table 27 ######################### 28 CREATE TABLE crash_orderitems 29 ( 30 order_num int NOT NULL , 31 order_item int NOT NULL , 32 prod_id char(10) NOT NULL , 33 quantity int NOT NULL , 34 item_price decimal(8,2) NOT NULL , 35 PRIMARY KEY (order_num, order_item) 36 ) ENGINE=InnoDB; 37 38 39 ##################### 40 # Create crash_orders table 41 ##################### 42 CREATE TABLE crash_orders 43 ( 44 order_num int NOT NULL AUTO_INCREMENT, 45 order_date datetime NOT NULL , 46 cust_id int NOT NULL , 47 PRIMARY KEY (order_num) 48 ) ENGINE=InnoDB; 49 50 ####################### 51 # Create crash_products table 52 ####################### 53 CREATE TABLE crash_products 54 ( 55 prod_id char(10) NOT NULL, 56 vend_id int NOT NULL , 57 prod_name char(255) NOT NULL , 58 prod_price decimal(8,2) NOT NULL , 59 prod_desc text NULL , 60 PRIMARY KEY(prod_id) 61 ) ENGINE=InnoDB; 62 63 ###################### 64 # Create crash_vendors table 65 ###################### 66 CREATE TABLE crash_vendors 67 ( 68 vend_id int NOT NULL AUTO_INCREMENT, 69 vend_name char(50) NOT NULL , 70 vend_address char(50) NULL , 71 vend_city char(50) NULL , 72 vend_state char(5) NULL , 73 vend_zip char(10) NULL , 74 vend_country char(50) NULL , 75 PRIMARY KEY (vend_id) 76 ) ENGINE=InnoDB; 77 78 ########################### 79 # Create crash_productnotes table 80 ########################### 81 CREATE TABLE crash_productnotes 82 ( 83 note_id int NOT NULL AUTO_INCREMENT, 84 prod_id char(10) NOT NULL, 85 note_date datetime NOT NULL, 86 note_text text NULL , 87 PRIMARY KEY(note_id), 88 FULLTEXT(note_text) 89 ) ENGINE=MyISAM; 90 91 92 ##################### 93 # Define crash_foreign keys 94 ##################### 95 ALTER TABLE crash_orderitems ADD CONSTRAINT fk_orderitems_orders FOREIGN KEY (order_num) REFERENCES crash_orders (order_num); 96 ALTER TABLE crash_orderitems ADD CONSTRAINT fk_orderitems_products FOREIGN KEY (prod_id) REFERENCES crash_products (prod_id); 97 ALTER TABLE crash_orders ADD CONSTRAINT fk_orders_customers FOREIGN KEY (cust_id) REFERENCES crash_customers (cust_id); 98 ALTER TABLE crash_products ADD CONSTRAINT fk_products_vendors FOREIGN KEY (vend_id) REFERENCES crash_vendors (vend_id); 99 100 101 ########################## 102 # Populate crash_customers table 103 ########################## 104 INSERT INTO crash_customers(cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact, cust_email) 105 VALUES(10001, ‘Coyote Inc.‘, ‘200 Maple Lane‘, ‘Detroit‘, ‘MI‘, ‘44444‘, ‘USA‘, ‘Y Lee‘, ‘ylee@coyote.com‘); 106 INSERT INTO crash_customers(cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact) 107 VALUES(10002, ‘Mouse House‘, ‘333 Fromage Lane‘, ‘Columbus‘, ‘OH‘, ‘43333‘, ‘USA‘, ‘Jerry Mouse‘); 108 INSERT INTO crash_customers(cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact, cust_email) 109 VALUES(10003, ‘Wascals‘, ‘1 Sunny Place‘, ‘Muncie‘, ‘IN‘, ‘42222‘, ‘USA‘, ‘Jim Jones‘, ‘rabbit@wascally.com‘); 110 INSERT INTO crash_customers(cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact, cust_email) 111 VALUES(10004, ‘Yosemite Place‘, ‘829 Riverside Drive‘, ‘Phoenix‘, ‘AZ‘, ‘88888‘, ‘USA‘, ‘Y Sam‘, ‘sam@yosemite.com‘); 112 INSERT INTO crash_customers(cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact) 113 VALUES(10005, ‘E Fudd‘, ‘4545 53rd Street‘, ‘Chicago‘, ‘IL‘, ‘54545‘, ‘USA‘, ‘E Fudd‘); 114 115 116 ######################## 117 # Populate crash_vendors table 118 ######################## 119 INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country) 120 VALUES(1001,‘Anvils R Us‘,‘123 Main Street‘,‘Southfield‘,‘MI‘,‘48075‘, ‘USA‘); 121 INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country) 122 VALUES(1002,‘LT Supplies‘,‘500 Park Street‘,‘Anytown‘,‘OH‘,‘44333‘, ‘USA‘); 123 INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country) 124 VALUES(1003,‘ACME‘,‘555 High Street‘,‘Los Angeles‘,‘CA‘,‘90046‘, ‘USA‘); 125 INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country) 126 VALUES(1004,‘Furball Inc.‘,‘1000 5th Avenue‘,‘New York‘,‘NY‘,‘11111‘, ‘USA‘); 127 INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country) 128 VALUES(1005,‘Jet Set‘,‘42 Galaxy Road‘,‘London‘, NULL,‘N16 6PS‘, ‘England‘); 129 INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country) 130 VALUES(1006,‘Jouets Et Ours‘,‘1 Rue Amusement‘,‘Paris‘, NULL,‘45678‘, ‘France‘); 131 132 133 ######################### 134 # Populate crash_products table 135 ######################### 136 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 137 VALUES(‘ANV01‘, 1001, ‘.5 ton anvil‘, 5.99, ‘.5 ton anvil, black, complete with handy hook‘); 138 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 139 VALUES(‘ANV02‘, 1001, ‘1 ton anvil‘, 9.99, ‘1 ton anvil, black, complete with handy hook and carrying case‘); 140 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 141 VALUES(‘ANV03‘, 1001, ‘2 ton anvil‘, 14.99, ‘2 ton anvil, black, complete with handy hook and carrying case‘); 142 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 143 VALUES(‘OL1‘, 1002, ‘Oil can‘, 8.99, ‘Oil can, red‘); 144 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 145 VALUES(‘FU1‘, 1002, ‘Fuses‘, 3.42, ‘1 dozen, extra long‘); 146 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 147 VALUES(‘SLING‘, 1003, ‘Sling‘, 4.49, ‘Sling, one size fits all‘); 148 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 149 VALUES(‘TNT1‘, 1003, ‘TNT (1 stick)‘, 2.50, ‘TNT, red, single stick‘); 150 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 151 VALUES(‘TNT2‘, 1003, ‘TNT (5 sticks)‘, 10, ‘TNT, red, pack of 10 sticks‘); 152 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 153 VALUES(‘FB‘, 1003, ‘Bird seed‘, 10, ‘Large bag (suitable for road runners)‘); 154 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 155 VALUES(‘FC‘, 1003, ‘Carrots‘, 2.50, ‘Carrots (rabbit hunting season only)‘); 156 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 157 VALUES(‘SAFE‘, 1003, ‘Safe‘, 50, ‘Safe with combination lock‘); 158 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 159 VALUES(‘DTNTR‘, 1003, ‘Detonator‘, 13, ‘Detonator (plunger powered), fuses not included‘); 160 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 161 VALUES(‘JP1000‘, 1005, ‘JetPack 1000‘, 35, ‘JetPack 1000, intended for single use‘); 162 INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc) 163 VALUES(‘JP2000‘, 1005, ‘JetPack 2000‘, 55, ‘JetPack 2000, multi-use‘); 164 165 166 167 ####################### 168 # Populate crash_orders table 169 ####################### 170 INSERT INTO crash_orders(order_num, order_date, cust_id) 171 VALUES(20005, ‘2005-09-01‘, 10001); 172 INSERT INTO crash_orders(order_num, order_date, cust_id) 173 VALUES(20006, ‘2005-09-12‘, 10003); 174 INSERT INTO crash_orders(order_num, order_date, cust_id) 175 VALUES(20007, ‘2005-09-30‘, 10004); 176 INSERT INTO crash_orders(order_num, order_date, cust_id) 177 VALUES(20008, ‘2005-10-03‘, 10005); 178 INSERT INTO crash_orders(order_num, order_date, cust_id) 179 VALUES(20009, ‘2005-10-08‘, 10001); 180 181 182 ########################### 183 # Populate crash_orderitems table 184 ########################### 185 INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price) 186 VALUES(20005, 1, ‘ANV01‘, 10, 5.99); 187 INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price) 188 VALUES(20005, 2, ‘ANV02‘, 3, 9.99); 189 INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price) 190 VALUES(20005, 3, ‘TNT2‘, 5, 10); 191 INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price) 192 VALUES(20005, 4, ‘FB‘, 1, 10); 193 INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price) 194 VALUES(20006, 1, ‘JP2000‘, 1, 55); 195 INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price) 196 VALUES(20007, 1, ‘TNT2‘, 100, 10); 197 INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price) 198 VALUES(20008, 1, ‘FC‘, 50, 2.50); 199 INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price) 200 VALUES(20009, 1, ‘FB‘, 1, 10); 201 INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price) 202 VALUES(20009, 2, ‘OL1‘, 1, 8.99); 203 INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price) 204 VALUES(20009, 3, ‘SLING‘, 1, 4.49); 205 INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price) 206 VALUES(20009, 4, ‘ANV03‘, 1, 14.99); 207 208 ############################# 209 # Populate crash_productnotes table 210 ############################# 211 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 212 VALUES(101, ‘TNT2‘, ‘2005-08-17‘, 213 ‘Customer complaint: 214 Sticks not individually wrapped, too easy to mistakenly detonate all at once. 215 Recommend individual wrapping.‘ 216 ); 217 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 218 VALUES(102, ‘OL1‘, ‘2005-08-18‘, 219 ‘Can shipped full, refills not available. 220 Need to order new can if refill needed.‘ 221 ); 222 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 223 VALUES(103, ‘SAFE‘, ‘2005-08-18‘, 224 ‘Safe is combination locked, combination not provided with safe. 225 This is rarely a problem as safes are typically blown up or dropped by customers.‘ 226 ); 227 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 228 VALUES(104, ‘FC‘, ‘2005-08-19‘, 229 ‘Quantity varies, sold by the sack load. 230 All guaranteed to be bright and orange, and suitable for use as rabbit bait.‘ 231 ); 232 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 233 VALUES(105, ‘TNT2‘, ‘2005-08-20‘, 234 ‘Included fuses are short and have been known to detonate too quickly for some customers. 235 Longer fuses are available (item FU1) and should be recommended.‘ 236 ); 237 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 238 VALUES(106, ‘TNT2‘, ‘2005-08-22‘, 239 ‘Matches not included, recommend purchase of matches or detonator (item DTNTR).‘ 240 ); 241 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 242 VALUES(107, ‘SAFE‘, ‘2005-08-23‘, 243 ‘Please note that no returns will be accepted if safe opened using explosives.‘ 244 ); 245 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 246 VALUES(108, ‘ANV01‘, ‘2005-08-25‘, 247 ‘Multiple customer returns, anvils failing to drop fast enough or falling backwards on purchaser. Recommend that customer considers using heavier anvils.‘ 248 ); 249 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 250 VALUES(109, ‘ANV03‘, ‘2005-09-01‘, 251 ‘Item is extremely heavy. Designed for dropping, not recommended for use with slings, ropes, pulleys, or tightropes.‘ 252 ); 253 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 254 VALUES(110, ‘FC‘, ‘2005-09-01‘, 255 ‘Customer complaint: rabbit has been able to detect trap, food apparently less effective now.‘ 256 ); 257 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 258 VALUES(111, ‘SLING‘, ‘2005-09-02‘, 259 ‘Shipped unassembled, requires common tools (including oversized hammer).‘ 260 ); 261 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 262 VALUES(112, ‘SAFE‘, ‘2005-09-02‘, 263 ‘Customer complaint: 264 Circular hole in safe floor can apparently be easily cut with handsaw.‘ 265 ); 266 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 267 VALUES(113, ‘ANV01‘, ‘2005-09-05‘, 268 ‘Customer complaint: 269 Not heavy enough to generate flying stars around head of victim. If being purchased for dropping, recommend ANV02 or ANV03 instead.‘ 270 ); 271 INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text) 272 VALUES(114, ‘SAFE‘, ‘2005-09-07‘, 273 ‘Call from individual trapped in safe plummeting to the ground, suggests an escape hatch be added. 274 Comment forwarded to vendor.‘ 275 );
原文：http://www.cnblogs.com/yahari/p/5817735.html