超市订单管理系统（mybatis）

一身傲气王 · 发布于 2023-4-20 10:54:55

超市订单管理系统（mybatis）

准备阶段——————数据库建立（基于mysql）

createtable smbms_role(
id bigint(20)notnullauto_increment,
roleCode varchar(15),
roleName varchar(15),
createdBy bigint(15),
creationDate datetime,
modifyBy bigint(20),
modifyDate datetime,constraint pk_role primarykey(id))ENGINE=InnoDBAUTO_INCREMENT=1DEFAULTCHARSET=utf8 ;createtable smbms_user(
id bigint(20)notnullauto_increment,
userCode varchar(15),
userName varchar(15),
userPassword varchar(15),
gender int(10),
birthday date,
phone varchar(15),
address varchar(40),
userRole bigint(20),
createdBy bigint(20),
creationDate datetime,
modifyBy bigint(20),
modifyDate datetime,constraint pk_user primarykey(id),constraint fk_role foreignkey(userRole)references smbms_role(id))ENGINE=InnoDBAUTO_INCREMENT=1DEFAULTCHARSET=utf8 ;createtable smbms_provider(
id bigint(20)notnullauto_increment,
proCode varchar(20),
proName varchar(20),
proDesc varchar(50),
proContact varchar(20),
proPhone varchar(20),
proAddress varchar(50),
proFax varchar(20),
createdBy bigint(20),
creationDate datetime,
modifyBy bigint(20),
modifyDate datetime,constraint pk_ primarykey(id))ENGINE=InnoDBAUTO_INCREMENT=1DEFAULTCHARSET=utf8 ;createtable smbms_bill(
id bigint(20)notnullauto_increment,
billCode varchar(20),
productName varchar(20),
productDesc varchar(50),
productUnit varchar(20),
productCount decimal(20,2),
totalPrice decimal(20,2),
isPayment int(10),
providerId bigint(20),
createdBy bigint(20),
creationDate datetime,
modifyBy bigint(20),
modifyDate datetime,constraint pk_bill primarykey(id),constraint fk_provider foreignkey(providerId)references smbms_provider(id))ENGINE=InnoDBAUTO_INCREMENT=1DEFAULTCHARSET=utf8 ;createtable smbms_address(
id bigint(20)notnullauto_increment,
contact varchar(15),
addressDesc varchar(50),
postCode varchar(15),
tel varchar(20),
createdBy bigint(20),
creationDate datetime,
modifyBy bigint(20),
modifyDate datetime,
userId bigint(20),constraint pk_address primarykey(id),constraint fk_user foreignkey(userId)references smbms_user(id))ENGINE=InnoDBAUTO_INCREMENT=1DEFAULTCHARSET=utf8 ;

复制代码

1.创建数据库过程中，呈现权限问题。
处置：使用root账号登录，为用户创建相应的数据库，授予用户相应的权限。
命令：create database name;
grant all privileges on dbname.* to test@localhost;
revoke 用于取消
flush privileges;
show grants for username;

复制代码

mybatis的入门记录

mybatis初步小结

什么是耐久化：数据的相关操作就是耐久化。
orm：对象和关系之间的映射（突然想到了对象型数据库）
jdbc：加载驱动—建立连接—执行sql的预编译—执行sql
mybatis：创建factory–生成sqlSession（即与数据库的连接）—执行sql
小规模实战

create table equipment(
id bigint(20) auto_increment primary key,
type varchar(20) not null,
price decimal(20,2),
productDate date
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ;
insert into equipment(type,price,productDate) values('cdma-1','650.78','2016-1-22');
insert into equipment(type,price,productDate) values('cdma-2','2356.23','2013-1-22');
insert into equipment(type,price,productDate) values('cdma-3','2200.76','2010-1-22');

复制代码

package equipment;
import java.sql.Date;
public class Equipment {
private Integer id;
private String type;
private Float price;
private Date productDate;
..........
..........
}

复制代码

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "=//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="equipment.EquipmentMapper">
<select id="count" resultType="int">
select count(1) as count from equipment
</select>
<select id="getEquipmentList" resultType="equipment.Equipment">
select * from equipment
</select>
</mapper>

复制代码

<?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>
<properties resource="database.properties"/>
<settings>
<setting name='logImpl' value='LOG4J'/>
</settings>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<!-- <typeAliases>
<package name = "smbms.dao">
</typeAliases> -->
<mappers>
<mapper resource="equipment/EquipmentMapper.xml"/>
</mappers>
</configuration>

复制代码

package smbms.utils;
import java.io.InputStream;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class MyBatisUtil {
private static SqlSessionFactory factory;
static {
try {
InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
factory = new SqlSessionFactoryBuilder().build(is);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
public static SqlSession createSqlSession() {
return factory.openSession();
}
public static void closeSqlSession(SqlSession sqlSession) {
if(sqlSession!=null)
sqlSession.close();
}
}

复制代码

package equipment;
import java.util.List;
public interface EquipmentMapper {
public List<Equipment> getEquipmentList();
}

复制代码