20165201 2017-2018-2 "Java Programming" 8th Week study Summary

20165201 2017-2018-2 "Java Program Design" 8th Week study summary textbook Study content summary 12th Chapter

• Connect to database: Connection getConnection(java.lang.String, java.lang.String, java.lang.String) ,Connection getConnection(java.lang.String)

Criteria and sort query:

• where child statement
  
• Sort

order by 子语句对记录进行排序  order by <字段名>  

• Updateupdate 表 set 字段 = 新值 where<条件子句>
  
• Add toinsert into 表（字段列表）value （对应的具体的记录）
  
• Deletedelete from 表名 where <条件子句>
  
• Transactions: Transactions are composed of SQL statements, which means that the application guarantees that the SQL statements in the transaction are either all executed or none of them execute
  
• JDBC Transaction Process steps
  Turn off autocommit mode with the Setautocommit (Booean B) method
  Handling transactions with the commit () method
  Processing a transaction failure with the rollback () method

Problems in learning and the process of solving them

• Question: I followed Lou Teacher's tutorial to download and install the XAMPP, then in the idea of the relevant configuration, but the database has not been connected ... Such as:

• Problem Solving method: I asked our class to use the same Mac classmate, and search the question on the Internet, the conclusion is: My JDK version is too high, I use JDK 9, but the current connector does not support this version, so I need to swap with JDK 8

Code Hosting last week exam error summary

Answer: ACDE

Answer: Ab,select is not

Answer: Rowset inherits the interface resultset and populates its data area with populate!

Learning progress Bar

	lines of code (new/cumulative)	Blog Volume (Add/accumulate)	Learning Time (new/cumulative)	Important Growth
Goal	6000 rows	30 Articles	400 hours
First week	23/23	1/5	18/18
Second week	367/390	2/7	16/34
Third week	672/1062	1/8	23/57
Week Four	724/1786	2/10	20/77
Week Five	1084/2870	1/11	15/92
Week Six	1187/4057	1/12	18/110
Seventh Week	756/4813	1/13	20/130

Resources

• Use the Code cloud and blog Park to learn a simple tutorial

20165201 2017-2018-2 "Java Programming" 8th Week study Summary