Java连接Mysql数据库增删改查实现

Java连接Mysql数据库增删改查实现

时间比较赶，我这里只实现查询，有时间再添加另外两个
难度 : ⭐⭐⭐（全星5颗星的情况下）
新建一个动态的网站工程，
把jar包全部复制进去，主要要那个mysql-connector-java那个jar包，重要通知，我的mysql版本是5.7.18-log版本，这个jar版本够，如果你装的是mysql8点几的版本，则带不起来，需要高版本的驱动版；

package com.anhui.dajun;

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

public class JDBCUtil {
	private static final String URL = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8";
	private static final String DRIVERS = "com.mysql.jdbc.Driver";
	private static final String USERNAME = "root";
	private static final String PASSWORRD_STRING = "root";

	public static void main(String[] args) {
		
		Connection connection = null;
		ResultSet rs = null;
		Statement stmt = null;
		try {
			try {
				Class.forName(DRIVERS);
				connection = DriverManager.getConnection(URL, USERNAME, PASSWORRD_STRING);
				stmt = connection.createStatement();
				String sql = "SELECT * FROM tt_user";
				rs = stmt.executeQuery(sql);
				while (rs.next()) {
					System.out.println("Id 是 : " + rs.getString("id") + " | " + "姓名 :  " + rs.getString("name") + " | "
							+ "年齡  ： " + rs.getString("age") + " | " + " 地址  :  " + rs.getString("address"));
					System.out.println("--------------------------------");
				}
			} catch (SQLException e) {
				e.printStackTrace();
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
		} finally {
			if (rs != null) {
				try {
					rs.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if (stmt != null) {
				try {
					stmt.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if (connection != null) {
				try {
					connection.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
	}
	
	

}

/*
SQLyog Ultimate v10.00 Beta1
MySQL - 5.7.18-log 
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `tt_user` (
	`id` int ,
	`name` varchar ,
	`age` int ,
	`address` varchar 
); 
insert into `tt_user` (`id`, `name`, `age`, `address`) values('1','大军','26','上海市');
insert into `tt_user` (`id`, `name`, `age`, `address`) values('2','杨红','24','云南');
insert into `tt_user` (`id`, `name`, `age`, `address`) values('3','赵刘','27','陕西');
insert into `tt_user` (`id`, `name`, `age`, `address`) values('4','李四','23','安徽');
insert into `tt_user` (`id`, `name`, `age`, `address`) values('5','刘六','30','安徽安庆');
insert into `tt_user` (`id`, `name`, `age`, `address`) values('6','王二','22','北京市');
insert into `tt_user` (`id`, `name`, `age`, `address`) values('7','123','213','213');