JAVA JDBC手动创建表加字段亲测有效!

最新推荐文章于 2024-03-23 10:59:35 发布

有梦想的咸鱼.....

最新推荐文章于 2024-03-23 10:59:35 发布

阅读量581

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/weixin_56314079/article/details/125654973

版权

/**
 * 根据自己的MySQL版本选择
 * JDBC连接Mysql5：com.mysql.jdbc.Driver
 * JDBC连接Mysql6：com.mysql.cj.jdbc.Driver
 */
String driver = "com.mysql.cj.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/库名?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai";
String user = "root";
String password = "";
try {
    Class.forName(driver);
    Connection conn = DriverManager.getConnection(url, user, password);
    conn.setAutoCommit(false);
    SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
    String tablename = "表名" + sdf.format(new Date());//下面是字段名与类型
    String query = "CREATE TABLE " + tablename + "" + "(username varchar(50), password varchar(500))";
    PreparedStatement ps = conn.prepareStatement(query);
    //创建表要用 execute
    ps.execute();
    conn.commit();
    ps.close();
    conn.close();
} catch (Exception e) {
    e.printStackTrace();
}