Java-г MySQL өгөгдлийн сантай холбох (JDBC)

Эхлээд өгөгдлийн сангаа үүсгэнэ.

create database jdbc_test; 

3 field бүхий user нэртэй table үүсгэе.

CREATE TABLE  `jdbc_test`.`user` (
`id` INT NOT NULL ,
`name` VARCHAR( 50 ) NOT NULL ,
`mail` VARCHAR( 50 ) NOT NULL
) ENGINE = MYISAM ; 

Table-дээ өгөгдөл оруулна.

INSERT INTO user
VALUES ( 1,  "Gansukh",  "bganaa2009@gmail.com" ) ; 

NetBeans IDE хэрэглэж байгаа бол Project-доо MySQL JDBC Driver jar файлыг нэмж өгнө. Үүний тулд Project-ыхоо Libraries хэсэг дээр Right Click хийгээд Add Library, MySQL JDBC Driver сонгоод Add дарна.

package jdbc_test;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

public class Main {
    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost/jdbc_test";
    static final String DB_UNAME = "root";
    static final String DB_PASS = "";
    public static void main(String[] args) {
        Connection db_conn = null;
        Statement st = null;
        try{
            Class.forName(JDBC_DRIVER);
            db_conn = DriverManager.getConnection(DB_URL, DB_UNAME, DB_PASS);
            st = db_conn.createStatement();
            String q = "select *from user";
            ResultSet rs = st.executeQuery(q);
            ResultSetMetaData md = rs.getMetaData();
            int col = md.getColumnCount();
            for(int i = 1; i <= col; i++ ){
                System.out.printf("%s\t",md.getColumnName(i));
            }
            System.out.println();
            while(rs.next()){
                for(int i = 1; i <= col; i++ ){
                    System.out.printf("%s\t",rs.getObject(i));
                }
                System.out.println();
            }
        }
        catch(SQLException sqlExp){
            sqlExp.printStackTrace();
            System.exit(1);
        }
        catch (ClassNotFoundException cnf){
            cnf.printStackTrace();
            System.exit(1);
        }
        finally {
            try{
                st.close();
                db_conn.close();
            }
            catch(Exception e){
                e.printStackTrace();
                System.exit(1);
            }
        }
    }
}

Үр дүн:

run:

id name mail

1 Gansukh bganaa2009@gmail.com

BUILD SUCCESSFUL (total time: 0 seconds)