数据库mysql和Java一起的使用 |||||||| JDBC：的使用hello jdbc

1.为了实现添加一百条数据的功能，有以下代码

package jdbc;

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

public class TestJDBC {
    public static void main(String[] args) {

        try {
            Class.forName("com.mysql.jdbc.Driver");

            Connection c = DriverManager
                    .getConnection(
                            "jdbc:mysql://127.0.0.1:3306/how2java?characterEncoding=UTF-8",
                            "root", "admin");

            Statement s = c.createStatement();

            // 准备sql语句
            // 注意： 字符串要用单引号'
            for(int i=1;i<=100;i++)
            {String sql = "insert into hero values(null,"+"'英雄"+i+"',"+313.0f+","+50+")";
            s.execute(sql);}

            System.out.println("执行插入语句成功");

        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }
}