java使用jdbc创建新的数据库

来源：互联网发布：超星阅览器 mac 编辑：程序博客网时间：2024/05/29 14:31

在网上找了好久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");    }}

0 0