MYSQL-1-插入Insert



package a;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class Insert1 {
 public static void main(String[] args) throws Exception {
  Class.forName("com.mysql.jdbc.Driver");
  Connection conn = DriverManager.getConnection(
    "jdbc:mysql://localhost:3306/School", "root", "root");
  Statement stat = conn.createStatement();
  String sql = "INSERT INTO T_STUDENT(STUNO,STUNAME,STUSEX) VALUES('12436109','fantasy','man')";
  int i = stat.executeUpdate(sql);
  System.out.println("请求权" + i + "请求权");
  stat.close();
  conn.close();
 }
}



创建数据库school，，再建表t_student



查看字段 及类型