JDBC Review notes

JDBC Principle: Java provides a set of specifications, by the major database vendors for their own database to provide the implementation of this set of specifications, this specification is called JDBC, and implementation is called the JDBC driver table program

Four core categories:

DriverManager----getconnection () //Get connection

Connection------createstatement //general statement set

-----preparestatement //Precompiled statement set (anti-SQL attack, high readability, high efficiency. Check syntax, compile action only once, parameterized SQL statement)

Statement------executeupdate () ///delete/modify

-----executeQuery //Enquiry

ResultSet------Next () //Move the cursor down one line, the return value is a Boolean, indicating whether the current row cursor points to the existence of the position, you can use the next () return value to determine whether the current row exists

-----getObject (), getString (n), GetInt (n) ... //Gets the top, n represents the index of the column, starting from 1

Four parameters (get connection):

Driverclassname //Driver class name

URL //database address

Username //database user name

Password //Database Password

JDBC Review notes