JAVA连接MySQL数据库

package com.coding.test;

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

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class MyDemo {
	public static void main(String[] args) {
		try {
			//加载数据库驱动
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("加载成功!");
		} catch (ClassNotFoundException e) {
			System.out.println("加载失败!未找到加载数据库驱动!");
			e.printStackTrace();
		}
		String url = "jdbc:mysql://localhost:3306/test";//数据库地址及数据库名
		String user = "root";							//账户
		String password = "root";						//数据库密码
		Connection connection;
		Statement statement;
		try {
			connection = (Connection) DriverManager.getConnection(url, user, password);//获取连接
			statement = (Statement) connection.createStatement();
			String sql = "select * from store";	//创建SQL语句
			ResultSet set = statement.executeQuery(sql);	//执行SQL语句，返回结果集
			//判断是否查询成功
			if (!(set.equals(null))) {
				System.out.println("连接成功!");
			} else {
				System.out.println("连接失败!");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}
}