My article: JDBC and database
JDBC
JDBC series: (1) connect to the database through JDBC
Http://lsieun.blog.51cto.com/9210464/1772359
JDBC series: (2) execute sql statements using Statement
Http://lsieun.blog.51cto.com/9210464/1772371
JDBC series: (2.5) create JDBCUtils work classes
Http://lsieun.blog.51cto.com/9210464/1846537
JDBC series: (3) execute sql statements using PreparedStatement
Http://lsieun.blog.51cto.com/9210464/1772405
JDBC series: (4) use CablleStatement to call stored procedures
Http://lsieun.blog.51cto.com/9210464/1772446
JDBC series: (5) batch processing using PreparedStatement
Http://lsieun.blog.51cto.com/9210464/1772460
JDBC series: (6) use PreparedStatement to obtain self-growth value
Http://lsieun.blog.51cto.com/9210464/1772462
JDBC series: (7) use Connection to operate transactions
Http://lsieun.blog.51cto.com/9210464/1772466
JDBC series: (8) handling of large text types in JDBC
Http://lsieun.blog.51cto.com/9210464/1772470
MySQL
MySQL series: (1) install and uninstall
Http://lsieun.blog.51cto.com/9210464/1787778
MySQL Series: (2) MySQL Foundation
Http://lsieun.blog.51cto.com/9210464/1787806
MySQL series: (3) MySQL enhancement
Http://lsieun.blog.51cto.com/9210464/1787865
MySQL series: (4) details
Http://lsieun.blog.51cto.com/9210464/1787873
Oracle
Oracle series: (1) introduction and installation
Http://lsieun.blog.51cto.com/9210464/1847000
Oracle series: (2) Uninstall
Http://lsieun.blog.51cto.com/9210464/1847006
Oracle series: (3) Oracle preparatory knowledge
Http://lsieun.blog.51cto.com/9210464/1847051
Oracle series: (4) Oracle preparatory knowledge 2
Http://lsieun.blog.51cto.com/9210464/1847058
Oracle series: (5) select clause
Http://lsieun.blog.51cto.com/9210464/1847061
Oracle series: (6) where clause
Http://lsieun.blog.51cto.com/9210464/1847063
Oracle series: (7) order by clause
Http://lsieun.blog.51cto.com/9210464/1847064
Oracle series: (8) one-line function
Http://lsieun.blog.51cto.com/9210464/1847067
Oracle series: (9) three types of conversions
Http://lsieun.blog.51cto.com/9210464/1847397
Oracle Series: (10) Summary
Http://lsieun.blog.51cto.com/9210464/1847402
Oracle series: (11) General functions and conditional judgment functions
Http://lsieun.blog.51cto.com/9210464/1847413
Oracle series: (12) multiline functions
Http://lsieun.blog.51cto.com/9210464/1847424
Oracle series: (13) Multi-table query
Http://lsieun.blog.51cto.com/9210464/1847446
Oracle Series: (14) Sub-query
Http://lsieun.blog.51cto.com/9210464/1847469
Oracle series: (15) Collection query
Http://lsieun.blog.51cto.com/9210464/1847480
Oracle series: (16) pagination
Http://lsieun.blog.51cto.com/9210464/1847491
Oracle series: (17) create tables and constraints
Http://lsieun.blog.51cto.com/9210464/1847529
Oracle Series: (18) Summary
Http://lsieun.blog.51cto.com/9210464/1847530
Oracle series: (19) add, delete and modify data
Http://lsieun.blog.51cto.com/9210464/1851281
Oracle series: (20) transactions
Http://lsieun.blog.51cto.com/9210464/1851465
Oracle series: (21) access objects under other users [authorization]
Http://lsieun.blog.51cto.com/9210464/1851473
Oracle Series: (22) View
Http://lsieun.blog.51cto.com/9210464/1851478
Oracle series: (23) synonyms
Http://lsieun.blog.51cto.com/9210464/1851485
Oracle series: (24) sequence
Http://lsieun.blog.51cto.com/9210464/1851500
Oracle series: (25) Index
Http://lsieun.blog.51cto.com/9210464/1851501
Oracle series: (26) user rights control
Http://lsieun.blog.51cto.com/9210464/1851502
Oracle Series: (27) Summary
Http://lsieun.blog.51cto.com/9210464/1851505
Oracle series: (28) PLSQL
Http://lsieun.blog.51cto.com/9210464/1851522
Oracle series: (29) stored procedures and stored functions
Http://lsieun.blog.51cto.com/9210464/1851783
Oracle Series: (30) Flip-flop
Http://lsieun.blog.51cto.com/9210464/1851797
Oracle series: (31) Oracle SQL statement optimization
Http://lsieun.blog.51cto.com/9210464/1851802
Oracle Series: (32) Summary
Http://lsieun.blog.51cto.com/9210464/1851804
