本文共 5076 字,大约阅读时间需要 16 分钟。
package pers.zhang.po;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; } @Override public String toString() { return "User [id=" + id + ", username=" + username + ", sex=" + sex + ", birthday=" + birthday + ", address=" + address + "]"; }}
log4j.properties:
# Global logging configurationlog4j.rootLogger=ERROR,stdout# MyBatis logging configuration...log4j.logger.pers.zhang=DEBUG# Console output...log4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
jdbc.properties:
jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8jdbc.username=rootjdbc.password=123456
sqlMapCongfig.xml:
select LAST_INSERT_ID() insert into user (username,birthday,address,sex) values (#{username},#{birthday},#{address},#{sex})update user set username = #{username},sex = #{sex},birthday = #{birthday},address = #{address} where id = #{id} delete from user where id = #{vvvvv}
@Testpublic void testMybatis() throws Exception { //加载核心配置文件 String resource = "sqlMapConfig.xml"; InputStream in = Resources.getResourceAsStream(resource); //创建SqlSessionFactory SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); //创建SqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); //执行Sql语句 User user = sqlSession.selectOne("findUserById", 1); System.out.println(user);}
控制台打印:
User [id=1, username=王五, sex=0, birthday=Fri Oct 25 00:00:00 CST 2019, address=北京]
@Testpublic void testfindUserByUsername() throws Exception { //加载核心配置文件 String resource = "sqlMapConfig.xml"; InputStream in = Resources.getResourceAsStream(resource); //创建SqlSessionFactory SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); //创建SqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); //执行Sql语句 Listusers = sqlSession.selectList("findUserByUsername", "五"); for (User user2 : users) { System.out.println(user2); }}
控制台打印:
User [id=1, username=王五, sex=0, birthday=Fri Oct 25 00:00:00 CST 2019, address=北京]User [id=5, username=五菱宏光, sex=null, birthday=null, address=null]
@Testpublic void testInsertUser() throws Exception { //加载核心配置文件 String resource = "sqlMapConfig.xml"; InputStream in = Resources.getResourceAsStream(resource); //创建SqlSessionFactory SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); //创建SqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); //执行Sql语句 User user = new User(); user.setUsername("李雷"); user.setBirthday(new Date()); user.setAddress("北京"); user.setSex("男"); int i = sqlSession.insert("insertUser", user); sqlSession.commit(); System.out.println(user.getId()); }
@Testpublic void testUpdateUserById() throws Exception { //加载核心配置文件 String resource = "sqlMapConfig.xml"; InputStream in = Resources.getResourceAsStream(resource); //创建SqlSessionFactory SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); //创建SqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); //执行Sql语句 User user = new User(); user.setId(1); user.setUsername("修改后的王五"); user.setBirthday(new Date()); user.setAddress("北京"); user.setSex("0"); int i = sqlSession.update("test.updateUserById", user); sqlSession.commit();}
@Testpublic void testDelete() throws Exception { //加载核心配置文件 String resource = "sqlMapConfig.xml"; InputStream in = Resources.getResourceAsStream(resource); //创建SqlSessionFactory SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); //创建SqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); sqlSession.delete("test.deleteUserById", 1); sqlSession.commit();}
转载地址:http://fosqb.baihongyu.com/