User类
public class User { private int id; private String username; private String password; public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public int getId() { return id; } public void setId(int id) { this.id = id; } @Override public String toString() { return "User{" + "id=" + id + ", username='" + username + ''' + ", password='" + password + ''' + '}'; }
UserMapper.xml
select * from user insert into user values(#{id},#{username},#{password}) update user set username=#{username},password=#{password} where id=#{id} delete from user where id=#{id}
sqlMapConfig.xml
Test类
import com.yby.domain.User; 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 java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.util.List; public class MyBatiesTest { @Test public void test1() throws IOException { InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml"); SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream); SqlSession sqlSession = sqlSessionFactory.openSession(); //查询所有 *** 作 //ListusrList = sqlSession.selectList("userMapper.findAll"); //System.out.println(usrList); //插入 *** 作 //模拟User对象 //User user = new User(); //user.setUsername("lyh"); //user.setPassword("0719"); //sqlSession.insert("userMapper.save",user); //sqlSession.commit();//提交事务(对数据库修改的时候) //修改 *** 作 //模拟User对象 //User user = new User(); //user.setId(6); //user.setUsername("ypl"); //user.setPassword("4567"); //sqlSession.update("userMapper.update",user); //sqlSession.commit(); //删除 *** 作 //sqlSession.delete("userMapper.delete",6); //sqlSession.commit(); //释放资源 sqlSession.close(); }
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)