67,549
社区成员




package com.model;
public class userModel {
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
private String name;
private String password;
public String toString(){
return "name:"+name+",password="+password;
}
}
package com.impl;
import java.util.Map;
public interface userOperation {
public int user_insert(Map map);
}
package com.serv;
import com.util.userUtil;
public class test {
static userUtil userUtil=new userUtil();
public static void main(String[] args) {
// TODO Auto-generated method stub
userUtil.user_insert("add", "dbbb");
}
}
package com.util;
import java.io.IOException;
import java.io.Reader;
import java.util.HashMap;
import java.util.Map;
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.impl.userOperation;
public class userUtil {
private static SqlSessionFactory sqlSessionFactory;
private static Reader reader;
static{
try {
reader=Resources.getResourceAsReader("com/conf/dbconf.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void user_insert(String name,String password) {
SqlSession sqlSession=sqlSessionFactory.openSession();
int query_msg=0;
Map map=new HashMap();
map.put("name", name);
map.put("password", password);
try {
userOperation userOperation=sqlSession.getMapper(userOperation.class);
query_msg=userOperation.user_insert(map);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
sqlSession.commit();
sqlSession.close();
}
System.out.println("user_insert:"+query_msg);
}
}
<?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>
<properties resource="com/conf/config.properties"></properties>
<typeAliases>
<typeAlias alias="userModel" type="com/model/userModel" />
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${name}" />
<property name="password" value="${password}" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/conf/userdb.xml" />
</mappers>
</configuration>
driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\://localhost\:3306/mybatis_new_test
name=root
password=root
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.impl.userOperation">
<insert id="user_insert" parameterType="Map">
insert into user(name,password) values(#{name},#{password})
</insert>
</mapper>