JDBC（最简单方法）

java连接mysql数据库
1.加载驱动

Class.forName("com.mysql.jdbc.Driver");

2.获取连接对象

Connection conn =DriverManager.getConnection
("jdbc:mysql://localhost:3306/3-15","root","root");

3.获取Statement

Statement st=conn.createStatement();

4.查询

ResultSet re = st.executeQuery("select * from course");

5.遍历

while(re.next())
	{
	  System.out.println
	  (re.getString(1)+re.getString(2)+re.getString(3));
	}

6.按出栈顺序关闭

re.close();
st.close();
conn.close();

完整代码：

package com.xxx.web;

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

public class ConnectMysql {

	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		// 加载驱动
		Class.forName("com.mysql.jdbc.Driver");
		//获取连接对象
		Connection conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/3-15","root","root");
		//获取Statement
		Statement st=conn.createStatement();
		//查询
		ResultSet re = st.executeQuery("select * from course");
		//遍历
		while(re.next())
		{
			System.out.println(re.getString(1)+re.getString(2)+re.getString(3));
		}
		re.close();
		st.close();
		conn.close();
	}
}