20165210 Java Seventh Week study summary

20165210 Java Seventh Week study summary textbook content Learning

• 11th Chapter Study Summary

1. To connect to a database:

1. 下载JDBC-MySQL数据库驱动2. 加载JDBC-MySQL数据库驱动3. 连接数据库4. 注意汉字问题

1. Query operation:

• Criteria and sort query:

1. where子语句：select 字段 from 表名 where 条件

1. Update, add, and delete operations:

Statement对象调用方法：public int executeUpdate(String sqlStatement);1. 更新：update 表 set 字段 = 新值 where <条件语句>2. 添加：insert into 表（字段列表）values （对应的具体的记录）或 insert into 表 values（对应的具体的记录）3. 删除：delete from 表名 where <条件子句>

1. Using Preprocessing statements
2. Transaction:

1. 事务及处理2. JDBC事务处理步骤

1. Link SQL Sever database and Derby database

   Code Hosting

Summary of last week's test error question

Sentiment

Although this week's code is not many, but for the software installation and familiarity is still more difficult.

20165210 Java Seventh Week study summary