mybatis -- mybatis笔记1--搭配环境
创建一个java项目
项目名Mybatis1
导入jar包:mybatis-3.2.8.jar、mysql-connector-java-5.0.7-bin.jar
创建一个配置文件mybatis_config.xml
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="url" value="jdbc:mysql:///firefly"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/firefly/mybatis1/domain/userMapper.xml"/>
</mappers>
- 创建一个bean
package com.firefly.mybatis1.domain;
public class User {
private int id;
private String name;
private int age;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String toString() {
return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
}
}
创建一个与bean对应的xml文件
<select id="getUser" parameterType="int" resultType="com.firefly.mybatis1.domain.User">
select * from user where id=#{a}
</select>
</select>
- 创建 一个测试文件
package com.firefly.mybatis1.test;
import java.io.IOException;
import java.io.InputStream;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import com.firefly.mybatis1.domain.User;
public class Test {
public static void main(String[] args) throws IOException {
InputStream is = Test.class.getClassLoader().getResourceAsStream("mybatis_config.xml");
SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(is);
SqlSession session = sf.openSession();
String statement = "com.firefly.mybatis1.domain.userMapper.getUser";
Integer i = new Integer(1);
User user = (User) session.selectOne(statement, i);
System.out.println(user);
}
}
System.out.println(user);
}
}
