JDBC(Java Data Base Connectivity)

1.give a example first :

2.What is a JDBC(Java Data Base Connectivity)  :

please check this website : http://baike.baidu.com/link?url=W7snmw-O8Ha-Tb4GTatwxLEuyI6Du00bX_GzZEqnJJv5KdygdvOcddFyozT5gR6XT7A7G9GzXIui6hep1RLzU_



3. Step of JDBC

    first: Register Driver   :

Class.forName("com.mysql.jdbc.Driver");
    second : write the url,username,password :

final String url ="jdbc:mysql:///Test";
final String username = "root";
final String password = "root";
Connection connection = DriverManager.getConnection(url,username,password);
    thrid :　　Create a Statement and Connect then Query :        


Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT  * FROM student");           

    fourth :    Query all data in table              

ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
//et the column id
int count = resultSetMetaData.getColumnCount();
    while (resultSet.next()){
        for(int i =1 ; i<= count; i++){
            //System.out.print(resultSet.getBlob(i));
            //System.out.print(resultSet.getArray(i));
            System.out.print(resultSet.getString(i) + "\t");
            if(i == 2){
                System.out.print("\t");
            }
        }
        System.out.println();
    }


4.Some keyWords of JDBC

        Class , Connection,Statment,PrepareStatement,ResultSet.metaData....




GoodLuck !!    @IparhanJava