Mybaist

• • 一、项目创建
  • 二、编辑项目
  • 三、运行项目
  • 三、参考博客

在idea中创建一个新的Spring initializr项目；

点击next
2、输入项目名，并选择java8

点击next
3、选择Spring Web Spring， JDBC ，MyBatis framework， MySQL Driver

点击next；
四、输入项目名；

点击finish；

五、在mybatis.springboot中添加bean，controller，mapper，service文件夹并添加相应项目文件，如下图：
六、代码添加
Account代码如下：

package mybatis.springboot.bean;

public class Account {
    String id;
    String name;
    String age;


    public void setId(String id) {
        this.id = id;
    }

    public void setName(String name) {
        this.name = name;
    }

    public void setAge(String age) {
        this.age = age;
    }
    public String getAge() {
        return age;
    }

    public String getName() {
        return name;
    }

    public String getId() {
        return id;
    }

    @Override
    public String toString() {
        return "Account{" +
                "id='" + id + ''' +
                ", name='" + name + ''' +
                ", age='" + age + '''+
                '}';
    }


}

Databaselink（用于连接数据库）代码如下：

package mybatis.springboot.bean;
import java.sql.Connection;
import java.sql.DriverManager;
public class Databaselink {

        static public Connection getConn() {
            String serverName="com.mysql.jdbc.Driver";
            String dbURL="jdbc:mysql://localhost:3306/123";
            String userName="root";
            String userPwd="123456";
            try {
                Class.forName(serverName);
                Connection tmp = DriverManager.getConnection(dbURL, userName, userPwd);
                System.out.println("成功连接数据库");
                return tmp;
            }
            catch(Exception e) {
                System.out.println("连接数据库失败");
                System.out.println(e);
            }
            return null;
        }


}

AccountController代码如下：

package mybatis.springboot.controller;

import mybatis.springboot.bean.Account;
import  mybatis.springboot.bean.Databaselink;
import mybatis.springboot.service.AccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

public abstract class AccountController {
    private AccountService accountService;

    @ResponseBody
    @RequestMapping(value = "/get",method = RequestMethod.GET)
    public List get(){
        Connection conn= Databaselink.getConn();
        if(conn!=null){
            String sql="select name from account";
            try {
                PreparedStatement pst = conn.prepareStatement(sql);
                ResultSet results = pst.executeQuery();
                while (results.next()){
                    System.out.println(results.getString("name"));
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return accountService.getAllAccounts();
    }

}

AccountMapper代码如下：

package mybatis.springboot.mapper;

import mybatis.springboot.bean.Account;

import  mybatis.springboot.bean.Databaselink;

import java.util.List;

public interface AccountMapper {

     List getAllAccounts();
}

AccountService代码如下：

package mybatis.springboot.service;

import mybatis.springboot.bean.Account;
import mybatis.springboot.mapper.AccountMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
public class AccountService {
    AccountMapper accountMapper;
    public List getAllAccounts(){
        return accountMapper.getAllAccounts();
}
}

在progect>src->main->resources目录下的application.properties文件中添加以下代码

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/123?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
mybatis.typeAliasesPackage=com.example.mybatis.bean
mybatis.mapperLocations=classpath:mapper/*.xml
server.port=8080

在resources中新建mapper文件夹并添加AccountMapper.xml文件

.xml

默认文件为通用；

https://blog.csdn.net/vcj1009784814/article/details/106391982
https://blog.csdn.net/u012932876/article/details/117713982