开始写这篇博客的前几个星期,我也是一个layman,虽然现在还是(hhh),学习了一段时间后就慢慢熟练起来。出于学习记录的目的,所以写下这篇博客记录下自己遇到的错误及方法,希望对有需要的人能有所帮助,好了废话不多说了。
首先把我自己的结构图放到下面,如果不太懂的朋友可能需要先去看Myatis的基本结构了。
其实利用Myatis对数据库进行操作,我的大概理解为如下图:
在明确需要在实体类中的主键及各属性关系后,编写接口方法:
BrandMappper文件代码如下:
package org.example.mapper;
import org.example.pojo.Brand;
import java.util.List;
import java.util.Map;
//返回对象集合用的是LIst
public interface BrandMapper {
public List<Brand> selectAll();
//通过brand对象选择查看数据数据
List<Brand> selectByCondition(Brand brand);
List<Brand> selectByConditionSingle(Brand brand);
//1.增加
int add(Brand brand);
//改数据
int update(Brand brand);
//单个记录删除
void deleteByiId(Brand brands);
//多记录删除
void deleteMultiple(int[] idArray);
}
以其中的add接口为例,方法返回的是最后影响的行数,所以为int类型,Brand为实现这个接口时需要传入的对象,即brand。brand对象会在实现方法赋值,当然也可以传入一个具体属性,或者利用Map,其大致和利用brand对象相似。你可以理解为sql语句中的where中需要一个具体特点,你当然可以传入一个具体条件,也可以传入一个一个特定的人,这个人拥有这些特定的条件,相比较与前者,对象显然更好。
此外这里可以使用MyatisX插件快速生成对应SQL映射结构,具体语句需要自己写。
下面是利用Mybatis对网页的登录逻辑设计:
网页代码:
<?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>
<!--起别名-->
<typeAliases>
<package name="com.cn.pojo"/>
</typeAliases>
<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/db1?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC"/>
<!-- <property name="url" value="jdbc:mysql:///db1?useSSL=false&useServerPrepStmts=true"/>-->
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<mappers>
<!--扫描mapper-->
<package name="com.cn.mapper"/>
</mappers>
</configuration>
通过上述页面跳转到loginServlet,利用loginServlet实现逻辑判断。
package com.cn.web;
import com.cn.mapper.UserMapper;
import com.cn.pojo.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 javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
@WebServlet("/loginServlet")
public class LoginServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//1.接受用户名
resp.setContentType("text/html;charset=utf-8");
String name=req.getParameter("username");
String password=req.getParameter("password");
//2.调用Mybatis完成查询
//2.1 获取sqlSessionfactory对象
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
//2.2 获取sqlSession对象
SqlSession sqlSession=sqlSessionFactory.openSession();
//2.3 获取Mapper
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
//2.4调用方法
User user = userMapper.select(name,password);
//释放资源
sqlSession.close();
//响应字符输出流
PrintWriter writer=resp.getWriter();
if(user != null)
{
writer.write("登录成功");
}else
{
writer.write("登录失败");
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
this.doGet(req,resp);
}
}
UserMapper.class:如下(通过注解完成sql语句的书写利用,也可以在对应的xml文件中书写)
package com.cn.mapper;
import com.cn.pojo.User;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
public interface UserMapper {
@Select("select * from db1.tb_user where username=#{username} and password=#{password}")
//返回一个对象
User select (@Param("username") String username, @Param("password") String password);
}
通过UserMapper userMapper = sqlSession.getMapper(UserMapper.class);得到Mapper对象后利用Mapper对象调用(User user = userMapper.select(name,password);)
实体类User代码:
package com.cn.pojo;
public class User {
private Integer id;
private String username;
private String password;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
最后运行tomcat,可以发现已经实现对数据库的访问,并且符合网页判断条件。
顺便写一下我的一些错误!避坑!!!
1、login.html中的from表单提交action得写全域名,LoginTest是项目名,loginServlet是Servlet注解名
2、mybatis-config.xml中的数据库连接信息得补全(
<property name="url" value="jdbc:mysql://localhost:3306/db1?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC"/>
),将我自己的Mybatis的配置文件放在这:
<?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>
<!--起别名-->
<typeAliases>
<package name="com.cn.pojo"/>
</typeAliases>
<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/db1?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC"/>
<!-- <property name="url" value="jdbc:mysql:///db1?useSSL=false&useServerPrepStmts=true"/>-->
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<mappers>
<!--扫描mapper-->
<package name="com.cn.mapper"/>
</mappers>
</configuration>
以及pom.xml文件
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>LoginTest</artifactId>
<packaging>war</packaging>
<version>1.0-SNAPSHOT</version>
<name>LoginTest Maven Webapp</name>
<url>http://maven.apache.org</url>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.6</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
</dependencies>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
<java.version>16</java.version>
<maven.compiler.source>16</maven.compiler.source>
<maven.compiler.target>16</maven.compiler.target>
</properties>
<build>
<finalName>LoginTest</finalName>
</build>
</project>