JDBC

以mysql数据库为例

1、加载驱动

public class TestDatabase {
	public static void main(String[] args) {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("加载驱动成功");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
}

运行结果

加载驱动成功

或者：

public class TestDatabase {
     private static String dbname="com.mysql.jdbc.Driver";
	public static void main(String[] args) {
		try {
			Class.forName("dbname");
			System.out.println("加载驱动成功");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}

	}
}










数据库连接


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

public class TestDatabase {
	public static void main(String[] args) {
		Connection con=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url="jdbc:mysql://localhost:3306/school";
			con=DriverManager.getConnection(url,"root","123456");
			System.out.println("数据库连接成功");
			System.out.println("加载驱动成功");
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try {
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

	}
}





运行结果


数据库连接成功
加载驱动成功


或者：


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

public class TestDatabase {
     private static String dbname="com.mysql.jdbc.Driver";
     private static String dburl="jdbc:mysql://localhost:3306/school";
     private static String username="root";
     private static String password="123456";
     
	public static void main(String[] args) {
		Connection con=null;
		try {
			Class.forName(dbname);
			con=DriverManager.getConnection(dburl,username,password);
			System.out.println("数据库连接成功");
			System.out.println("加载驱动成功");
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try {
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

	}
}





或者（不建议使用）：


import java.io.FileInputStream;
import java.io.InputStream;
import java.util.Properties;

public class TestDatabase {
	public static void main(String[] args) {
		try {
			Properties p=new Properties();
			InputStream in=new FileInputStream("./src/db.properties");
			p.load(in);
			System.out.println("数据库连接成功");
			System.out.println("加载驱动成功");
		} catch (Exception e) {
			e.printStackTrace();
		}

	}
}






db.properties


driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/school
name=root
password=123456






在或者（建议使用）


import java.io.InputStream;
import java.util.Properties;

public class TestDatabase {
	public static void main(String[] args) {
		try {
			Properties p=new Properties();
			//获取程序运行环境的类加载器,默认加载src根目录的文件信息
        ClassLoader loader=TestDatabase.class.getClassLoader();
         InputStream in=loader.getResourceAsStream("db.properties");
			p.load(in);
			System.out.println("数据库连接成功");
			System.out.println("加载驱动成功");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}




工程目录