JOICQ_V1.0

已经实现添加、查找好友、登陆，聊天等功能

尚未实现的功能：
文件传输、内网穿透等功能

[color=red]<说明>
解压后的jar文件必须和images文件夹放到同一个目录下
否则，相关图片会找不到！[/color]

数据库脚本

/*
SQLyog - Free MySQL GUI v5.16 RC1
Host - 5.0.67-community-nt : Database - oicq
*********************************************************************
Server version : 5.0.67-community-nt
*/


SET NAMES utf8;

SET SQL_MODE='';

create database if not exists `oicq`;

USE `oicq`;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';

/*Table structure for table `tb_friend` */

DROP TABLE IF EXISTS `tb_friend`;

CREATE TABLE `tb_friend` (
`userName` varchar(20) collate gbk_bin NOT NULL,
`fName` varchar(20) collate gbk_bin NOT NULL,
`groupName` varchar(50) collate gbk_bin NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin;

/*Data for the table `tb_friend` */

insert into `tb_friend` (`userName`,`fName`,`groupName`) values ('jacky','tony','MyFriends');
insert into `tb_friend` (`userName`,`fName`,`groupName`) values ('jacky','Kobe','MyClassMaters');
insert into `tb_friend` (`userName`,`fName`,`groupName`) values ('jacky','parker','MyFriends');
insert into `tb_friend` (`userName`,`fName`,`groupName`) values ('jacky','T-Mac','MyFriends');
insert into `tb_friend` (`userName`,`fName`,`groupName`) values ('jacky','Yao','MyClassMaters');
insert into `tb_friend` (`userName`,`fName`,`groupName`) values ('tony','jacky','Good friend');

/*Table structure for table `tb_userinfo` */

DROP TABLE IF EXISTS `tb_userinfo`;

CREATE TABLE `tb_userinfo` (
`userName` varchar(20) collate gbk_bin NOT NULL,
`passWord` varchar(20) collate gbk_bin NOT NULL,
`nichName` varchar(20) collate gbk_bin NOT NULL default 'NoNich',
`icon` varchar(20) collate gbk_bin NOT NULL default 'default.gif',
PRIMARY KEY (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin;

/*Data for the table `tb_userinfo` */

insert into `tb_userinfo` (`userName`,`passWord`,`nichName`,`icon`) values ('Kobe','123','NoNich','default.gif');
insert into `tb_userinfo` (`userName`,`passWord`,`nichName`,`icon`) values ('T-Mac','123','NoNich','default.gif');
insert into `tb_userinfo` (`userName`,`passWord`,`nichName`,`icon`) values ('Yao','123','NoNich','default.gif');
insert into `tb_userinfo` (`userName`,`passWord`,`nichName`,`icon`) values ('jacky','123','丹纯子','gif-0208.gif');
insert into `tb_userinfo` (`userName`,`passWord`,`nichName`,`icon`) values ('parker','123','NoNich','default.gif');
insert into `tb_userinfo` (`userName`,`passWord`,`nichName`,`icon`) values ('tony','123','NoNich','gif-0208.gif');

SET SQL_MODE=@OLD_SQL_MODE;