自各儿做的jsp,AjaxChat在线聊天网站

/*
SQLyog 企业版 - MySQL GUI v7.14 
MySQL - 5.1.40-community : Database - lscsql
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

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

CREATE DATABASE /*!32312 IF NOT EXISTS*/`lscsql` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `lscsql`;

/*Table structure for table `content` */

DROP TABLE IF EXISTS `content`;

CREATE TABLE `content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `content` text,
  `createtime` datetime DEFAULT NULL,
  `touserid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `timeIndex` (`createtime`)
) ENGINE=InnoDB AUTO_INCREMENT=68860 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Table structure for table `messageinfo` */

DROP TABLE IF EXISTS `messageinfo`;

CREATE TABLE `messageinfo` (
  `mid` int(11) NOT NULL AUTO_INCREMENT,
  `messagetext` text,
  `createdate` datetime DEFAULT NULL,
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver" />
                <!-- <property name="url" value="jdbc:mysql://localhost:3306/lsc1414?characterEncoding=UTF-8"/> -->
                <property name="url"
                    value="jdbc:mysql://localhost:3306/database?useUnicode=true&amp;characterEncoding=UTF-8" />
                <!-- <property name="username" value="root"/> -->
                <property name="username" value="username" />  
                <property name="password" value="password" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="message/ibatis/Message.xml" />
        <mapper resource="message/ibatis/User.xml" />
    </mappers>
</configuration>