今天学习了定时将数据插入MySQL数据库。感谢这位博主。
原文连接:
https://blog.csdn.net/leelizc/article/details/74854042
1.代码如下
package com.jy.testMysql;
/**
* @author t
* @version 1.0
* @date 2020/4/8 15:36
* @company juya
*/
public class TestOnce {
public static void main(String[] args) {
TestMySQL testMySQL = new TestMySQL();
testMySQL.start();
System.out.println("testMysql:"+testMySQL);
}
}
package com.jy.testMysql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.Date;
import java.util.Timer;
import java.util.TimerTask;
/**
* @author t
* @version 1.0
* @date 2020/4/8 15:07
* @company juya
*/
public class TestMySQL extends TimerTask {
private Connection connection;
private String JDBC_Driver = "com.mysql.jdbc.Driver";
private String DB_URL = "jdbc:mysql://spark:3306/test";
private String user = "root";
private String password = "root";
//时间量
Date startDate = new Date();
//定时器
private Timer timer = new Timer();
public void start(){
//2秒执行一次
timer.schedule(this,startDate,2000);
}
public void run() {
double round = Math.round(1);
System.out.println("round:"+round);
try {
Class.forName(JDBC_Driver);
connection = DriverManager.getConnection(DB_URL,user,password);
String sql = "insert into t_test(num) values (?)";
PreparedStatement rs = connection.prepareStatement(sql);
rs.setDouble(1,round);
rs.executeUpdate();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
2.打印结果
D:\jdk1.8.0_201\bin\java.exe "-javaagent:D:\IntelliJ IDEA 2018.3.4\lib\idea_rt.jar=65215:D:\IntelliJ IDEA 2018.3.4\bin" -Dfile.encoding=UTF-8 -classpath D:\jdk1.8.0_201\jre\lib\charsets.jar;D:\jdk1.8.0_201\jre\lib\deploy.jar;D:\jdk1.8.0_201\jre\lib\ext\access-bridge-64.jar;D:\jdk1.8.0_201\jre\lib\ext\cldrdata.jar;D:\jdk1.8.0_201\jre\lib\ext\dnsns.jar;D:\jdk1.8.0_201\jre\lib\ext\jaccess.jar;D:\jdk1.8.0_201\jre\lib\ext\jfxrt.jar;D:\jdk1.8.0_201\jre\lib\ext\localedata.jar;D:\jdk1.8.0_201\jre\lib\ext\nashorn.jar;D:\jdk1.8.0_201\jre\lib\ext\sunec.jar;D:\jdk1.8.0_201\jre\lib\ext\sunjce_provider.jar;D:\jdk1.8.0_201\jre\lib\ext\sunmscapi.jar;D:\jdk1.8.0_201\jre\lib\ext\sunpkcs11.jar;D:\jdk1.8.0_201\jre\lib\ext\zipfs.jar;D:\jdk1.8.0_201\jre\lib\javaws.jar;D:\jdk1.8.0_201\jre\lib\jce.jar;D:\jdk1.8.0_201\jre\lib\jfr.jar;D:\jdk1.8.0_201\jre\lib\jfxswt.jar;D:\jdk1.8.0_201\jre\lib\jsse.jar;D:\jdk1.8.0_201\jre\lib\management-agent.jar;D:\jdk1.8.0_201\jre\lib\plugin.jar;D:\jdk1.8.0_201\jre\lib\resources.jar;D:\jdk1.8.0_201\jre\lib\rt.jar;D:\ideaWorkSpace\service_capability_evaluate\calculation_mysql\target\classes;D:\m2\org\apache\flink\flink-core\1.8.1\flink-core-1.8.1.jar;D:\m2\org\apache\flink\flink-annotations\1.8.1\flink-annotations-1.8.1.jar;D:\m2\org\apache\flink\flink-metrics-core\1.8.1\flink-metrics-core-1.8.1.jar;D:\m2\org\apache\flink\flink-shaded-asm\5.0.4-6.0\flink-shaded-asm-5.0.4-6.0.jar;D:\m2\org\apache\commons\commons-lang3\3.3.2\commons-lang3-3.3.2.jar;D:\m2\com\esotericsoftware\kryo\kryo\2.24.0\kryo-2.24.0.jar;D:\m2\com\esotericsoftware\minlog\minlog\1.2\minlog-1.2.jar;D:\m2\org\objenesis\objenesis\2.1\objenesis-2.1.jar;D:\m2\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;D:\m2\org\apache\commons\commons-compress\1.18\commons-compress-1.18.jar;D:\m2\org\apache\flink\flink-shaded-guava\18.0-6.0\flink-shaded-guava-18.0-6.0.jar;D:\m2\org\slf4j\slf4j-api\1.7.15\slf4j-api-1.7.15.jar;D:\m2\com\google\code\findbugs\jsr305\1.3.9\jsr305-1.3.9.jar;D:\m2\org\apache\flink\force-shading\1.8.1\force-shading-1.8.1.jar;D:\m2\org\apache\flink\flink-streaming-scala_2.11\1.8.1\flink-streaming-scala_2.11-1.8.1.jar;D:\m2\org\apache\flink\flink-streaming-java_2.11\1.8.1\flink-streaming-java_2.11-1.8.1.jar;D:\m2\org\apache\flink\flink-runtime_2.11\1.8.1\flink-runtime_2.11-1.8.1.jar;D:\m2\org\apache\flink\flink-queryable-state-client-java_2.11\1.8.1\flink-queryable-state-client-java_2.11-1.8.1.jar;D:\m2\org\apache\flink\flink-hadoop-fs\1.8.1\flink-hadoop-fs-1.8.1.jar;D:\m2\commons-io\commons-io\2.4\commons-io-2.4.jar;D:\m2\org\apache\flink\flink-shaded-netty\4.1.32.Final-6.0\flink-shaded-netty-4.1.32.Final-6.0.jar;D:\m2\org\apache\flink\flink-shaded-jackson\2.7.9-6.0\flink-shaded-jackson-2.7.9-6.0.jar;D:\m2\commons-cli\commons-cli\1.3.1\commons-cli-1.3.1.jar;D:\m2\org\javassist\javassist\3.19.0-GA\javassist-3.19.0-GA.jar;D:\m2\com\typesafe\akka\akka-actor_2.11\2.4.20\akka-actor_2.11-2.4.20.jar;D:\m2\com\typesafe\config\1.3.0\config-1.3.0.jar;D:\m2\org\scala-lang\modules\scala-java8-compat_2.11\0.7.0\scala-java8-compat_2.11-0.7.0.jar;D:\m2\com\typesafe\akka\akka-stream_2.11\2.4.20\akka-stream_2.11-2.4.20.jar;D:\m2\org\reactivestreams\reactive-streams\1.0.0\reactive-streams-1.0.0.jar;D:\m2\com\typesafe\ssl-config-core_2.11\0.2.1\ssl-config-core_2.11-0.2.1.jar;D:\m2\com\typesafe\akka\akka-protobuf_2.11\2.4.20\akka-protobuf_2.11-2.4.20.jar;D:\m2\com\typesafe\akka\akka-slf4j_2.11\2.4.20\akka-slf4j_2.11-2.4.20.jar;D:\m2\org\clapper\grizzled-slf4j_2.11\1.3.2\grizzled-slf4j_2.11-1.3.2.jar;D:\m2\com\github\scopt\scopt_2.11\3.5.0\scopt_2.11-3.5.0.jar;D:\m2\com\twitter\chill_2.11\0.7.6\chill_2.11-0.7.6.jar;D:\m2\com\twitter\chill-java\0.7.6\chill-java-0.7.6.jar;D:\m2\org\apache\flink\flink-clients_2.11\1.8.1\flink-clients_2.11-1.8.1.jar;D:\m2\org\apache\flink\flink-optimizer_2.11\1.8.1\flink-optimizer_2.11-1.8.1.jar;D:\m2\org\apache\commons\commons-math3\3.5\commons-math3-3.5.jar;D:\m2\org\apache\flink\flink-scala_2.11\1.8.1\flink-scala_2.11-1.8.1.jar;D:\m2\org\apache\flink\flink-java\1.8.1\flink-java-1.8.1.jar;D:\m2\org\apache\flink\flink-shaded-asm-6\6.2.1-6.0\flink-shaded-asm-6-6.2.1-6.0.jar;D:\m2\org\scala-lang\scala-reflect\2.11.12\scala-reflect-2.11.12.jar;D:\m2\org\scala-lang\scala-library\2.11.12\scala-library-2.11.12.jar;D:\m2\org\scala-lang\scala-compiler\2.11.12\scala-compiler-2.11.12.jar;D:\m2\org\scala-lang\modules\scala-xml_2.11\1.0.5\scala-xml_2.11-1.0.5.jar;D:\m2\org\scala-lang\modules\scala-parser-combinators_2.11\1.0.4\scala-parser-combinators_2.11-1.0.4.jar;D:\m2\org\apache\flink\flink-connector-kafka_2.11\1.8.1\flink-connector-kafka_2.11-1.8.1.jar;D:\m2\org\apache\flink\flink-connector-kafka-base_2.11\1.8.1\flink-connector-kafka-base_2.11-1.8.1.jar;D:\m2\org\apache\kafka\kafka-clients\2.0.1\kafka-clients-2.0.1.jar;D:\m2\org\lz4\lz4-java\1.4.1\lz4-java-1.4.1.jar;D:\m2\org\xerial\snappy\snappy-java\1.1.7.1\snappy-java-1.1.7.1.jar;D:\m2\org\springframework\boot\spring-boot-starter\2.2.0.RELEASE\spring-boot-starter-2.2.0.RELEASE.jar;D:\m2\org\springframework\boot\spring-boot\2.2.0.RELEASE\spring-boot-2.2.0.RELEASE.jar;D:\m2\org\springframework\spring-context\5.2.0.RELEASE\spring-context-5.2.0.RELEASE.jar;D:\m2\org\springframework\boot\spring-boot-autoconfigure\2.2.0.RELEASE\spring-boot-autoconfigure-2.2.0.RELEASE.jar;D:\m2\org\springframework\boot\spring-boot-starter-logging\2.2.0.RELEASE\spring-boot-starter-logging-2.2.0.RELEASE.jar;D:\m2\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\m2\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\m2\org\apache\logging\log4j\log4j-to-slf4j\2.12.1\log4j-to-slf4j-2.12.1.jar;D:\m2\org\apache\logging\log4j\log4j-api\2.12.1\log4j-api-2.12.1.jar;D:\m2\org\slf4j\jul-to-slf4j\1.7.28\jul-to-slf4j-1.7.28.jar;D:\m2\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\m2\org\springframework\spring-core\5.2.0.RELEASE\spring-core-5.2.0.RELEASE.jar;D:\m2\org\springframework\spring-jcl\5.2.0.RELEASE\spring-jcl-5.2.0.RELEASE.jar;D:\m2\org\yaml\snakeyaml\1.25\snakeyaml-1.25.jar;D:\m2\org\springframework\boot\spring-boot-starter-web\2.2.0.RELEASE\spring-boot-starter-web-2.2.0.RELEASE.jar;D:\m2\org\springframework\boot\spring-boot-starter-json\2.2.0.RELEASE\spring-boot-starter-json-2.2.0.RELEASE.jar;D:\m2\com\fasterxml\jackson\core\jackson-databind\2.10.0\jackson-databind-2.10.0.jar;D:\m2\com\fasterxml\jackson\core\jackson-annotations\2.10.0\jackson-annotations-2.10.0.jar;D:\m2\com\fasterxml\jackson\core\jackson-core\2.10.0\jackson-core-2.10.0.jar;D:\m2\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.10.0\jackson-datatype-jdk8-2.10.0.jar;D:\m2\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.10.0\jackson-datatype-jsr310-2.10.0.jar;D:\m2\com\fasterxml\jackson\module\jackson-module-parameter-names\2.10.0\jackson-module-parameter-names-2.10.0.jar;D:\m2\org\springframework\boot\spring-boot-starter-tomcat\2.2.0.RELEASE\spring-boot-starter-tomcat-2.2.0.RELEASE.jar;D:\m2\org\apache\tomcat\embed\tomcat-embed-core\9.0.27\tomcat-embed-core-9.0.27.jar;D:\m2\org\apache\tomcat\embed\tomcat-embed-el\9.0.27\tomcat-embed-el-9.0.27.jar;D:\m2\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.27\tomcat-embed-websocket-9.0.27.jar;D:\m2\org\springframework\boot\spring-boot-starter-validation\2.2.0.RELEASE\spring-boot-starter-validation-2.2.0.RELEASE.jar;D:\m2\jakarta\validation\jakarta.validation-api\2.0.1\jakarta.validation-api-2.0.1.jar;D:\m2\org\hibernate\validator\hibernate-validator\6.0.17.Final\hibernate-validator-6.0.17.Final.jar;D:\m2\org\jboss\logging\jboss-logging\3.3.2.Final\jboss-logging-3.3.2.Final.jar;D:\m2\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;D:\m2\org\springframework\spring-web\5.2.0.RELEASE\spring-web-5.2.0.RELEASE.jar;D:\m2\org\springframework\spring-beans\5.2.0.RELEASE\spring-beans-5.2.0.RELEASE.jar;D:\m2\org\springframework\spring-webmvc\5.2.0.RELEASE\spring-webmvc-5.2.0.RELEASE.jar;D:\m2\org\springframework\spring-aop\5.2.0.RELEASE\spring-aop-5.2.0.RELEASE.jar;D:\m2\org\springframework\spring-expression\5.2.0.RELEASE\spring-expression-5.2.0.RELEASE.jar;D:\m2\mysql\mysql-connector-java\5.1.18\mysql-connector-java-5.1.18.jar;D:\m2\org\springframework\boot\spring-boot-starter-jdbc\2.2.0.RELEASE\spring-boot-starter-jdbc-2.2.0.RELEASE.jar;D:\m2\com\zaxxer\HikariCP\3.4.1\HikariCP-3.4.1.jar;D:\m2\org\springframework\spring-jdbc\5.2.0.RELEASE\spring-jdbc-5.2.0.RELEASE.jar;D:\m2\org\springframework\spring-tx\5.2.0.RELEASE\spring-tx-5.2.0.RELEASE.jar;D:\m2\org\apache\flink\flink-queryable-state-runtime_2.12\1.8.1\flink-queryable-state-runtime_2.12-1.8.1.jar com.jy.testMysql.TestOnce
testMysql:com.jy.testMysql.TestMySQL@6e2c634b
round:1.0
round:1.0
round:1.0
round:1.0
3.数据库结果
完事!!!