mysql>CREATE   DATABASE test;   //创建一个数据库

mysql>use  test;  //指定test为当前要操作的数据库

mysql>CREATE  TABLE  user (name VARCHAR(20),password VARCHAR(20));   //创建一个表user，设置两个字段。

mysql>INSERT  INTO  user  VALUES(‘huzhiheng‘,‘123456‘); //插入一条数据到表中

import java.sql.*;

public class MysqlJdbc {
    public static void main(String args[]) {
        try {
            Class.forName("com.mysql.jdbc.Driver"); // 加载MYSQL JDBC驱动程序
            //Class.forName("org.gjt.mm.mysql.Driver");
            System.out.println("Success loading Mysql Driver!");
        } catch (Exception e) {
            System.out.print("Error loading Mysql Driver!");
            e.printStackTrace();
        }
        try {
            Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "123456"); 
            //根据自身情况修改   jdbc:mysql://localhost:端号/数据库名", "用户名", "密码"
            System.out.println("Success connect Mysql server!");
            Statement stmt = connect.createStatement();
            ResultSet rs = stmt.executeQuery("select * from user"); // user为需要连接数据库的表的名称
            while (rs.next()) {
                System.out.println(rs.getString("name"));  //user表里的name
            }
        } catch (Exception e) {
            System.out.print("get data error!");
            e.printStackTrace();
        }
    }
}

import java.sql.*;

public class Myjproject {
 public static void main(String args[])
 {
     try {
          Class.forName("com.mysql.jdbc.Driver");     //加载MYSQL JDBC驱动程序   
          //Class.forName("org.gjt.mm.mysql.Driver");
         System.out.println("Success loading Mysql Driver!");
        }
        catch (Exception e) {
          System.out.print("Error loading Mysql Driver!");
          e.printStackTrace();
        }
  try {
      Connection connect = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test","root","123456");
     
       int num=100;
       PreparedStatement Statement=connect.prepareStatement("INSERT INTO user VALUES(?,?)");
       for(int i=0;i<num;i++)        //定义个100次的循环，往表里插入一百条信息。
      {
           Statement.setString(1,"chongshi"+i);
           Statement.setString(2,"bo"+i);
           Statement.executeUpdate();
   }

   }catch(SQLException e)
   {
   }
 }
}

select *
from user