一、项目设计
1. 模块设计
管理员模块业务流程
仓库的管理员可以通过帐号和密码验证之后进行登录,登录到系统之后主要的功能是对商品与用户的信息进行管理
客户模块业务流程
2. 实现效果
二、部分源码
部分代码示例:
工厂类配置文件主要内容
<Configuration>
<settings>
<setting name="cacheEnabled" value="true" />
</settings>
<typeAliases>
<package name="com.briup.bean"/>
</typeAliases>
<environments default="develepment">
<environment id="develepment">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@localhost:1521:xe"/>
<property name="username" value="briup"/>
<property name="password" value="briup"/>
</dataSource>
</environment>
</environments>
</configuration>
Mapper类配置文件主要代码
<mapper namespace="com.briup.bean.AdminMapper">
<select id="selectAdminByName"
parameterType="String" resultType="Admin">
select * from admin
where account=#{account}
</select>
<select id="selectAdminById"
parameterType="int" resultType="Admin">
select * from admin
where id=#{id}
</select>
<insert id="insertAdmin" parameterType="Admin">
<selectKey keyColumn="id" keyProperty="id" order="BEFORE" resultType="int">
select admin_seq.nextval from dual
</selectKey>
insert into admin values(#{id},#{account},#{password},#{name},#{sex},#{age},#{phone},#{email},#{address})
</insert>
<update id="updateAdmin" parameterType="Admin">
update Admin set account=#{account},password=#{password}, name=#{name}, sex=#{sex}, age=#{age}, phone=#{phone}, address=#{address}, email=#{email}
where account=#{account}
</update>
</mapper>