Mysql_四种连接数据库的方式

方式一

package cn.tedu.domain;

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

public class Demo1 {
	/**
	 * 加载数据库的驱动形式
	 */
	
	/*
	 * private static String url="jdbc:mysql///db1"; private static String
	 * user="root"; private static String password="root";
	 */
	
	public static void main(String[] args) {
		
		Connection conn=null;
		
		try {//JDBC 1.3开始可以进行直接省略了
			//Class<?> cls = Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql:///db1", "root", "root");
			System.out.println(conn+"连接成功！");
			conn.close();
		}  catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
		
		
		
	}
	
	
	
	
	

}

方式二

package cn.tedu.domain;

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

public class Demo2 {
	/**
	 * 加载数据库的驱动形式
	 */
	
	static /*
	 * private static String url="jdbc:mysql///db1"; private static String
	 * user="root"; private static String password="root";
	 */
	String user="root";
	static String password="root";
	static String url="jdbc:mysql:///db1";
	
	
	public static void main(String[] args) {
		Connection conn=null;
		
		try {//JDBC 1.3开始可以进行直接省略了
			
			Class<?> cls = Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(url, user, password);
			System.out.println(conn+"连接成功！");
			conn.close();
		}  catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
		
		
		
	}
	
	
	
	
	

}

方式三

package cn.tedu.domain;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class Demo3 {
	/**
	 * 加载数据库的驱动形式
	 */
	
	/*//static 
	 * private static String url="jdbc:mysql///db1"; private static String
	 * user="root"; private static String password="root";
	 */
	
	public static void main(String[] args) {
		Connection conn=null;
		
		try {//JDBC 1.3开始可以进行直接省略了
			
			//使用Properties属性进行配置
			Properties pro=new Properties();
			
			String user = (String) pro.setProperty("user", "root");
			String password = (String) pro.setProperty("password", "root");
			
			Class<?> cls = Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql:///db1",pro);
			System.out.println(conn+"连接成功！");
			conn.close();
		}  catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
		
		
		
	}
	
	
	
	
	

}

方式四（最理想的方式）

package cn.tedu.domain;

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 Demo4 {
	/**
	 * 加载数据库的驱动形式
	 */
	
	/*//static 
	 * private static String url="jdbc:mysql///db1"; private static String
	 * user="root"; private static String password="root";
	 */
	
	public static void main(String[] args) {
		Connection conn=null;
		
		try {//JDBC 1.3开始可以进行直接省略了
			
			//读取配置文件
			Properties pro=new Properties();
			InputStream is = Demo4.class.getClassLoader().getResourceAsStream("pro.properties");
			pro.load(is);
			
			String user = pro.getProperty("user");
			String password = pro.getProperty("password");
			String url = pro.getProperty("url");
			
			
			Class<?> cls = Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(url,user,password);
			System.out.println(conn+"连接成功！");
			conn.close();
		}  catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
		
		
		
	}
	
	
	
	
	

}

>