mybatis配置文件

conf.xml  文件

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
   <setting name="cacheEnabled" value="true"/>
</settings>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <!-- 配置数据库连接信息 -->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://localhost:3306/qiye" />
                <property name="username" value="root" />
                <property name="password" value="mysql" />
            </dataSource>
        </environment>
    </environments>
    <!-- 注册表映射文件 -->
    <mappers>
       <mapper class="it.com.db.IUserMapper"/>
    </mappers>

</configuration>

//获取mybatis的 session变量

package it.com.db;
import java.io.IOException;
import java.io.Reader;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;


public class SF {
public static SqlSession getSession(){
SqlSession session=null;
String resource="conf.xml";
Reader is=null;
try {
is = Resources.getResourceAsReader(resource);
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);
session = sessionFactory.openSession();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return session;
}
 
public static void closeSession(SqlSession session){
if(session!=null){
session.close();
}
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
SF.getSession();
}


}

//创建一个IUserMapper接口   

package it.com.db;
import java.util.Map;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import com.sun.xml.internal.bind.v2.schemagen.xmlschema.List;




public interface IUserMapper {

@Insert("insert into msglist(msgTitle,msgcontent,userName,creatTime,upperId) values(#{msgTitle},#{msgcontent},#{userName},now(),#{upperId})")
public int insertMsg(@Param("msgTitle")String msgTitle,@Param("msgcontent")String msgcontent,@Param("userName")String userName,@Param("upperId")int upperId); 
@Select("select upperId from  msglist where userName=#{userName}")
public Map getUpperId(@Param("userName")String userName);
@Select("select * from msglist where upperId=#{upperId}")
public List getList(@Param("upperId")int upperId);


}

//调用接口文件中的方法  

package it.com.dao;


import it.com.db.IUserMapper;
import it.com.db.SF;


import org.apache.ibatis.session.SqlSession;


import com.sun.xml.internal.bind.v2.schemagen.xmlschema.List;


public class ContentDao {
    //插入新的回复
//String msgTitle,String msgcontent,String userName,int upperId
//无返回值
public void insertMsg(String msgTitle,String msgcontent,String userName,int upperId){
SqlSession session=SF.getSession();
IUserMapper ii=session.getMapper(IUserMapper.class);
ii.insertMsg( msgTitle, msgcontent, userName, upperId);
session.commit();
}

    //输出帖子的回复
//int upperId
//返回帖子的list
public List getList(int upperId){
SqlSession session=SF.getSession();
IUserMapper iU=session.getMapper(IUserMapper.class);
List list= iU.getList(upperId);
System.out.println("777777");
return list;
}





public static void main(String[] args) {
ContentDao cc=new ContentDao();
cc.getList(1);
      
}


}