java使用jdbc创建新的数据库

最新推荐文章于 2022-04-26 20:59:42 发布

思善

最新推荐文章于 2022-04-26 20:59:42 发布

阅读量393

点赞数

分类专栏： java 文章标签： java mysql 数据库

本文链接：https://blog.csdn.net/forest43838482/article/details/50437923

版权

java 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

在网上找了好久java如何使用jdbc创建新的数据库,好多都说不能创建，要在mysql里面创建好数据库，用jdbc直接connect;
自己实验了一下，发现是可以创建的，现在和大家分享一下

public class testDatabase {
    public static final String URL = "jdbc:mysql://localhost:3306/";
    public static final String USER = "root";
    public static final String PASSWORD = "123456";
    private static Connection conn = null;
    private static Statement statement = null;
    public  testDatabase(String databaseName)
    {
        String urlName = URL+databaseName;
        try {
            Class.forName("com.mysql.jdbc.Driver");     
            System.out.println(urlName);

            connectDatabase(urlName+"?useUnicode=true&characterEncoding=gbk");              
        }catch (SQLSyntaxErrorException se) {
            System.out.println("connectDatabase error code: "+se.getErrorCode()+"\n");
            if(1049 == se.getErrorCode())
            {
                try {
                    connectDatabase(URL);
                    statement.executeUpdate("create database " + databaseName + " character set gbk");
                    statement.executeUpdate("use " + databaseName);
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }catch (Exception e) {
            e.printStackTrace();
        }
    }
    private void connectDatabase(String databaseUrl) throws SQLException
    {
        System.out.println("databaseUrl: "+databaseUrl+"\n");
        conn = (Connection) DriverManager.getConnection(databaseUrl, USER, PASSWORD);
        System.out.println("connect database success!\n");

        statement = (Statement) conn.createStatement();
        System.out.println("connect statement success!\n");
    }
}