package cn.zhouzhou;

/*

    一、JDBC?

        1.（java date base connectivity，java）是一种用于执行SQL语句的java API 。

        2.jdbc本质是一套API ，由开发公司定义的类和接口。

        3.使用mysql驱动，是一套类库，实现了接口

        4.驱动程序类库，实现接口的重写方法，有驱动程序操作数据库。

     二、jdbc怎么操作？

        1.注册驱动，获得连接。

            导入jar包 自己下载，我的是mysql-connector-java-5.1.37-bin.jar

        2.获得语句执行平台，就可以执行SQL语句

        3.处理结果，释放资源！

 */

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class java连接数据库 {

    public static void main(String[] args)throws Exception {

                                                                        //1.注册驱动

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

                                                                        //2.获得数据库连接

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

                                                                        //3.使用SQL语句  定义!

        String sql="select *from shop";

                                                                     //4.获得执行SQL语句对象 statement

        Statement stat =con.createStatement();

                                                                    //5.执行SQL语句

        ResultSet rs = stat.executeQuery(sql);

        while(rs.next()){

            System.out.println(rs.getString("id")+rs.getString("name")+rs.getString("price"));

        }                                                            //6.处理结果

                                                                     //7.释放资源

        stat.close();

        con.close();

    }

    private static void show()throws Exception{

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

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

        String sql="update shop set name='李华' where id=10";

        Statement stat =con.createStatement();

        int i= stat.executeUpdate(sql);

        System.out.println(i);

        stat.close();

        con.close();

    }

    private static void run()throws Exception{

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

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

        String sql="update shop set name='001'where id=8";

        Statement stat=con.createStatement();

        int i =stat.executeUpdate(sql);

        System.out.println(i);

        stat.close();

        con.close();

    }

    private static void run01()throws Exception{

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

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

        String sql="update shop set name='dd' where id=78";

        Statement stat =con.createStatement();

        int i =stat.executeUpdate(sql);

        System.out.println(i);

        stat.close();

        con.close();

    }

    private static void run02() throws Exception{

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

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

        String sql="update shop set naem'23' where id=78";

        Statement start =con.createStatement();

        int i = start.executeUpdate(sql);

        System.out.println(i);

        start.close();

        con.close();

    }

    private static void run03() throws  Exception{

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

        Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/qy66");

        String sql="update shop set name='45' where id=45";

        Statement start=con.createStatement();

        int i=start.executeUpdate(sql);

        System.out.println(i);

        start.close();

        con.close();

    }

}