maven+springMvc+velocity(三)

下面就该编写实体类文件

实体类文件都是在commonjava项目下面的,要有一定的规范

teacher.java

/**
 * @author qizj
 * @email  qizhenj@gmail.com
 * @create_time  2013-3-13 下午03:21:07
 */
package com.myBussiness.domain.user;

import com.ast.ast1949.domain.DomainSupport;

public class teacher extends DomainSupport {
    /**
     * 
     */

    private static final long serialVersionUID = -7630297119097300004L;
    /**
     * 
     */
    public teacher() {
        // TODO Auto-generated constructor stub
    }

    public teacher(String teacherName, String teacherSex, int teacherAge,
            String teacherAdress) {
        super();
        this.teacherName = teacherName;
        this.teacherSex = teacherSex;
        this.teacherAge = teacherAge;
        this.teacherAdress = teacherAdress;
    }

    // 教师编号
    private int teacherId;
    // 教师姓名
    private String teacherName;
    // 教师性别
    private String teacherSex;
    // 教师年龄
    private int teacherAge;
    // 家庭住址
    private String teacherAdress;

    public int getTeacherId() {
        return teacherId;
    }

    public void setTeacherId(int teacherId) {
        this.teacherId = teacherId;
    }

    public String getTeacherName() {
        return teacherName;
    }

    public void setTeacherName(String teacherName) {
        this.teacherName = teacherName;
    }

    public String getTeacherSex() {
        return teacherSex;
    }

    public void setTeacherSex(String teacherSex) {
        this.teacherSex = teacherSex;
    }

    public int getTeacherAge() {
        return teacherAge;
    }

    public void setTeacherAge(int teacherAge) {
        this.teacherAge = teacherAge;
    }

    public String getTeacherAdress() {
        return teacherAdress;
    }

    public void setTeacherAdress(String teacherAdress) {
        this.teacherAdress = teacherAdress;
    }

    /*
     * public static void main(String[] args) { teacher newTeacher = new
     * teacher("leiteng", "male", 23, "China") ; String nameString =
     * newTeacher.getTeacherName(); System.out.println(nameString);
     * 
     * }
     */
}

然后就是编写对应teacher.java实体累的ibatis xml映射文件

其中在persistjava项目下面建立

teacher_operation.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMap
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="teacherOperation">
    <typeAlias alias="teacherOperationDO" type="com.myBussiness.domain.user.teacher" />
    <resultMap class="teacherOperationDO" id="resultTeacherOperation">
        <result property="teacherId" column="teacherId" />
        <result property="teacherName" column="teacherName" />
        <result property="teacherSex" column="teacherSex" />
        <result property="teacherAdress" column="teacherAdress" />
        <result property="teacherAge" column="teacherAge" />
    </resultMap>
    <!-- 添加教师信息 -->
    <insert id="insertTeacher" parameterClass="teacherOperationDO">
        INSERT INTO teacher
        (teacherName,
        teacherSex,
        teacherAdress,
        teacherAge)
        VALUES (#teacherName#,
        #teacherSex#,
        #teacherAdress#,
        #teacherAge#)
        <selectKey resultClass="java.lang.Integer" keyProperty="id">
            SELECT LAST_INSERT_ID()
        </selectKey>
    </insert>
<!--查询所有教师信息,不根据id,结果显示为一个list<teacher> -->
    <select id="queryTeacher" resultMap="resultTeacherOperation">
        SELECT teacherId,
        teacherName,
        teacherSex,
        teacherAdress,
        teacherAge
        from teacher
    </select>
    <!-- 根据id查询教师的具体信息 -->
    <select id="queryDetail" parameterClass="java.lang.Integer" resultMap="resultTeacherOperation">
        SELECT teacherId,
        teacherName,
        teacherSex,
        teacherAdress,
        teacherAge
        FROM teacher WHERE teacherId=#value#
    </select>
    <!-- 根据id号更新教师的信息-->
    <update id="updateTeacher" parameterClass="teacherOperationDO"  >
        UPDATE teacher
        SET teacherName=#teacherName#,
            teacherSex=#teacherSex#,
            teacherAdress=#teacherAdress#,
            teacherAge=#teacherAge#
        WHERE teacherId=#teacherId#
    </update>
<!-- 根据id号删除教师的信息 -->
    <delete id="deleteTeacherById" parameterClass="java.lang.Integer">
        DELETE
        FROM TEACHER
        WHERE teacherId = #value#
    </delete>
</sqlMap>

然后把teacher.java和teacher.operation对应的关系维护在

SqlMapConfig.xml文件中

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMapConfig
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<!-- 每个模型实体都有会配置一个映射到ibatis的xml映射文件,这里将每一个映射文件统一注册-->
<sqlMapConfig>
    <properties resource="persist.properties" />
    <settings useStatementNamespaces="true" />

    <!-- common -->
    <sqlMap resource="${sqlMap.root}/common.xml" />
    <!-- log -->
    <sqlMap resource="${sqlMap.root}/log/log_operation.xml" />
    <sqlMap resource="com/myBussiness/ibatismaps/user/teacher_operation.xml" />
    
</sqlMapConfig>

这样所有的配置,项目框架的搭建就到此结束了,接下来就是service和dao曾实现,和controller的具体业务逻辑代码的实现了.