自学springboot搭建和查询

最新推荐文章于 2023-06-08 21:59:47 发布

qq_35704443

最新推荐文章于 2023-06-08 21:59:47 发布

阅读量114

点赞数 1

文章标签： java

本文链接：https://blog.csdn.net/qq_35704443/article/details/118361233

版权

SpringBoot简单的查询

1.idea File→New→Project
在这里插入图片描述
2.1可以选择点击Spring lnitializr直接点击Default
在这里生成文件，下载本地。（接3）

2.2可以选择点击Spring lnitializr点击Next
依据自己实际需要进行生成

在这里插入图片描述
3.生成之后

4.1 pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.5.2</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.example</groupId>
	<artifactId>demo</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>demo</name>
	<description>Demo project for Spring Boot</description>
	<properties>
		<java.version>1.8</java.version>
	</properties>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>8.0.25</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.2.0</version>
		</dependency>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<scope>test</scope>
		</dependency>

		<dependency>
			<groupId>org.apache.tomcat.embed</groupId>
			<artifactId>tomcat-embed-jasper</artifactId>
			<scope>compile</scope>
		</dependency>
	</dependencies>


	<build>
		<resources>

			<!--将Java代码下的xml编译到class下面去-->
			<resource>
				<directory>src/main/java</directory>
				<includes>
					<include>**/*.xml</include>
				</includes>
			</resource>

			<resource>
				<directory>src/main/resources</directory>
				<includes>
					<include>**/*.*</include>
				</includes>
			</resource>

			<resource>
				<directory>src/main/webapp</directory>
				<targetPath>META-INF/resources</targetPath>
				<includes>
					<include>**/*.*</include>
				</includes>
			</resource>

		</resources>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>

4.2 将application.properties改名为application.yml

spring:
  datasource:
    url: jdbc:mysql://localhost/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
    username: root
    password: admin
    driver-class-name: com.mysql.cj.jdbc.Driver
  jpa:
    show-sql: true


server:
#  context-path: /sell
  port: 8080

mybatis:
  type-aliases-package: com.example.demo.mapper
  mapper-locations: classpath*:com/example/demo/mapper/*Mapper.xml

在这里插入图片描述
4.3建一张表例如

测试数据若干，例如

4.4 补全这些文件夹

4.5 先创建一个实体类 Users

package com.example.demo.entity;

public class Users {
    private String user_id;
    private String user_name;
    private String user_pass;
    private int permission;

    public String getUser_id() {
        return user_id;
    }

    public void setUser_id(String user_id) {
        this.user_id = user_id;
    }

    public String getUser_name() {
        return user_name;
    }

    public void setUser_name(String user_name) {
        this.user_name = user_name;
    }

    public String getUser_pass() {
        return user_pass;
    }

    public void setUser_pass(String user_pass) {
        this.user_pass = user_pass;
    }

    public int getPermission() {
        return permission;
    }

    public void setPermission(int permission) {
        this.permission = permission;
    }

    @Override
    public String toString() {
        return "Users{" +
                "user_id='" + user_id + '\'' +
                ", user_name='" + user_name + '\'' +
                ", user_pass='" + user_pass + '\'' +
                ", permission=" + permission +
                '}';
    }
}

4.6 创建UsersMapper

package com.example.demo.mapper;

import com.example.demo.entity.Users;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface UsersMapper {
    List<Users> getUserById();
}

4.7 创建UsersService

package com.example.demo.service;

import com.example.demo.entity.Users;

import java.util.List;

public interface UsersService {

    List<Users> getUserById();

}

4.8 创建UesrServicelmpl

package com.example.demo.servicelmpl;


import com.example.demo.entity.Users;
import com.example.demo.mapper.UsersMapper;
import com.example.demo.service.UsersService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UesrServicelmpl implements UsersService {
    @Autowired
    protected UsersMapper usersMapper;

    @Override
    public List<Users> getUserById(){
        return usersMapper.getUserById();
    }
}

4.9 创建UsersController

package com.example.demo.controller;

import com.example.demo.entity.Users;
import com.example.demo.service.UsersService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

@RestController
@RequestMapping(value = "/uesrs")
public class UsersController {

    @Autowired
    private UsersService usersServic;

    @RequestMapping(value = "/login")
    public void login(HttpServletRequest request, HttpServletResponse response) throws SQLException, IOException {
        List<Users> list=usersServic.getUserById();
        System.out.println(list.toString());
    }
}

4.10 创建UsersMapper.xml

<?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.example.demo.mapper.UsersMapper">
    <resultMap id="userList" type="com.example.demo.entity.Users">
        <id column="user_id" property="user_id" jdbcType="VARCHAR"/>
        <result column="user_name" property="user_name" jdbcType="VARCHAR"/>
        <result column="user_pass" property="user_pass" jdbcType="VARCHAR"/>
        <result column="permission" property="permission" jdbcType="INTEGER"/>
    </resultMap>

    <select id="getUserById" parameterType="java.lang.String" resultMap="userList">
        select *from users
    </select>
</mapper>

注意：位置要正确
在这里插入图片描述

4.11 启动类DemoApplication

package com.example.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication(scanBasePackages = "com.example.demo")
@MapperScan(basePackages = "com.example.demo.mapper")
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }

}

4.12 测试类 DemoApplicationTests

package com.example.demo;

import com.example.demo.domain.Users;
import com.example.demo.mapper.UsersMapper;
import com.example.demo.service.UsersService;
//import org.junit.jupiter.api.Test;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@SpringBootTest
@EnableConfigurationProperties
@Transactional
@RunWith(SpringRunner.class)
public //@SpringBootTest(classes = DemoApplication.class)
class DemoApplicationTests {

	@Autowired
	private UsersMapper usersMapper;
	@Autowired
	@Test
	public void contextLoads() {
		System.out.println("123");
		List<Users> b=usersMapper.getUserById();
		System.out.println(b.toString());
	}

}

5.1 运行测试类
在这里插入图片描述
5.2 在浏览器输入http://localhost:8080/uesrs/login

在这里插入图片描述
代码链接: https://pan.baidu.com/s/1KezhRrjsyoa1VagF51_LyQ
提取码: bniu

qq_35704443

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
自学springboot搭建和查询

SpringBoot简单的查询1.idea File→New→Project2.1可以选择点击Spring lnitializr直接点击Default在这里生成文件，下载本地。（接3）2.2可以选择点击Spring lnitializr点击Next依据自己实际需要进行生成3.生成之后4.1 pom.xml<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/PO
复制链接

扫一扫