JAVA学习笔记之JDBC基础知识

JDBC全称：Java DataBase Connectivity (java数据库连接)

是一种用于执行SQL语句的Java API，可以为多种关系数据库提供统一访问，它由一组用Java语言编写的类和接口组成

package com.imooc.jdbc.demo1;



import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;



import org.junit.Test;



import com.mysql.jdbc.Driver;



public class JDBCDemo1 {

      

       @Test

       /**

        * JDBC的入门程序

        */

       public void demo1() {

             

              try {

                     // 1.加载驱动

                     DriverManager.registerDriver(new Driver());

                     // 2.获得连接

                     Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbctest", "root", "root");

                     // 3.创建执行SQL语句的对象，并且执行SQL

                     // 3.1创建执行sql的对象

                     String sql = "select * from user";

                     Statement stmt = conn.createStatement();

                     // 3.2执行sql

                     ResultSet resultSet = stmt.executeQuery(sql);

                     while(resultSet.next()) {

                            int uid = resultSet.getInt("uid");

                            String username = resultSet.getString("username");

                            String password = resultSet.getString("password");

                            String name = resultSet.getString("name");

                           

                            System.out.println(uid+"     "+username+"     "+password+"      "+name);

                     }

                     // 4.释放资源

                     resultSet.close();

                     stmt.close();

                     conn.close();

              } catch (SQLException e) {

                     // TODO Auto-generated catch block

                     e.printStackTrace();

              }

       }



}

 

错误信息记录

数据库连接失败（未开启数据库服务）：

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

数据库不存在：

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'jdbctest'

数据库连接，用户名或密码错误

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

 

本文将持续更新....