JDBC 数据库连接 Java操作数据库 jdbc快速入门

JDBC基本概念 
     Java DataBase Connectivity  数据库连接  java操作数据库
本质上（sun公司的程序员）定义的一套操作关系型数据库的规则 既接口

 更新内容之前

代码

 

package cn.zmh.JDBC;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
/*JDBC */
public class Demo11JDBC {
    public static void main(String[] args) throws Exception {
        /* 1: 导入jar包 mysql-connector-java-5.1.37-bin
                 1.1复制mysql-connector-java-5.1.37-bin到项目的libs目录下
                 1.2  右键----》Add As Library
         */
        // 2 注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        // 3 获取数据库连接对象  Connection
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/qy97","root","root");
        // 4 定义sql语句    UPDATE 表名 SET 列名='修改的字段' WHERE 键值
        String sql1 = "UPDATE user1 SET unames='张三'   WHERE uid=1";
        String sql2 = "UPDATE user1 SET unames='李四'   WHERE uid=2";
        String sql3 = "UPDATE user1 SET unames='王五'   WHERE uid=3";
        String sql4 = "UPDATE user1 SET unames='赵六'   WHERE uid=4";
        String sql5 = "UPDATE user1 SET uaddress='北京' WHERE uid=1";
        String sql6 = "UPDATE user1 SET uaddress='上海' WHERE uid=2";
        String sql7 = "UPDATE user1 SET uaddress='广州' WHERE uid=3";
        String sql8 = "UPDATE user1 SET uaddress='深圳' WHERE uid=4";
        // 5 获得执行sql语句对象    Statement
        Statement statement = connection.createStatement();
        // 6 执行sql语句
        int i1 = statement.executeUpdate(sql1);
        int i2 = statement.executeUpdate(sql2);
        int i3 = statement.executeUpdate(sql3);
        int i4 = statement.executeUpdate(sql4);
        int i5 = statement.executeUpdate(sql5);
        int i6 = statement.executeUpdate(sql6);
        int i7 = statement.executeUpdate(sql7);
        int i8 = statement.executeUpdate(sql8);
        // 7 控制台输出结果   可以不写
        System.out.println(i1+""+i2+""+i3+""+i4+""+i5+""+i6+""+i7+""+i8);
        // 8 释放资源
        statement.close();
        connection.close();

    }
}

 

更新内容之后