ssm

ssm学习,环境搭建，对数据表的增删查改。

具体说明可以参考下面的博客园连接地址

http://www.cnblogs.com/supertonny/p/6341521.html

http://www.cnblogs.com/supertonny/p/6418966.html

sql脚本以及测试数据 /* Navicat MySQL Data Transfer

Source Server : mysql Source Server Version : 50519 Source Host : localhost:3306 Source Database : mybatis

Target Server Type : MYSQL Target Server Version : 50519 File Encoding : 65001

Date: 2017-04-21 15:35:26 */

SET FOREIGN_KEY_CHECKS=0;

-- Table structure for t_user

DROP TABLE IF EXISTS t_user; CREATE TABLE t_user ( userId int(11) NOT NULL AUTO_INCREMENT, userName varchar(50) NOT NULL, userAge int(11) NOT NULL, PRIMARY KEY (userId) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- Records of t_user

INSERT INTO t_user VALUES ('1', 'tinny', '10'); INSERT INTO t_user VALUES ('2', 'tonny', '11');

-- Table structure for users

DROP TABLE IF EXISTS users; CREATE TABLE users ( delflag int(11) DEFAULT NULL, id int(11) NOT NULL AUTO_INCREMENT, name varchar(20) DEFAULT NULL, password varchar(60) DEFAULT NULL, age int(11) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Records of users

INSERT INTO users VALUES ('0', '1', 'Tonny Chien', '123', '25'); INSERT INTO users VALUES ('0', '2', 'Tinny Cheung', '123', '22'); INSERT INTO users VALUES (null, '3', 'Jerry Chien', null, '-1');