JDBC(5)

添加数据
一共三种方法，不推荐第三种

package com.hqy;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
//添加数据
public class JDBCDemo03 {
    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.jdbc.Driver");
        Connection coon = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb1?characterEncoding=utf8&useSSL=false", "root", "123456");
        Statement state = coon.createStatement();
        //写法一：
        /*
        int i = state.executeUpdate("insert into hqy(id,name) values(null,\"张三\")");
        int j = state.executeUpdate("insert into hqy(id,name) values(null,\"李四\")");
        int x = state.executeUpdate("insert into hqy(id,name) values(null,\"王五\")");
        System.out.println("受影响行:"+i);
        System.out.println("受影响行:"+j);
        System.out.println("受影响行:"+x);
        */
        //写法二
     /*   int w = state.executeUpdate("insert into hqy(id,name) values (null,'姓名一'),(null,'姓名二'),(null,'姓名三')");
        System.out.println("受影响行数："+w);*/
        //写法三：allowMultiQueries=true 允许多个查询  在  URL中useSSL=false后面加
        //不推荐写法三
   /*     int q = state.executeUpdate("insert into hqy(id,name)values(null ,'方法三1');insert into hqy(id,name) values (null,'方法三2')");
        System.out.println("受影响行数："+q);*/


        state.close();
        coon.close();
        System.out.println("执行完成");
    }
}