关于数据库乱码的实践
/*!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 */;
DROP DATABASE IF EXISTS `jyldjy`;
CREATE DATABASE `jyldjy` ;
USE `jyldjy`;
DROP TABLE IF EXISTS `tb_admin` ;
CREATE TABLE `tb_admin` ( `id` int AUTO_INCREMENT NOT NULL , `admin` varchar (50) NULL , `password` varchar (50) NULL ,PRIMARY KEY ( id )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `tb_admin` WRITE;
INSERT `tb_admin` ( `id` , `admin` , `password` ) VALUES ( 1 , 'admin' , 'admin' );
INSERT `tb_admin` ( `id` , `admin` , `password` ) VALUES ( 3 , 'mingrisoft' , 'www.mingrisoft.com' );
UNLOCK TABLES;
DROP TABLE IF EXISTS `tb_cjob` ;
CREATE TABLE `tb_cjob` ( `jobid` int AUTO_INCREMENT NOT NULL , `cname` varchar (20) NULL , `specialty` varchar (50) NULL , `job` varchar (50) NULL , `emolument` varchar (50) NULL , `ptime` datetime NULL , `atime` datetime NULL , `other` varchar (200) NULL,PRIMARY KEY (jobid) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `tb_cjob` WRITE;
INSERT `tb_cjob` ( `jobid` , `cname` , `specialty` , `job` , `emolument` , `ptime` , `atime` , `other` ) VALUES ( 31 , 'mr' , '计算机' , '网页制作人员' , '1500' , '2005-03-01 00:00:00' , '2005-03-06 00:00:00' , '有网页制作一年以上工作经验' );
INSERT `tb_cjob` ( `jobid` , `cname` , `specialty` , `job` , `emolument` , `ptime` , `atime` , `other` ) VALUES ( 32 , 'hf' , '电器行业' , '电器工程师' , '3000' , '2005-03-01 00:00:00' , '2005-10-01 00:00:00' , '有工作经验,本科学历以上。' );
UNLOCK TABLES;
DROP TABLE IF EXISTS `tb_company` ;
CREATE TABLE `tb_company` ( `cname` varchar (20) NOT NULL , `password` varchar (50) NOT NULL , `name` varchar (50) NOT NULL , `email` varchar (50) NULL , `tel` varchar (20) NULL , `manage` varchar (20) NULL , `address` varchar (100) NULL , `resume` text NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `tb_company` WRITE;
INSERT `tb_company` ( `cname` , `password` , `name` , `email` , `tel` , `manage` , `address` , `resume` ) VALUES ( 'd' , 'd' , 'd' , 'd' , '不详' , '不详' , '不详' , '无' );
INSERT `tb_company` ( `cname` , `password` , `name` , `email` , `tel` , `manage` , `address` , `resume` ) VALUES ( 'hf' , '111' , '汇丰集团' , 'www.hf@.com.cn' , '4975689' , '电器行业' , '长春市人民大街' , '成立于2000年,全国十大电器之一。' );
INSERT `tb_company` ( `cname` , `password` , `name` , `email` , `tel` , `manage` , `address` , `resume` ) VALUES ( 'mingri' , '123' , '明日科技有限公司' , 'mingri@shou.com' , '0431-4972266' , '计算机' , '长春市东盛大路89号' , '无' );
INSERT `tb_company` ( `cname` , `password` , `name` , `email` , `tel` , `manage` , `address` , `resume` ) VALUES ( 'mr' , '111' , '明日科技' , 'www.mingri@soft.com' , '4976622' , '计算机' , '长春市二道区' , '软件开发、网页制作、图书创作' );
INSERT `tb_company` ( `cname` , `password` , `name` , `email` , `tel` , `manage` , `address` , `resume` ) VALUES ( 'mrkj' , '800529' , '明日科技' , 'mingrisoft@mingrisoft.com' , '0431-4972266' , '软件开发图书编辑' , '吉林省长春市' , '主要以软件开发为导向' );
INSERT `tb_company` ( `cname` , `password` , `name` , `email` , `tel` , `manage` , `address` , `resume` ) VALUES ( 'qqqq' , 'qqqq' , 'qqqq' , 'qqqq' , '不详' , '不详' , '不详' , '无' );
INSERT `tb_company` ( `cname` , `password` , `name` , `email` , `tel` , `manage` , `address` , `resume` ) VALUES ( 'rf' , '111' , '瑞峰科技' , 'rf@.2005' , '0431-4696464' , '计算机' , '长春市二道区' , '成立于2004年' );
INSERT `tb_company` ( `cname` , `password` , `name` , `email` , `tel` , `manage` , `address` , `resume` ) VALUES ( 'TwinBoys' , '830616' , 'TwinBoys工作室' , 'eutwin@sina.com' , '12345677' , '计算机软件' , '长春市' , '无' );
UNLOCK TABLES;
DROP TABLE IF EXISTS `tb_flink` ;
CREATE TABLE `tb_flink` ( `id` int AUTO_INCREMENT NOT NULL , `name` varchar (20) NULL , `address` varchar (50) NULL ,PRIMARY KEY ( `id` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `tb_flink` WRITE;
INSERT `tb_flink` ( `id` , `name` , `address` ) VALUES ( 9 , '图书展示' , 'http://www.163.com' );
INSERT `tb_flink` ( `id` , `name` , `address` ) VALUES ( 10 , '明日科技' , 'http://www.mingrisoft.com' );
INSERT `tb_flink` ( `id` , `name` , `address` ) VALUES ( 12 , '富华科苑' , 'http://www.fuhua.com' );
INSERT `tb_flink` ( `id` , `name` , `address` ) VALUES ( 14 , '深圳蛇口' , 'gfggrdf' );
UNLOCK TABLES;
DROP TABLE IF EXISTS `tb_sjob` ;
CREATE TABLE `tb_sjob` ( `jobid` int AUTO_INCREMENT NOT NULL , `sname` varchar (20) NULL , `specialty` varchar (50) NULL , `job` varchar (50) NULL , `emolument` varchar (50) NULL , `ptime` datetime NULL , `atime` datetime NULL , `other` varchar (200) NULL,PRIMARY KEY ( `jobid` ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `tb_sjob` WRITE;
INSERT `tb_sjob` ( `jobid` , `sname` , `specialty` , `job` , `emolument` , `ptime` , `atime` , `other` ) VALUES ( 56 , 'tiansi' , '美工' , '计算机平面' , '1800元' , '2005-02-03 00:00:00' , '2006-05-29 00:00:00' , '本人毕业于吉林广播电视大学计算机系到今已有五年的工作经验' );
INSERT `tb_sjob` ( `jobid` , `sname` , `specialty` , `job` , `emolument` , `ptime` , `atime` , `other` ) VALUES ( 66 , 'al' , '计算机' , '程序员' , '2000' , '2005-03-01 00:00:00' , '2005-03-25 00:00:00' , '本人曾获高级程序员证书' );
INSERT `tb_sjob` ( `jobid` , `sname` , `specialty` , `job` , `emolument` , `ptime` , `atime` , `other` ) VALUES ( 67 , 'sl' , '旅游' , '导游' , '1600' , '2005-03-01 00:00:00' , '2005-06-16 00:00:00' , '有半年工作经验' );
UNLOCK TABLES;
DROP TABLE IF EXISTS `tb_student` ;
CREATE TABLE `tb_student` ( `sname` varchar (20) NOT NULL , `password` varchar (50) NULL , `name` varchar (20) NULL , `age` int NULL , `sex` int NULL , `birthday` datetime NULL , `school` varchar (50) NULL , `specialty` varchar (50) NULL , `knowledge` varchar (20) NULL , `email` varchar (50) NULL , `resume` text NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `tb_student` WRITE;
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'al' , '11' , '李丽' , 21 , 0 , '1985-02-25 00:00:00' , '吉林省师范学院' , '计算机' , '大专' , 'www.al@.com' , '现应读于师范学院计算机系' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'baobao' , '789' , '赵真' , 21 , 0 , '1983-04-02 00:00:00' , '长春师范学院' , '幼儿教育' , '专科' , 'baobao@msn.com' , '无' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'crazyadept' , 'd' , 'crazyadept' , 23 , 1 , '1982-06-06 00:00:00' , '不详' , '不详' , '不详' , 'crazyadept@163.com' , '无' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'dd' , 'dd' , 'dd' , 23 , 1 , '2005-09-09 00:00:00' , '不详' , '不详' , '不详' , 'ddd@163.com' , '无' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'eutwin' , '830616' , '张雨' , 23 , 1 , '1983-06-16 00:00:00' , '铁经' , '计算机' , '中专' , 'eutwin@sina.com' , '无' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'lili' , 'a' , '赵丽' , 26 , 0 , '1999-09-09 00:00:00' , '师大' , '美容' , '专科' , 'lili@chinaren.com' , '无' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'lizhong' , '789' , '李中' , 22 , 1 , '1982-09-09 00:00:00' , '吉林大学' , '电子商务' , '本科' , 'li123@shou.com' , '无' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'lx' , '1' , '1' , 21 , 0 , '1985-02-25 00:00:00' , '第二高中' , '不详' , '不详' , '10@.com' , '无' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'qq' , 'qq' , 'qqq' , 23 , 1 , '1980-05-29 00:00:00' , '不详' , '不详' , '不详' , '@.eer' , '无' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'qqq' , 'qq' , 'qqq' , 23 , 1 , '1980-05-29 00:00:00' , '不详' , '不详' , '不详' , '@.eer' , '无' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'sl' , '111' , '孙丽' , 21 , 0 , '1985-01-16 00:00:00' , '长春市导游学院' , '导游' , '中专' , 'www.sl@.com' , '有导游工作经验半年' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'tiansi' , '800529' , 'tiansi' , 25 , 0 , '1980-05-29 00:00:00' , '广播电视' , '计算机' , '大专' , 'Tiansi529@sina.com' , '富华科苑
明日科技' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'toutiansi' , 'q' , 'q' , 1 , 1 , '1980-05-29 00:00:00' , '不详' , '不详' , '不详' , '@.eer' , '无' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'ts' , '800529' , '天思' , 25 , 0 , '1980-05-29 00:00:00' , '吉林广播电视大学计算机系' , '计算机应用' , '大专' , 'Tiansi529@sina.com' , '2001-07就职于吉林富华医用高分子材料有限公司
2003-02就职于吉林省明日科技有限责任公司' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'wangma' , '789' , '王茵' , 29 , 0 , '1898-01-01 00:00:00' , '长春工程学院' , '工程设计' , '专科' , 'yiyi@chainren.com' , '曾获得全国青年杯唱手第一名' );
INSERT `tb_student` ( `sname` , `password` , `name` , `age` , `sex` , `birthday` , `school` , `specialty` , `knowledge` , `email` , `resume` ) VALUES ( 'z' , 'q' , '5' , 2 , 1 , '1982-06-06 00:00:00' , '不详' , '不详' , '不详' , '@.eer' , '无' );
UNLOCK TABLES;
/*!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 */;
上面是我所用的数据库表,保存为sql文件的时候必须保存为utf-8编码的文件,不然有中文的地方不是出现乱码,就是莫名的变做空值。。
数据库连接必须这样:jdbc:mysql://localhost:3306/jyldjy?useUnicode=true&characterEncoding=gbk
jsp页面也全部使用<%@ page contentType="text/html; charset=gbk" %>