JOICQ_V1.0

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

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

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

数据库脚本

/*
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;

评论

1 楼 ReaiJava 2009-01-23  

运行程序报出拒绝连接错误 java.rmi.ConnectException: Connection refused to host: localhost; nested exception is:
java.net.ConnectException: Connection refused: connect

SYSTEM-CONFIG.cfg  url改成本地的 URL=jdbc:mysql://localhost:3306/oicq
还是报错？？