# MysqlConnection

**Repository Path**: xclhove/MysqlConnection

## Basic Information

- **Project Name**: MysqlConnection
- **Description**: java连接mysql
- **Primary Language**: Java
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-05-13
- **Last Updated**: 2023-05-20

## Categories & Tags

**Categories**: Uncategorized

**Tags**: Java, MySQL

## README

# 连接配置

**假设连接MYSQL的配置如下：**

| 名称  | 参数  |
| :----: | :--------------: |
| 连接名 | root@localhost |
|  主机  | localhost      |
|  端口  | 3306           |
| 用户名 | root           |
|  密码  | 123456         |

**则`/src/java/Main.java`中的配置应为：**

```java
//用户名
private static String connectUser = "root";
//密码
private static String connectPassword = "123456";
//主机
private static String connectHost = "localhost";
//端口
private static String connectPort = "3306";
```

# 查询配置

**假如要查的数据为mysql数据库user表的user属性和host属性**:

SQL如下：

```sql
user mysql;
select user, host
from user;
```

查询结果如下：

| user             | host      |
| ---------------- | --------- |
| root             | %         |
| xclhove          | %         |
| mysql.infoschema | localhost |
| msyql.session    | localhost |
| mysql.sys        | localhost |

**则`/src/java/Main.java`中的配置应为：**

```java
//数据库名
private static String dataBaseName = "mysql";
```

```java
//定义SQL语句
String sql = "select user, host from user";
```

```java
//打印查询结果
System.out.println("print result:");
System.out.println("--------------------");
System.out.println("|user|host|");
while (resultSet.next()) {//按行遍历查询结果

    //获取一行中属性'ClassName'的值
    String user = resultSet.getString("user");

    //获取一行中属性'UserName'的值
    String host = resultSet.getString("host");

    //打印结果
    System.out.println("|" + user + "|" + host + "|");
}
System.out.println("--------------------");
```

**运行结果如下：**

```
--------------------
user:root
password:123456
host:localhost
port:3306
dataBaseName:mysql
characterEncoding:UTF-8
driver:com.mysql.cj.jdbc.Driver
connectUrl:jdbc:mysql://localhost:3306/mysql?characterEncoding=UTF-8
--------------------
loading……
driver loaded successfully.
--------------------
connecting……
the connection is successful.
--------------------
SQL is running……
print result:
--------------------
|user|host|
|root|%|
|xclhove|%|
|mysql.infoschema|localhost|
|mysql.session|localhost|
|mysql.sys|localhost|
--------------------

进程已结束,退出代码0
```

所用驱动**mysql-connector-j-8.0.33.jar**来自[https://dev.mysql.com/downloads/connector/j/?os=26](https://dev.mysql.com/downloads/connector/j/?os=26)