码农的田园

@Datapublic class Menu { private Integer id; private String name; private String code; private String url; private String grade; private Integer parentID; private List&lt...

create table t_company( id NUMBER(12) not null, name VARCHAR2(128), code VARCHAR2(32), address VARCHAR2(256), telephone VARCHAR2(18))create table t_employee( id ...

<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> &...

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

package com.example.mybatis.config;import com.alibaba.druid.pool.DruidDataSource;import com.alibaba.druid.support.http.StatViewServlet;import com.alibaba.druid.support.http.WebStatFilter;impor...

网上拷贝别人使用MySQL的代码，修改不彻底，报错如题目，折腾了好久，在这个博客获得答案在配置application.yml时，对druid的配置会有这样一个字段validationQuery。validationQuery是用来验证数据库连接的查询语句，这个查询语句必须是至少返回一条数据的SELECT语句。每种数据库都有各自的验证语句。Oracle：select 1 fr...

<?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"><confi...

server: port: 8080spring: datasource: url: jdbc:oracle:thin:@localhost:1521:orcl driver-class-name: oracle.jdbc.driver.OracleDriver username: scott password: bruce123mybat...

package com.mybatis.inteface;import java.util.List;import org.apache.ibatis.annotations.Param;import com.mybatis.pojo.User;public interface UserInterface { //根据表名查询用户信息（直接使用注解指定传入参数名称） ...

package com.jdbc.demo;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class UseJDBC ...