代码:
/Sparrow/src/com/sparrow/dao/ResourceDao.java
package com.sparrow.test;
import com.sparrow.dao.ResourceDao;
import com.sparrow.daoImpl.ResourceDaoImpl;
import com.sparrow.vo.Resource;
public class ResourceTest1 {
static ResourceDao rd =new ResourceDaoImpl();
//增加方法
public static void add(){
Resource rd = new Resource();
rd.setResourceName("mybatis");
rd.setResourceDescrtption("mybatis");
rd.setResourceType("视频");
((ResourceDao) rd).addResource(rd);
}
//修改方法
public static void update() {
Resource rd = new Resource();
rd.setResourceNo(2);
rd.setResourceName("mybatis1");
rd.setResourceDescrtption("mybatis2");
((ResourceDao) rd).updateResource(rd);
}
//删除方法
public static void delete() {
rd.deleteResource(1);
}
//全查询
public static void selectAll(){
rd.selectAll();
}
//指定方法
public static void selectById(){
rd.selectByResourceNo(1);
}
public static void main(String[] args) {
// TODO Auto-generated method stub
add();
delete();
update();
selectAll();
selectById();
}
}
/Sparrow/src/com/sparrow/daoImpl/ResourceDaoImpl.java
package com.sparrow.daoImpl;
import java.io.IOException;
import java.io.Reader;
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 com.sparrow.dao.ResourceDao;
import com.sparrow.vo.Resource;
public class ResourceDaoImpl implements ResourceDao {
//读取配置文件(连接数据库)
static SqlSessionFactory sf=null;
static{
try {
Reader reader=Resources.getResourceAsReader("mybatis.xml");
sf=new SqlSessionFactoryBuilder().build(reader);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//增加
@Override
public int addResource(Resource t) {
// TODO Auto-generated method stub
SqlSession ss =sf.openSession() ;
int i=ss.insert("Resource.add",t);
ss.commit();
ss.close();
return i;
}
//删除
@Override
public void deleteResource(int resourceNo) {
// TODO Auto-generated method stub
SqlSession ss =sf.openSession() ;
ss.delete("Resource.delete", resourceNo);
ss.commit();
ss.close();
}
//修改
@Override
public int updateResource(Resource t) {
// TODO Auto-generated method stub
SqlSession ss =sf.openSession() ;
int i=ss.update("Resource.update",t);
ss.commit();
ss.close();
return i;
}
//全查询
@Override
public List<Resource> selectAll() {
// TODO Auto-generated method stub
SqlSession ss =sf.openSession() ;
List<Resource> list = ss.selectList("Resource.selectAll");
for(Resource t:list) {
System.out.println(t.getResourceNo()+"--"+t.getResourceName()+"=="+t.getCommitTime()+"--"+
t.getResourceDescrtption()+"--"+t.getResourceType());
}
ss.close();
return list;
}
//资源编号查询
@Override
public List<Resource> selectByResourceNo(int resourceNo) {
// TODO Auto-generated method stub
SqlSession ss =sf.openSession() ;
List<Resource> list = ss.selectList("Resource.selectByResourceNo",resourceNo);
for(Resource t:list) {
System.out.println(t.getResourceNo()+"--"+t.getResourceName()+"=="+t.getCommitTime()+"--"+
t.getResourceDescrtption()+"--"+t.getResourceType());
}
ss.close();
return list;
}
}
/Sparrow/src/com/sparrow/test/ResourceTest1.java
package com.sparrow.test;
import com.sparrow.dao.ResourceDao;
import com.sparrow.daoImpl.ResourceDaoImpl;
import com.sparrow.vo.Resource;
public class ResourceTest1 {
static ResourceDao rd =new ResourceDaoImpl();
//增加方法
public static void add(){
Resource rd = new Resource();
rd.setResourceName("mybatis");
rd.setResourceDescrtption("mybatis");
rd.setResourceType("视频");
((ResourceDao) rd).addResource(rd);
}
//修改方法
public static void update() {
Resource rd = new Resource();
rd.setResourceNo(2);
rd.setResourceName("mybatis1");
rd.setResourceDescrtption("mybatis2");
((ResourceDao) rd).updateResource(rd);
}
//删除方法
public static void delete() {
rd.deleteResource(1);
}
//全查询
public static void selectAll(){
rd.selectAll();
}
//指定方法
public static void selectById(){
rd.selectByResourceNo(1);
}
public static void main(String[] args) {
// TODO Auto-generated method stub
// add();
// delete();
// update();
selectAll();
// selectById();
}
}