JDBC 8 的参数及连接方法

最新推荐文章于 2023-03-18 15:00:58 发布

溜溜的小胖

最新推荐文章于 2023-03-18 15:00:58 发布

阅读量1.7k

点赞数

分类专栏： Java学习笔记

本文链接：https://blog.csdn.net/aliuxina/article/details/91358010

版权

Java学习笔记专栏收录该内容

12 篇文章 0 订阅

订阅专栏

package com.jdbc.ddl;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class InsertClass {
	public static void main(String[] args) {
		String url = "jdbc:mysql://localhost:3306/DATABASES-NAME?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true";
		String user = "USER-NAME";
		String password = "USER-PASSWORD";
		Connection conn = null;
		Statement st = null;

		try {
			Class.forName("com.mysql.cj.jdbc.Driver");

			conn = DriverManager.getConnection(url, user, password);

			String sql = "SQL";
			st = conn.createStatement();

			int row = st.executeUpdate(sql);
			System.out.println(row);

		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		} finally {
			if (st != null) {
				try {
					st.close();
				} catch (Exception e) {
					// TODO: handle exception
					e.printStackTrace();
				}
			}
			if (conn != null) {
				try {
					conn.close();
				} catch (Exception e) {
					// TODO: handle exception
					e.printStackTrace();
				}
			}

		}

	}

}