课时2：JDBC简介

配置路径

1.在建立的JDBCDemo下建立lib文件夹

2.通过安装的MySQL路径D:\MySQL\Connector J 5.1.31，找到.jar文件

3.将.jar文件加入到buildpath

4.建立Test.java并撰写代码

package com.geek99.demo;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class Test {

    public Test() {

    }

    public static void main(String[] args) {

        Connection cnn=null; 

        try {

            Class.forName("com.mysql.jdbc.Driver");

        } catch (ClassNotFoundException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

        try {

            cnn=DriverManager.getConnection("jdbc:mysql://localhost:3306/geek","root","123456");

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

        String sql="select id,name,email from CustomerTbl ";

        try {

            Statement stmt=cnn.createStatement();

            ResultSet rs=stmt.executeQuery(sql);

            while(rs.next()){

                int id=rs.getInt(1);

                String name=rs.getString(2);

                String email=rs.getString(3);

                System.out.println(id+":"+name+":"+email);

            }

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }finally{

            if(cnn!=null){

                try {

                    cnn.close();

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

            }

        }

    }

}