Java JDBC

大作业：

索引：姓名、年龄数据变长，可以加空格预留

缓存：课程全部放在缓存，学生索引放在缓存

---

Java JDBC

全都是interface

提供API访问操作数据库

Class.forName("com.mysql.jdbc.Driver");//加载驱动程序

Connection con = DriverManager.getConnection(
    "java","java1234",//用户名，密码
    "jdbc:mysql://localhost:3306/test"
);
Statement stmt = con.creatStatement();//返回一个

Result rs = stmt.excuteQuery(
    "select * from student where id = '001'";
);
while(rs.next())
{
    String id = rs.getString("id");
    String name = rs.getString("name");
    int age = rs.getInt("age");
}

Properties p = new Properties();//将连接信息写在配置文件中
p.load(new FileInputStream("jdbc.properties"));

Class.forName("com.mysql.jdbc.Driver");//加载驱动程序

Connection con = DriverManager.getConnection(
    p.getProperties("username");
    Tool.decrypt(p.getProperty("asadasd"));
    p.getProperty("jdbcUrl");
);
Statement stmt = con.creatStatement();//返回一个

Result rs = stmt.excuteQuery(
    "select * from student where id = '001'";
);
while(rs.next())
{
    String id = rs.getString("id");
    String name = rs.getString("name");
    int age = rs.getInt("age");
}

注意：Statement效率很低，执行速度慢，谨慎使用

替换为PreparedStatment

 

采用连接池可以加快速度