欢迎使用CSDN-markdown编辑器

来源：互联网发布：能至网络瘫痪的攻击编辑：程序博客网时间：2024/05/22 14:33

java 使用jdbc新建数据库

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

    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();        }        createTestBankTable();    }    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