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();

     }

 }