一、什么是JDBC
JDBC(Java Database Connection)为java开发者使用数据库提供了统一的编程接口,它由一组java类和接口组成。
它是java程序与数据库系统通信的标准API,JDBC API使得开发人员可以使用纯java的方式来连接数据库,并执行操作。
二、JDBC的访问数据流程
Class.forName(“com.mysql.jdbc.Driver”);
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名", "root", "密码");
//编写SQL语句
String sql = "selectp.pid,pname,cname,city,birthday,height,weight,position,body,shoot,control from players as p inner join clubs as c on p.cid=c.cid inner join abilities as a on p.pid=a.pid";
//预编译指令
Statement st = con.createStatement();
//返回结果集
ResultSet rs = st.executeQuery(sql);
//对结果进行遍历输出
while (rs.next()) {
System.out.println(rs.getInt(1) + "\t" + rs.getString(2) + "\t" + rs.getString(3) + "\t" + rs.getString(4)+ "\t" + rs.getDate(5) + "\t" + rs.getInt(6) + "\t" + rs.getInt(7) + "\t" + rs.getString(8)+ "\t" + rs.getInt(9) + "\t" + rs.getInt(10) + "\t" + rs.getInt(11));}
rs.close();//关闭结果集
st.close();//关闭编译指令
con.close();//关闭数据库连接
三、DriverManager 类
DriverManager 是JDBC的管理层,作用于