Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Programming \ Java uses JDBC connect database     - ssh port forwarding Comments (Server)

- To compile and install Clang 3.5.0 in Linux CentOS (Linux)

- Acquaintance C ++: the most simple C ++ program (Programming)

- To install Scribus 1.4.4 under ubuntu (Linux)

- Linux hybrid character device (Linux)

- Oracle create user authorization and in PLSQL (Database)

- ORA-00845: MEMORY_TARGET not supported on this system Problem (Database)

- redis configuration in detail (English) (Database)

- JavaScript prototype and the prototype chain (Programming)

- Ubuntu install Lighttpd + Mono support .net (Linux)

- VMware virtual machine to install CentOS 7 (Linux)

- Linux md5sum verify file integrity (Linux)

- 11G ASM disk group does not automatically handle MOUNT (Database)

- PHP 5.3 New Features Detail (Linux)

- Java, extends and implements Usage (Programming)

- Oracle 12c users create (Database)

- CentOS7 build GlusterFS (Linux)

- Cool Android realization SVG animation (Programming)

- Use calcurse schedule appointments and to-do in the Linux terminal (Linux)

- Elementary OS Freya global menu (Linux)

  Java uses JDBC connect database
  Add Date : 2018-11-21      
  Develop a JDBC application, the basic needs of the following steps:

1. The JDBC driver class is loaded into the JAVA virtual machine. Use the static method forName java.lang.Class class (String className) implementation.

Example: Class.forName ( "JDBC driver class name")

2. load the driver, and establishes a connection to the database. DriverManager class followed by a registered driver, when we call the getConnection () method, which will traverse the list of drivers until a match on the connection string to connect to the data specified in the driver database, after loading the driver, use getConnection method of the DriverManager class to establish a connection between the database.


Connection con = DriverManager.getConnection (database connection string, database user name, password)
3. Send the SQL statement and get the result set. Create a Statement interface instance and SQL statements to the database it is connected.

 Statement instance is divided into three types:

 (1) executing a static SQL statements. Usually achieved by Statement instance.

 (2) execute dynamic SQL statements. Typically implemented by PreparedStatement instance.

 (3) the implementation of database stored procedures. Usually through CallableStatement instance.


Statement stmt = con.createStatement ();
ResultSet rs = stmt.executeQuery ( "select * from table1");
 Statement interface provides three methods execute SQL statements: executeQuery, executeUpdate, execute statement.

ResultSet executeQuery (String sqlString): execute SQL statements to query the database and returns a result set (ResultSet) object.
int executeUpdate (String sqlString): used to execute INSERT, UPDATE, or DELETE statements as well as SQL DDL statements, such as: CREATE TABLE and DROP TABLE, etc.
execute (sqlString): used to perform return multiple result sets, count, or a combination of both multiple update statements.

ResultSet rs = stmt.executeQuery ( "SELECT * FROM ...");
int rows = stmt.executeUpdate ( "INSERT INTO ...");
boolean flag = stmt.execute (String sql);

4. results. Results are divided into two situations:

(1) to perform the update returns this number of records affected by the operation.

 Results (2) to execute the query returns a ResultSet object.


while (rs.next ()) {
         int x = rs.getInt ( "a");
         String s = rs.getString ( "b");
         float f = rs.getFloat ( "c");
5. Close the JDBC objects

  After the operation is complete, close all JDBC objects to be used to release JDBC resources, closed in reverse order and declaration order.

 (1) off the record set

 (2) Close Statement

 (3) close the connection object

 if (rs! = null) {// set off the record
        try {
            rs.close ();
        } Catch (SQLException e) {
            e.printStackTrace ();
          if (stmt! = null) {// Close Statement
        try {
            stmt.close ();
        } Catch (SQLException e) {
            e.printStackTrace ();
          if (conn! = null) {// Close the connection object
         try {
            conn.close ();
         } Catch (SQLException e) {
            e.printStackTrace ();
- Nmcli based network management command-line tool (Linux)
- RCU lock in the evolution of the Linux kernel (Linux)
- How to extend / remove swap partitions (Linux)
- Linux operating system ARP Spoofing Defense (Linux)
- C ++ How to determine the types of constants (Programming)
- Linux environment has been running Tomcat how to deploy the new Tomcat (Server)
- CentOS 6.0 system security level (Linux)
- Oracle 12C RAC on temporary table space Enlighten (Database)
- Linux System Getting Started Learning: Linux in the last command (Linux)
- Android screen rotation processing and ProgressDialog the best AsyncTask (Programming)
- Linux common network tools: hping Advanced Host Scan (Linux)
- HttpClient Tutorial (Programming)
- Analyzing Linux server architecture is 32-bit / 64-bit (Server)
- Close Pycharm spell check (Programming)
- MySQL 5.6.12 binary log path switching binlog (Database)
- Arduino UNO simulation development environment set up and run simulation (Linux)
- Actual custom yum repository ---- gem commands commonly used parameters (Linux)
- Build their own recursive DNS server (Server)
- CentOS install Java 1.8 (Linux)
- Samba file sharing server set up (Server)
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.