// 1.JDBC Java Database Connectivity
// 2.JDBC定义统一接口，数据库供应商实现接口。
// 3.驱动的导入
// https://dev.mysql.com/downloads/connector/j/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class JDBC1001 {
public static void main(String[] args) throws Exception {
String strPwd = "123456";
// 1.注册驱动
Class.forName("com.mysql.cj.jdbc.Driver");//Mysql 5以后可以省略
// 2.获取连接
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root",strPwd);
// 3.获取执行对象
Statement statement = conn.createStatement();
// 4.执行Sql语句
String strSql = "select * from db";
ResultSet rs = statement.executeQuery(strSql);
// 5.处理结果
while (rs.next()){
System.out.println(rs.getString("User"));
}
// 6.关闭数据连接
conn.close();
}
}
