jdbc 入门 demo1

package cn.itcast.jdbc;

import java.sql.*;

/**
 * jdbc快速入门
 */
public class JdbcDemo1 {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        // 1.导入驱动jar包

        // 2.注册驱动
        Class.forName("com.mysql.cj.jdbc.Driver");

        // 获取数据库连接
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/blog", "root", "123456");

        // 定义一个sql
        String sql = "update links set `orderby` = 120 where id = 1";


        // 获取sql执行对象
        Statement statement = conn.createStatement();

        int count = statement.executeUpdate(sql);

        System.out.println(count);

        statement.close();
        conn.close();
    }
}