jsp整合mybatis案例

View视图层：注册页面

账号：
密码：
确认密码：
爱好：读书旅游逛街
"

显示所有页面的jsp代码

账户
密码
爱好
操作
${m["USERNAME"] }
${m["PWD"] }
${m["AIHAO"] }
增加
删除
删除

web.xml配置文件

zhuce.jspregServletcom.controller.RegServletallServletcom.controller.AllServletDelServletcom.controller.DelServletregServlet/regServletallServlet/allServletDelServlet/delServlet

mybatis的配置文件

返回SqlSession对象的公共类

package com.util;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;
//公共类，读取config.xml文件，用来和数据库建立联系
//The AdapterNet wrong:修改config.xml为ip地址
public class SSFU {public static SqlSession getSqlSession(){Reader reader=null;SqlSessionFactory factory=null;SqlSession session=null;try {reader = Resources.getResourceAsReader("config.xml");factory=new SqlSessionFactoryBuilder().build(reader);} catch (IOException e) {e.printStackTrace();}finally{try {if(reader!=null){reader.close();}} catch (IOException e) {e.printStackTrace();}}	return factory.openSession();}
}	

model层

实体类：

package com.model;
//用户信息实体类
public class Userinfo {private String username;private String pwd;private String aihao;public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPwd() {return pwd;}public void setPwd(String pwd) {this.pwd = pwd;}public String getAihao() {return aihao;}public void setAihao(String aihao) {this.aihao = aihao;}}

接口业务定义：

package com.biz;import java.util.List;
import java.util.Map;
import com.model.Userinfo;//接口，定义了4个抽象方法，增删改查,对userinfo表
public interface UserinfoMapper {public int insertUserinfo(Userinfo u);public int updateUserinfo(Userinfo u);public int deleteUserinfo(Userinfo u);public List

接口对应的映射文件

insert into userinfo values(#{username},#{pwd},#{aihao})update userinfo set pwd=#{pwd} where username=#{username}delete from userinfo where username=#{username}select * from userinfo

控制层，控制器

注册Servlet

package com.controller;import java.io.IOException;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;import org.apache.ibatis.session.SqlSession;import com.biz.UserinfoMapper;
import com.model.Userinfo;
import com.util.SSFU;
//作用是一个控制器，一手托view，一手托model
public class RegServlet extends HttpServlet {@Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp)throws ServletException, IOException {//0.解决乱码req.setCharacterEncoding("utf-8");//1.接受从zhuce页面传过来的数据;String username=req.getParameter("username");//名字不一样，会报NUllpointerExceptionString pwd=req.getParameter("pwd");String[]hobbys=req.getParameterValues("hobby");//1.2将爱好数组转化为字符串 ;String aihao="";for(int i=0;i

package com.controller;import java.io.IOException;
import java.util.List;
import java.util.Map;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;import org.apache.ibatis.session.SqlSession;import com.biz.UserinfoMapper;
import com.util.SSFU;
//查询所有用户信息的控制器;
public class AllServlet extends HttpServlet {@Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp)throws ServletException, IOException {//从数据库查询所有信息;SqlSession session =SSFU.getSqlSession();UserinfoMapper um = session.getMapper(UserinfoMapper.class);List

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！