jdbc:java数据库的连接,提供规范(接口)
1、选择数据库,注册驱动
DriverManager.registerDriver();
//Class.forName(""); 该条语句可以从配置文件中得到值
2、建立连接
String url="jdbc:mysql://localhost:3306/db_test1";
Connection conn=DriverManager.getConnection(url, "root", "123456");
3、载体
Srarement,PreparedStatement,CallableStatement
Statement stmt=conn.createStatement();
4、发送sql语句
ddl:create、alter、drop
dml:insert、update、delete 直接操作数据库,返回的0(失败),1(成功)显示是否成功
dql:select
executeQuery():Result 查询
executeUpdate():int 增删改
stmt.executeQuery(sql);//select
stmt.executeUpdate(sql);//insert update delete
String sql="select * from employee";
ResultSet rs=stmt.executeQuery(sql);
5、处理结果集
while(rs.next()) {
int id=rs.getInt(1);
//rs.getInt("id");
int dept_id=rs.getInt(2);
String name=rs.getString("ename");
float salary=rs.getFloat("salary");
System.out.println(id+","+dept_id+","+name+","+salary);
}
6、关闭连接
rs.close();
stmt.close();
conn.close();