期末考试题解3

表三Massage

点击查看代码

CREATE TABLE Messages (
  ID INT AUTO_INCREMENT PRIMARY KEY,
  category INT ,
  SenderName VARCHAR(255) ,
  SenderNo VARCHAR(255) ,
  receiverName VARCHAR(255) ,
  receiverNo VARCHAR(255) ,
  content VARCHAR(255),
  State VARCHAR(2)
);

Massage的pojo

点击查看代码

package com.QixunQiu.pojo;

public class Massage {
    int ID ;
    int category ;
    String SenderName ;
    String SenderNo;
    String receiverName ;
    String receiverNo ;
    String content ;
    String State;

    @Override
    public String toString() {
        return "Massage{" +
                "ID=" + ID +
                ", category=" + category +
                ", SenderName='" + SenderName + '\'' +
                ", SenderNo='" + SenderNo + '\'' +
                ", receiverName='" + receiverName + '\'' +
                ", receiverNo='" + receiverNo + '\'' +
                ", content='" + content + '\'' +
                ", State='" + State + '\'' +
                '}';
    }

    public int getID() {
        return ID;
    }

    public void setID(int ID) {
        this.ID = ID;
    }

    public int getCategory() {
        return category;
    }

    public void setCategory(int category) {
        this.category = category;
    }

    public String getSenderName() {
        return SenderName;
    }

    public void setSenderName(String senderName) {
        SenderName = senderName;
    }

    public String getSenderNo() {
        return SenderNo;
    }

    public void setSenderNo(String senderNo) {
        SenderNo = senderNo;
    }

    public String getReceiverName() {
        return receiverName;
    }

    public void setReceiverName(String receiverName) {
        this.receiverName = receiverName;
    }

    public String getReceiverNo() {
        return receiverNo;
    }

    public void setReceiverNo(String receiverNo) {
        this.receiverNo = receiverNo;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public String getState() {
        return State;
    }

    public void setState(String state) {
        State = state;
    }
}

MassageMapper

点击查看代码

package com.QixunQiu.mapper;

import com.QixunQiu.pojo.Massage;

public interface MassageMapper {
    void addMassage(Massage massage);
}

MassageMapper.xml

点击查看代码

<?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="com.QixunQiu.mapper.MassageMapper">

    <insert id="addMassage">
        INSERT INTO messages (category, SenderName, SenderNo, receiverName,
                              receiverNo, content, State)
    VALUES (#{category}, #{SenderName}, #{SenderNo}, #{receiverName},#{receiverNo},
            #{content},#{State})
    </insert>
</mapper>

MassageService

点击查看代码

package com.QixunQiu.service;

import com.QixunQiu.mapper.MassageMapper;
import com.QixunQiu.pojo.Massage;
import com.QixunQiu.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

public class MassageService {
    SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getSqlSessionFactory();
    public void add(Massage massage) {
        SqlSession sqlSession = sqlSessionFactory.openSession();
        MassageMapper massageMapper = sqlSession.getMapper(MassageMapper.class);
        massageMapper.addMassage(massage);
        sqlSession.commit();
        sqlSession.close();

    }
}