對于Date類型的數據,需要輸入生日存入相應數據庫中
private Date birthday;// 生日
package com.pdsu.mybatis.pojo;import java.io.Serializable;
import java.util.Date;public class User implements Serializable {/*** */private static final long serialVersionUID = 1L;private Integer id;private String username;// 用戶姓名private String sex;// 性別private Date birthday;// 生日private String address;// 地址public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}public String getAddress() {return address;}public void setAddress(String address) {this.address = address;}@Overridepublic String toString() {return "User [id=" + id + ", username=" + username + ", sex=" + sex+ ", birthday=" + birthday + ", address=" + address + "]";}
}
package com.pdsu.mybatis.junit;import java.io.InputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;import com.pdsu.mybatis.pojo.User;public class MybatisFirstTest {//添加用戶@Testpublic void testInsertUser() throws Exception {//加載核心配置文件,加載要使用IO流進行讀取String resource = "sqlMapConfig.xml";InputStream in = Resources.getResourceAsStream(resource);//創建SqlSessionFactorySqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in);//SqlSessionFactoryBuilder這是一個實現類需要new一下//創建SQLSessionSqlSession sqlSession = sqlSessionFactory.openSession();//執行sql語句User user = new User();user.setUsername("諺語");Date date=new Date();//需要new一個Date對象String string ="1999-05-22";//輸入想要添加的生日SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); //設置日期格式 yyyy-MM-dd-HH-mm-ss這個是完整的date = dateFormat.parse(string);//將字符串轉換成date類型數據user.setBirthday(date);//存入到user中即可user.setAddress("美國紐約");user.setSex("男");int i = sqlSession.insert("user.insertUser",user);sqlSession.commit();//需要提交事務System.out.println(user.getId());}
}