Java连接MySQL数据库并且执行建表和插入数据

最新推荐文章于 2024-05-07 10:00:00 发布

SDUT_wdc

最新推荐文章于 2024-05-07 10:00:00 发布

阅读量1.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： Java

本文链接：https://blog.youkuaiyun.com/SDUTACM/article/details/52120847

Java 专栏收录该内容

6 篇文章

订阅专栏

该Java程序演示了如何连接到MySQL数据库，检查表是否存在，如果不存在则创建表，并插入数据。程序使用`com.mysql.jdbc.Driver`进行连接，执行SQL语句包括创建表（包含id、filename等字段）和插入数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com.resumesplice;

import java.util.*;
import java.io.*;
import java.sql.Date;
import java.text.SimpleDateFormat;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class InsertIntoStep1 {
private static List<String> m_tableNameList = new ArrayList<String>();

public static boolean tableExist(String tableName) {
boolean result = false;
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.*.**/", "***", "****");
Statement stmt = conn.createStatement();

String sql = String.format("SELECT table_name FROM information_schema.TABLES WHERE table_name ='%s'", tableName);
ResultSet rs = stmt.executeQuery(sql);
result = rs.next();
stmt.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return result;
}

public static void InsertDB(String filename, String enter_myftp_time, String process_time, String extract, String assemble, String target) {
String currentTime = getCurrentTime();
String tableName = "step1_" + currentTime;

if (!m_tableNameList.contains(tableName)) {
if (!tableExist(tableName)) {
createtable(tableName);
}
m_tableNameList.add(tableName);
}

try {
Class.forName("com.mysql.jdbc.Driver");
//System.out.println("测试通过");
Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.6.65/filemyftpprocessinfo", "root", "root");
Statement stmt = conn.createStatement();
String sql = "insert into " + tableName + "(filename,enter_myftp_time,process_time,extract,assemble,target) values (" + '"' + filename + '"' + " , " + '"' + enter_myftp_time + '"' + " , " + '"' + process_time + '"' + " , " + '"' + extract + '"' + " , " + '"' + assemble + '"' + " , " + '"' + target + '"' + " );";
stmt.execute(sql);
stmt.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

public static void createtable(String tablename) {

try {
Class.forName("com.mysql.jdbc.Driver");
// System.out.println("测试通过");
Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.6.65/filemyftpprocessinfo", "root", "root");
Statement stmt = conn.createStatement();

String sql = "create table " + tablename + "(id int primary key auto_increment,filename varchar(255),enter_myftp_time varchar(20),process_time varchar(20),extract varchar(1),assemble varchar(1),target varchar(255))";
stmt.execute(sql);

stmt.close();
conn.close();

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

public static void main(String[] args) {
// TODO Auto-generated method stub

}

public static String getCurrentTime() {
SimpleDateFormat df = new SimpleDateFormat("yyyyMMdd");
return df.format(System.currentTimeMillis());
}

}