eclipse如何连接mysql_Java如何连接mysql数据库？

package com.shaocoder.connection;import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;public class ConnectionTest {public static void main(String[] args) {Connection conn &＃61; null;try {//1.数据库连接的4个基本要素//①JDBC URL用于标识一个被注册的驱动程序&＃xff0c;驱动程序管理器通过这个URL选择正确的驱动程序&＃xff0c;从而建立到数据库的连接&＃xff1b;//jdbc&＃xff1a;表示URL中的协议//mysql&＃xff1a;子协议&＃xff0c;用于标识mysql数据库驱动程序//localhost:本机的IP地址//3306&＃xff1a;端口号//test&＃xff1a;表示访问test数据库String url &＃61; "jdbc:mysql://localhost:3306/test";//user:登录数据库的用户名String user &＃61; "root";//password:用户名对应的密码&＃xff0c;这些都是自己之前设定的String password &＃61; "123456";//mySql的驱动&＃xff1a;com.mysql.jdbc.DriverString driverName &＃61; "com.mysql.jdbc.Driver";//2.实例化DriverClass clazz &＃61; Class.forName(driverName);Driver driver &＃61; (Driver) clazz.newInstance();//3.通过DriverManager来注册驱动DriverManager.registerDriver(driver);//4.通过DriverManager的getConnection方法&＃xff0c;获取Connection类的对象conn &＃61; DriverManager.getConnection(url, user, password);//5.打印出conn对象System.out.println(conn);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();} finally {try {//当conn不为空时if(conn !&＃61; null) //关闭conn资源conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}
}

package com.shaocoder.connection;import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;public class ConnectionTest {public static void main(String args[]) {InputStream is &＃61; null;Connection conn &＃61; null;try {//通过类加载器访问jdbc.properties文件&＃xff0c;转化为输入流is &＃61; ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties");Properties pros &＃61; new Properties();pros.load(is);String user &＃61; pros.getProperty("user");String password &＃61; pros.getProperty("password");String url &＃61; pros.getProperty("url");String driverClass &＃61; pros.getProperty("driverClass");Class.forName(driverClass);conn &＃61; DriverManager.getConnection(url, user, password);System.out.println(conn);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();} finally {try {if(conn !&＃61; null)conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}try {if(is !&＃61; null)is.close();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}
}