small_demo

数据库设计

DROP TABLE IF EXISTS user;
CREATE TABLE user (
id bigint(20) NOT NULL AUTO_INCREMENT,
username varchar(50) NOT NULL COMMENT '用户名',
password varchar(32) NOT NULL COMMENT '密码，加密存储',
phone varchar(20) DEFAULT NULL COMMENT '注册手机号',
email varchar(50) DEFAULT NULL COMMENT '注册邮箱',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

实体类

public class User implements Serializable {

private Long id;
private String username;
private String password;
private String phone;
private String email;

public User() {
super();
}

public User(Long id, String username, String password, String phone, String email) {
super();
this.id = id;
this.username = username;
this.password = password;
this.phone = phone;
this.email = email;
}

public Long getId() {
return id;
}

public void setId(Long id) {
this.id = id;
}

public String getusername() {
return username;
}

public void setusername(String username) {
this.username = username;
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password;
}

public String getPhone() {
return phone;
}

public void setPhone(String phone) {
this.phone = phone;
}

public String getEmail() {
return email;
}

public void setEmail(String email) {
this.email = email;
}

@Override
public String toString() {
return "User [id=" + id + ", username=" + username + ", password=" + password + ", phone=" + phone + ", email=" + email
+ "]";
}

}

UserMapper接口

public interface UserMapper {

public User selectUserById(Long id);

}

mybatis-config.xml

db.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/support-mybatis?useUnicode=true&characterEncoding=utf8&autoReconnect=true
jdbc.username=root
jdbc.password=******

lo4j.properties

log4j.rootLogger=DEBUG,A1
log4j.logger.com.atguigu = DEBUG
log4j.logger.org.mybatis = DEBUG

log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss,SSS} [%t] [%c]-[%p] %m%n

UserMapper.xml

select * from User where id = #{id}

测试类

public class UserMapperTest {
SqlSessionFactory sqlSessionFactory;
SqlSession sqlSession;
UserMapper userMapper;

@Before
public void setUp() throws Exception {
InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
sqlSession = sqlSessionFactory.openSession(true);
userMapper = sqlSession.getMapper(UserMapper.class);
}

@Test
public void test() {
User user = userMapper.selectUserById(2L);
System.out.println(user);
}

}