JAVA链接JDBC代码

package test01;

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

public class TestMain01 {

	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		//1)加载驱动
		Class.forName("com.mysql.jdbc.Driver");
		//2)DriverManager获取数据库链接  int a = func(......);
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test01", "root", "123456");
		//3)通过链接，创建statement
		Statement stat = conn.createStatement();
		// 4)执行SQL，获取结果集
		// 增、删、改  对表进行update操作
		// 查  对表进行查询操作 query     Resultset
		ResultSet rs = stat.executeQuery("select * from users");
		while(rs.next()){
			System.out.println(rs.getString("name"));
		}
		// 5)关闭链接
		rs.close();
		stat.close();
		conn.close();
	}

}