Przejdź do głównej zawartości

Java Database Connection: JDBC and MySQL

Java Database Connection: JDBC and MySQL

 JDBC - standard API allow to connect with MySQL

Java Application <--------- >JDBC <---------> Database

JDBC Architecture
  • JDBC Driver 
  • JDBC Driver Implementation
  • JDBC Driver Manager
JDBC API is definded in following packages:
  • java.sql and javax.sql

------------------------

Submitting SQL Queries  - JAVA
  1. Get a connection to database
  2. Create Statement object
  3. Execute SQL query
  4. Process Result Set

Get a connection to database

                   import java.sql.*;
                    ....
                   String dbUrl = "jdbc:mysql://localhost:3306/demo?                                                                                  autoReconnect=true&useSSL=false";
                    String user = "root";
                    String pass = "Sasanka01";
                     ....
                     Connection myConn = DriverManager.getConnection(dbUrl, user, pass);

Create Statement object 

 Statement myStmt = myConn.createStatement()

Execute SQL query

                        ResultsSet myRs = myStmt.executeQuery("select * from employees");

Process Result Set
  • Result Set is initially placed before first row
  • Method: ResultSet.next()
    • moves forward one row
    • returns true if there are more rows to proces
  • Collection of methods for reading data
    • getXXX(columnName)
    • getXXX(columnIndex) one -based

while (myRs.next()) {
System.out.println(myRs.getString("last_name") + ", " + myRs.getString("first_name"));
}


Etykiety:

Komentarze

Prześlij komentarz

Popularne posty z tego bloga

Stored Procedures - JDBC Java SQL

Stored Procedures: group of SQL statements that perform a particular task  Normally created by DBA Can have any combination of input, output, and input/output parameters Benefits: Performance  - compiled once but executable more times Productivity and Ease of Use  - avoid redundant code, extend SQL Database functionality  Scalability   Maintainability Interoperability Replication Security To call stored procedure from Java The JDBC API provides the CallableStatement CallableStatement myCall = myConn.prepareCall("{ call some_stored_procedure() }"); ... myCall.execute(); JDBC API parameter types IN default INOUT OUT Stored Procedure can return result sets EXAMPLE: Created stored procedure on MySQL side - NAME:  increase_salaries_for_department DELIMITER $$ DROP PROCEDURE IF EXISTS ` increase_salaries_for_department `$$ CREATE DEFINER=`student`@`localhost` PROCEDURE `increase_salaries_for_departme...
Prześlij komentarz
Czytaj więcej

Java - variables , data types

Data Types Data types in Java are classified in to types: Primitive - which include Integer, Character, Boolean and Floating Point Non-primitive - which includes Classes, Interfaces and Arrays Integer : byte 1 byte short 2 bytes int 4 bytes long 8 bytes Floating Point : number + fractional parts  float double Character : stores character Boolean : hold true false value Variables  Instance Variables (non-Static Fields) -  Objects store their individual states in “non-static fields”, that is, fields declared without the static keyword. Class Variables - Static Fields - any field with static modifier says that there is only one copy of this variable in existence static int myClassVariable = 6;  Local Variables - a method stores it's temporary state of local variables int count=0; Parameters - variables which will be passed to the methods of a class
Prześlij komentarz
Czytaj więcej

Inserting Data into SQL Database with Java

Inserting Data into SQL Database with Java Java Documentation - Processing SQL statements with JDBC  Process: Get connection to database Create a statement Execute SQL query import java.sql.*; /**  *  * @author www.luv2code.com  *  */ public class JdbcTest { public static void main(String[] args) throws SQLException { Connection myConn = null; Statement myStmt = null; ResultSet myRs = null; String dbUrl = "jdbc:mysql://localhost:3306/demo ?autoReconnect=true&useSSL=false "; String user = "root"; String pass = "Sasanka01"; try { // 1. Get a connection to database myConn = DriverManager.getConnection(dbUrl, user, pass); System.out.println("Database connection successfully created"); // 2. Create a statement myStmt = myConn.createStatement(); int rowsAffected = myStmt.executeUpdate(                          "...
Prześlij komentarz
Czytaj więcej