1.创建数据库
CREATE DATABASE /!32312 IF NOT EXISTS/smbms
/*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE smbms
;
/*Table structure for table smbms_address
*/
DROP TABLE IF EXISTS smbms_address
;
CREATE TABLE smbms_address
(
id
BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键ID’,
contact
VARCHAR(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘联系人姓名’,
addressDesc
VARCHAR(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘收货地址明细’,
postCode
VARCHAR(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘邮编’,
tel
VARCHAR(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘联系人电话’,
createdBy
BIGINT(20) DEFAULT NULL COMMENT ‘创建者’,
creationDate
DATETIME DEFAULT NULL COMMENT ‘创建时间’,
modifyBy
BIGINT(20) DEFAULT NULL COMMENT ‘修改者’,
modifyDate
DATETIME DEFAULT NULL COMMENT ‘修改时间’,
userId
BIGINT(20) DEFAULT NULL COMMENT ‘用户ID’,
PRIMARY KEY (id
)
) ENGINE=INNODB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table smbms_address
*/
INSERT INTO smbms_address
(id
,contact
,addressDesc
,postCode
,tel
,createdBy
,creationDate
,modifyBy
,modifyDate
,userId
) VALUES (1,‘王丽’,‘北京市东城区东交民巷44号’,‘100010’,‘13678789999’,1,‘2016-04-13 00:00:00’,NULL,NULL,1),(2,‘张红丽’,‘北京市海淀区丹棱街3号’,‘100000’,‘18567672312’,1,‘2016-04-13 00:00:00’,NULL,NULL,1),(3,‘任志强’,‘北京市东城区美术馆后街23号’,‘100021’,‘13387906742’,1,‘2016-04-13 00:00:00’,NULL,NULL,1),(4,‘曹颖’,‘北京市朝阳区朝阳门南大街14号’,‘100053’,‘13568902323’,1,‘2016-04-13 00:00:00’,NULL,NULL,2),(5,‘李慧’,‘北京市西城区三里河路南三巷3号’,‘100032’,‘18032356666’,1,‘2016-04-13 00:00:00’,NULL,NULL,3),(6,‘王国强’,‘北京市顺义区高丽营镇金马工业区18号’,‘100061’,‘13787882222’,1,‘2016-04-13 00:00:00’,NULL,NULL,3);
/*Table structure for table smbms_bill
*/
DROP TABLE IF EXISTS smbms_bill
;
CREATE TABLE smbms_bill
(
id
BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键ID’,
billCode
VARCHAR(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘账单编码’,
productName
VARCHAR(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘商品名称’,
productDesc
VARCHAR(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘商品描述’,
productUnit
VARCHAR(10) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘商品单位’,
productCount
DECIMAL(20,2) DEFAULT NULL COMMENT ‘商品数量’,
totalPrice
DECIMAL(20,2) DEFAULT NULL COMMENT ‘商品总额’,
isPayment
INT(10) DEFAULT NULL COMMENT ‘是否支付(1:未支付 2:已支付)’,
createdBy
BIGINT(20) DEFAULT NULL COMMENT ‘创建者(userId)’,
creationDate
DATETIME DEFAULT NULL COMMENT ‘创建时间’,
modifyBy
BIGINT(20) DEFAULT NULL COMMENT ‘更新者(userId)’,
modifyDate
DATETIME DEFAULT NULL COMMENT ‘更新时间’,
providerId
INT(20) DEFAULT NULL COMMENT ‘供应商ID’,
PRIMARY KEY (id
)
) ENGINE=INNODB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table smbms_bill
*/
INSERT INTO smbms_bill
(id
,billCode
,productName
,productDesc
,productUnit
,productCount
,totalPrice
,isPayment
,createdBy
,creationDate
,modifyBy
,modifyDate
,providerId
) VALUES (1,‘BILL2016_001’,‘洗发水、护发素’,‘日用品-洗发、护发’,‘瓶’,‘500.00’,‘25000.00’,2,1,‘2014-12-14 13:02:03’,NULL,NULL,13),(2,‘BILL2016_002’,‘香皂、肥皂、药皂’,‘日用品-皂类’,‘块’,‘1000.00’,‘10000.00’,2,1,‘2016-03-23 04:20:40’,NULL,NULL,13),(3,‘BILL2016_003’,‘大豆油’,‘食品-食用油’,‘斤’,‘300.00’,‘5890.00’,2,1,‘2014-12-14 13:02:03’,NULL,NULL,6),(4,‘BILL2016_004’,‘橄榄油’,‘食品-进口食用油’,‘斤’,‘200.00’,‘9800.00’,2,1,‘2013-10-10 03:12:13’,NULL,NULL,7),(5,‘BILL2016_005’,‘洗洁精’,‘日用品-厨房清洁’,‘瓶’,‘500.00’,‘7000.00’,2,1,‘2014-12-14 13:02:03’,NULL,NULL,9),(6,‘BILL2016_006’,‘美国大杏仁’,‘食品-坚果’,‘袋’,‘300.00’,‘5000.00’,2,1,‘2016-04-14 06:08:09’,NULL,NULL,4),(7,‘BILL2016_007’,‘沐浴液、精油’,‘日用品-沐浴类’,‘瓶’,‘500.00’,‘23000.00’,1,1,‘2016-07-22 10:10:22’,NULL,NULL,14),(8,‘BILL2016_008’,‘不锈钢盘碗’,‘日用品-厨房用具’,‘个’,‘600.00’,‘6000.00’,2,1,‘2016-04-14 05:12:13’,NULL,NULL,14),(9,‘BILL2016_009’,‘塑料杯’,‘日用品-杯子’,‘个’,‘350.00’,‘1750.00’,2,1,‘2016-02-04 11:40:20’,NULL,NULL,14),(10,‘BILL2016_010’,‘豆瓣酱’,‘食品-调料’,‘瓶’,‘200.00’,‘2000.00’,2,1,‘2013-10-29 05:07:03’,NULL,NULL,8),(11,‘BILL2016_011’,‘海之蓝’,‘饮料-国酒’,‘瓶’,‘50.00’,‘10000.00’,1,1,‘2016-04-14 16:16:00’,NULL,NULL,1),(12,‘BILL2016_012’,‘芝华士’,‘饮料-洋酒’,‘瓶’,‘20.00’,‘6000.00’,1,1,‘2016-09-09 17:00:00’,NULL,NULL,1),(13,‘BILL2016_013’,‘长城红葡萄酒’,‘饮料-红酒’,‘瓶’,‘60.00’,‘800.00’,2,1,‘2016-11-14 15:23:00’,NULL,NULL,1),(14,‘BILL2016_014’,‘泰国香米’,‘食品-大米’,‘斤’,‘400.00’,‘5000.00’,2,1,‘2016-10-09 15:20:00’,NULL,NULL,3),(15,‘BILL2016_015’,‘东北大米’,‘食品-大米’,‘斤’,‘600.00’,‘4000.00’,2,1,‘2016-11-14 14:00:00’,NULL,NULL,3),(16,‘BILL2016_016’,‘可口可乐’,‘饮料’,‘瓶’,‘2000.00’,‘6000.00’,2,1,‘2012-03-27 13:03:01’,NULL,NULL,2),(17,‘BILL2016_017’,‘脉动’,‘饮料’,‘瓶’,‘1500.00’,‘4500.00’,2,1,‘2016-05-10 12:00:00’,NULL,NULL,2),(18,‘BILL2016_018’,‘哇哈哈’,‘饮料’,‘瓶’,‘2000.00’,‘4000.00’,2,1,‘2015-11-24 15:12:03’,NULL,NULL,2);
/*Table structure for table smbms_provider
*/
DROP TABLE IF EXISTS smbms_provider
;
CREATE TABLE smbms_provider
(
id
BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键ID’,
proCode
VARCHAR(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘供应商编码’,
proName
VARCHAR(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘供应商名称’,
proDesc
VARCHAR(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘供应商详细描述’,
proContact
VARCHAR(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘供应商联系人’,
proPhone
VARCHAR(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘联系电话’,
proAddress
VARCHAR(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘地址’,
proFax
VARCHAR(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘传真’,
createdBy
BIGINT(20) DEFAULT NULL COMMENT ‘创建者(userId)’,
creationDate
DATETIME DEFAULT NULL COMMENT ‘创建时间’,
modifyDate
DATETIME DEFAULT NULL COMMENT ‘更新时间’,
modifyBy
BIGINT(20) DEFAULT NULL COMMENT ‘更新者(userId)’,
PRIMARY KEY (id
)
) ENGINE=INNODB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table smbms_provider
*/
INSERT INTO smbms_provider
(id
,proCode
,proName
,proDesc
,proContact
,proPhone
,proAddress
,proFax
,createdBy
,creationDate
,modifyDate
,modifyBy
) VALUES (1,‘BJ_GYS001’,‘北京三木堂商贸有限公司’,‘长期合作伙伴,主营产品:茅台、五粮液、郎酒、酒鬼酒、泸州老窖、赖茅酒、法国红酒等’,‘张国强’,‘13566667777’,‘北京市丰台区育芳园北路’,‘010-58858787’,1,‘2013-03-21 16:52:07’,NULL,NULL),(2,‘HB_GYS001’,‘石家庄帅益食品贸易有限公司’,‘长期合作伙伴,主营产品:饮料、水饮料、植物蛋白饮料、休闲食品、果汁饮料、功能饮料等’,‘王军’,‘13309094212’,‘河北省石家庄新华区’,‘0311-67738876’,1,‘2016-04-13 04:20:40’,NULL,NULL),(3,‘GZ_GYS001’,‘深圳市泰香米业有限公司’,‘初次合作伙伴,主营产品:良记金轮米,龙轮香米等’,‘郑程瀚’,‘13402013312’,‘广东省深圳市福田区深南大道6006华丰大厦’,‘0755-67776212’,1,‘2014-03-21 16:56:07’,NULL,NULL),(4,‘GZ_GYS002’,‘深圳市喜来客商贸有限公司’,‘长期合作伙伴,主营产品:坚果炒货.果脯蜜饯.天然花茶.营养豆豆.特色美食.进口食品.海味零食.肉脯肉’,‘林妮’,‘18599897645’,‘广东省深圳市福龙工业区B2栋3楼西’,‘0755-67772341’,1,‘2013-03-22 16:52:07’,NULL,NULL),(5,‘JS_GYS001’,‘兴化佳美调味品厂’,‘长期合作伙伴,主营产品:天然香辛料、鸡精、复合调味料’,‘徐国洋’,‘13754444221’,‘江苏省兴化市林湖工业区’,‘0523-21299098’,1,‘2015-11-22 16:52:07’,NULL,NULL),(6,‘BJ_GYS002’,‘北京纳福尔食用油有限公司’,‘长期合作伙伴,主营产品:山茶油、大豆油、花生油、橄榄油等’,‘马莺’,‘13422235678’,‘北京市朝阳区珠江帝景1号楼’,‘010-588634233’,1,‘2012-03-21 17:52:07’,NULL,NULL),(7,‘BJ_GYS003’,‘北京国粮食用油有限公司’,‘初次合作伙伴,主营产品:花生油、大豆油、小磨油等’,‘王驰’,‘13344441135’,‘北京大兴青云店开发区’,‘010-588134111’,1,‘2016-04-13 00:00:00’,NULL,NULL),(8,‘ZJ_GYS001’,‘慈溪市广和绿色食品厂’,‘长期合作伙伴,主营产品:豆瓣酱、黄豆酱、甜面酱,辣椒,大蒜等农产品’,‘薛圣丹’,‘18099953223’,‘浙江省宁波市慈溪周巷小安村’,‘0574-34449090’,1,‘2013-11-21 06:02:07’,NULL,NULL),(9,‘GX_GYS001’,‘优百商贸有限公司’,‘长期合作伙伴,主营产品:日化产品’,‘李立国’,‘13323566543’,‘广西南宁市秀厢大道42-1号’,‘0771-98861134’,1,‘2013-03-21 19:52:07’,NULL,NULL),(10,‘JS_GYS002’,‘南京火头军信息技术有限公司’,‘长期合作伙伴,主营产品:不锈钢厨具等’,‘陈女士’,‘13098992113’,‘江苏省南京市浦口区浦口大道1号新城总部大厦A座903室’,‘025-86223345’,1,‘2013-03-25 16:52:07’,NULL,NULL),(11,‘GZ_GYS003’,‘广州市白云区美星五金制品厂’,‘长期合作伙伴,主营产品:海绵床垫、坐垫、靠垫、海绵枕头、头枕等’,‘梁天’,‘13562276775’,‘广州市白云区钟落潭镇福龙路20号’,‘020-85542231’,1,‘2016-12-21 06:12:17’,NULL,NULL),(12,‘BJ_GYS004’,‘北京隆盛日化科技’,‘长期合作伙伴,主营产品:日化环保清洗剂,家居洗涤专卖、洗涤用品网、墙体除霉剂、墙面霉菌清除剂等’,‘孙欣’,‘13689865678’,‘北京市大兴区旧宫’,‘010-35576786’,1,‘2014-11-21 12:51:11’,NULL,NULL),(13,‘SD_GYS001’,‘山东豪克华光联合发展有限公司’,‘长期合作伙伴,主营产品:洗衣皂、洗衣粉、洗衣液、洗洁精、消杀类、香皂等’,‘吴洪转’,‘13245468787’,‘山东济阳济北工业区仁和街21号’,‘0531-53362445’,1,‘2015-01-28 10:52:07’,NULL,NULL),(14,‘JS_GYS003’,‘无锡喜源坤商行’,‘长期合作伙伴,主营产品:日化品批销’,‘周一清’,‘18567674532’,‘江苏无锡盛岸西路’,‘0510-32274422’,1,‘2016-04-23 11:11:11’,NULL,NULL),(15,‘ZJ_GYS002’,‘乐摆日用品厂’,‘长期合作伙伴,主营产品:各种中、高档塑料杯,塑料乐扣水杯(密封杯)、保鲜杯(保鲜盒)、广告杯、礼品杯’,‘王世杰’,‘13212331567’,‘浙江省金华市义乌市义东路’,‘0579-34452321’,1,‘2016-08-22 10:01:30’,NULL,NULL);
/*Table structure for table smbms_role
*/
DROP TABLE IF EXISTS smbms_role
;
CREATE TABLE smbms_role
(
id
BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键ID’,
roleCode
VARCHAR(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘角色编码’,
roleName
VARCHAR(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘角色名称’,
createdBy
BIGINT(20) DEFAULT NULL COMMENT ‘创建者’,
creationDate
DATETIME DEFAULT NULL COMMENT ‘创建时间’,
modifyBy
BIGINT(20) DEFAULT NULL COMMENT ‘修改者’,
modifyDate
DATETIME DEFAULT NULL COMMENT ‘修改时间’,
PRIMARY KEY (id
)
) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table smbms_role
*/
INSERT INTO smbms_role
(id
,roleCode
,roleName
,createdBy
,creationDate
,modifyBy
,modifyDate
) VALUES (1,‘SMBMS_ADMIN’,‘系统管理员’,1,‘2016-04-13 00:00:00’,NULL,NULL),(2,‘SMBMS_MANAGER’,‘经理’,1,‘2016-04-13 00:00:00’,NULL,NULL),(3,‘SMBMS_EMPLOYEE’,‘普通员工’,1,‘2016-04-13 00:00:00’,NULL,NULL);
/*Table structure for table smbms_user
*/
DROP TABLE IF EXISTS smbms_user
;
CREATE TABLE smbms_user
(
id
BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键ID’,
userCode
VARCHAR(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘用户编码’,
userName
VARCHAR(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘用户名称’,
userPassword
VARCHAR(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘用户密码’,
gender
INT(10) DEFAULT NULL COMMENT ‘性别(1:女、 2:男)’,
birthday
DATE DEFAULT NULL COMMENT ‘出生日期’,
phone
VARCHAR(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘手机’,
address
VARCHAR(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT ‘地址’,
userRole
INT(10) DEFAULT NULL COMMENT ‘用户角色(取自角色表-角色id)’,
createdBy
BIGINT(20) DEFAULT NULL COMMENT ‘创建者(userId)’,
creationDate
DATETIME DEFAULT NULL COMMENT ‘创建时间’,
modifyBy
BIGINT(20) DEFAULT NULL COMMENT ‘更新者(userId)’,
modifyDate
DATETIME DEFAULT NULL COMMENT ‘更新时间’,
PRIMARY KEY (id
)
) ENGINE=INNODB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table smbms_user
*/
INSERT INTO smbms_user
(id
,userCode
,userName
,userPassword
,gender
,birthday
,phone
,address
,userRole
,createdBy
,creationDate
,modifyBy
,modifyDate
) VALUES (1,‘admin’,‘系统管理员’,‘1234567’,1,‘1983-10-10’,‘13688889999’,‘北京市海淀区成府路207号’,1,1,‘2013-03-21 16:52:07’,NULL,NULL),(2,‘liming’,‘李明’,‘0000000’,2,‘1983-12-10’,‘13688884457’,‘北京市东城区前门东大街9号’,2,1,‘0000-00-00 00:00:00’,NULL,NULL),(5,‘hanlubiao’,‘韩路彪’,‘0000000’,2,‘1984-06-05’,‘18567542321’,‘北京市朝阳区北辰中心12号’,2,1,‘2014-12-31 19:52:09’,NULL,NULL),(6,‘zhanghua’,‘张华’,‘0000000’,1,‘1983-06-15’,‘13544561111’,‘北京市海淀区学院路61号’,3,1,‘2013-02-11 10:51:17’,NULL,NULL),(7,‘wangyang’,‘王洋’,‘0000000’,2,‘1982-12-31’,‘13444561124’,‘北京市海淀区西二旗辉煌国际16层’,3,1,‘2014-06-11 19:09:07’,NULL,NULL),(8,‘zhaoyan’,‘赵燕’,‘0000000’,1,‘1986-03-07’,‘18098764545’,‘北京市海淀区回龙观小区10号楼’,3,1,‘2016-04-21 13:54:07’,NULL,NULL),(10,‘sunlei’,‘孙磊’,‘0000000’,2,‘1981-01-04’,‘13387676765’,‘北京市朝阳区管庄新月小区12楼’,3,1,‘2015-05-06 10:52:07’,NULL,NULL),(11,‘sunxing’,‘孙兴’,‘0000000’,2,‘1978-03-12’,‘13367890900’,‘北京市朝阳区建国门南大街10号’,3,1,‘2016-11-09 16:51:17’,NULL,NULL),(12,‘zhangchen’,‘张晨’,‘0000000’,1,‘1986-03-28’,‘18098765434’,‘朝阳区管庄路口北柏林爱乐三期13号楼’,3,1,‘2016-08-09 05:52:37’,1,‘2016-04-14 14:15:36’),(13,‘dengchao’,‘邓超’,‘0000000’,2,‘1981-11-04’,‘13689674534’,‘北京市海淀区北航家属院10号楼’,3,1,‘2016-07-11 08:02:47’,NULL,NULL),(14,‘yangguo’,‘杨过’,‘0000000’,2,‘1980-01-01’,‘13388886623’,‘北京市朝阳区北苑家园茉莉园20号楼’,3,1,‘2015-02-01 03:52:07’,NULL,NULL),(15,‘zhaomin’,‘赵敏’,‘0000000’,1,‘1987-12-04’,‘18099897657’,‘北京市昌平区天通苑3区12号楼’,2,1,‘2015-09-12 12:02:12’,NULL,NULL);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE /;
/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
/!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2.创建maven项目,加入Spring、Mybatis及整合相关的jar文件
<?xml version="1.0" encoding="UTF-8"?>
4.0.0
com.bdqn.Spring_MyBatis2
Spring_MyBatis2
1.0-SNAPSHOT
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-dbcp2</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.40</version>
</dependency>
<!--mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.4</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency>
<!-- log4j -->
<!-- https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-core -->
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-core</artifactId>
<version>2.8.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.13</version>
</dependency>
<!-- https://mvnrepository.com/artifact/aopalliance/aopalliance -->
<dependency>
<groupId>aopalliance</groupId>
<artifactId>aopalliance</artifactId>
<version>1.0</version>
</dependency>
src/main/java **/*.xml
- 先在com.bqdn下创建4个包分别是entity,dao,service,mapper,
- 在entity目录下创建类Provider
package com.bdqn.entity;
import javax.swing.plaf.SliderUI;
import java.util.Date;
/**
-
供应商类
*/
public class Provider {
private int id; //主键id
private String proCode; //供应商编码
private String proName; //供应商名称
private String proDesc; //供应商详细描述
private String proContact; //供应商联系人
private String proPhone; //联系电话
private String proAddress; //地址
private String proFax; //传真
private long createdBy; //创建者(userId)
private Date creationDate; //创建时间
private Date modifyDate; //更新时间
private long modifyBy; //更新者public Provider() {
}public Provider(int id, String proCode, String proName, String proDesc, String proContact, String proPhone, String proAddress, String proFax, long createdBy, Date creationDate, Date modifyDate, long modifyBy) {
this.id = id;
this.proCode = proCode;
this.proName = proName;
this.proDesc = proDesc;
this.proContact = proContact;
this.proPhone = proPhone;
this.proAddress = proAddress;
this.proFax = proFax;
this.createdBy = createdBy;
this.creationDate = creationDate;
this.modifyDate = modifyDate;
this.modifyBy = modifyBy;
}public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}public String getProCode() {
return proCode;
}
public void setProCode(String proCode) {
this.proCode = proCode;
}public String getProName() {
return proName;
}
public void setProName(String proName) {
this.proName = proName;
}public String getProDesc() {
return proDesc;
}
public void setProDesc(String proDesc) {
this.proDesc = proDesc;
}public String getProContact() {
return proContact;
}
public void setProContact(String proContact) {
this.proContact = proContact;
}public String getProPhone() {
return proPhone;
}
public void setProPhone(String proPhone) {
this.proPhone = proPhone;
}public String getProAddress() {
return proAddress;
}
public void setProAddress(String proAddress) {
this.proAddress = proAddress;
}public String getProFax() {
return proFax;
}
public void setProFax(String proFax) {
this.proFax = proFax;
}public long getCreatedBy() {
return createdBy;
}
public void setCreatedBy(long createdBy) {
this.createdBy = createdBy;
}public Date getCreationDate() {
return creationDate;
}
public void setCreationDate(Date creationDate) {
this.creationDate = creationDate;
}public Date getModifyDate() {
return modifyDate;
}
public void setModifyDate(Date modifyDate) {
this.modifyDate = modifyDate;
}public long getModifyBy() {
return modifyBy;
}
public void setModifyBy(long modifyBy) {
this.modifyBy = modifyBy;
}@Override
public String toString() {
return “Provider{” +
“id=” + id +
“, proCode=’” + proCode + ‘’’ +
“, proName=’” + proName + ‘’’ +
“, proDesc=’” + proDesc + ‘’’ +
“, proContact=’” + proContact + ‘’’ +
“, proPhone=’” + proPhone + ‘’’ +
“, proAddress=’” + proAddress + ‘’’ +
“, proFax=’” + proFax + ‘’’ +
“, createdBy=” + createdBy +
“, creationDate=” + creationDate +
“, modifyDate=” + modifyDate +
“, modifyBy=” + modifyBy +
‘}’;
}
}
5.在dao目录下创建接口ProviderDao
package com.bdqn.dao;
import com.bdqn.entity.Provider;
import java.util.List;
public interface ProviderDao {
public List getList();
}
6.在dao目录下创建一个包Impl
package com.bdqn.dao.Impl;
import com.bdqn.dao.ProviderDao;
import com.bdqn.entity.Provider;
import org.mybatis.spring.SqlSessionTemplate;
import java.util.List;
public class ProviderDaoImpl implements ProviderDao{
private SqlSessionTemplate sqlSessionTemplate;
public SqlSessionTemplate getSqlSessionTemplate() {
return sqlSessionTemplate;
}
public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate) {
this.sqlSessionTemplate = sqlSessionTemplate;
}
public List<Provider> getList() {
return sqlSessionTemplate.selectList("com.bdqn.dao.ProviderDao.getList");
}
}
7.在service目录下创建ProviderService
package com.bdqn.service;
import com.bdqn.entity.Provider;
import java.util.List;
public interface ProviderService {
public List getList();
}
8.在service目录下创建一个包Impl
在Impl目录下创建实现类ProviderServiceImpl
package com.bdqn.service.Impl;
import com.bdqn.dao.ProviderDao;
import com.bdqn.entity.Provider;
import com.bdqn.service.ProviderService;
import java.util.List;
/**
-
实现类
*/
public class ProviderServiceImpl implements ProviderService {
//Dao层的对象
private ProviderDao providerDao;
public ProviderDao getProviderDao() {
return providerDao;
}
public void setProviderDao(ProviderDao providerDao) {
this.providerDao = providerDao;
}public List getList() {
return providerDao.getList();
}
}
9.配置SQL映射语句文件
<?xml version="1.0" encoding="UTF-8" ?><select id="getList" resultType="Provider">
select * from smbms_provider;
</select>