Java开发学习(5)

人事管理系统从无到有4

pom文件更新插件reimport就好

问题 插件版本问

<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.22</version>
</dependency>

mysql-java连接插件和数据库版本一致

 <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.19</version>
    </dependency>

配置信息，抛异常处理

package cn.edu.mju.wjy29.dao.impl;

import com.alibaba.druid.pool.DruidDataSource;

import java.sql.Connection;

public class MySqlDbUtil {
    private static DruidDataSource dataSource = null;
    private static void initDataSource() throws Exception{
        if(dataSource == null){
            dataSource = new DruidDataSource();
            dataSource.setUrl("jdbc:mysql://localhost:3306/renshiguanli?useUnicode=true&characterEncoding=UTF-8");
            dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
            dataSource.setUsername("root");
            dataSource.setPassword("root");

            dataSource.setInitialSize(1);
            dataSource.setMinIdle(1);
            dataSource.setMaxActive(10);

            dataSource.setMaxWait(20000);
            dataSource.setTimeBetweenEvictionRunsMillis(20000);

            dataSource.setValidationQuery("SELECT 'x'");
            dataSource.setTestWhileIdle(true);
            dataSource.setTestOnBorrow(true);
        }
    }
    public static Connection getConnect() throws Exception{
        Connection conn = null;
        initDataSource();
        conn = dataSource.getConnection();
        return conn;
    }
}

问题？插件版本
pom文件更新插件reimport就好
pom数据库连接插件`
IDEA MYSQL 中文乱码问题（点击下方链接）
https://www.cnblogs.com/bb1008/p/7704458.html

Parameter index out of range (1 > number of parameters, which is 0 错误！

    String sql = "DELETE FROM user WHERE id=?";

解决办法：id=?的？改成英文状态下的?

user表的增删改查，条件查询测试完了