mysql代码,先创建一个testdb数据库在运行下面sql语句创建tb_data表,需要mysql-connector-java-5.1.21.jar连接数据库的jar包mysql-connector-java
CREATE TABLE `tb_data` (
`id` INT(11) DEFAULT NULL,
`user_name` VARCHAR(100) DEFAULT NULL,
`create_time` DATETIME DEFAULT NULL,
`random` DOUBLE DEFAULT NULL
) ENGINE=MYISAM DEFAULT CHARSET=utf8;
java代码
package com.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class InsertDataDemo {
static Connection conn = null;
public static void initConn() throws ClassNotFoundException, SQLException {
String url = "jdbc:mysql://localhost:3306/testdb?"
+ "user=root&password=123456&useUnicode=true&characterEncoding=UTF8&useSSL=false&serverTimezone=UTC";
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("成功加载MySQL驱动程序");
conn = DriverManager.getConnection(url);
} catch (Exception e) {
e.printStackTrace();
}
}
public static String randomStr(int size) {
String result = "";
for (int i = 0; i < size; ++i) {
int intVal = (int) (Math.random() * 26 + 97);
result = result + (char) intVal;
}
return result;
}