Ubuntu install mysql-connector-java for java to connect MySQL database

来源:互联网 发布:数据库主键生成策略 编辑:程序博客网 时间:2024/06/06 02:22

Ubuntu install mysql-connector-java for java to connect MySQL database
1. Download mysql-connector-java from https://dev.mysql.com/downloads/connector/j/
2. Unzip mysql-connector-java-*.tar.gz
3. Copy mysql-connector-java-*-bin.jar to %JAVA_HOME%/jre/lib/ext/
4. Run the following test case:

Connection conn = null;String url = "jdbc:mysql://localhost/cookbook";String userName = "userName";String password = "password";try{    Class.forName("com.mysql.jdbc.Driver").newInstance();    conn = DriverManager.getConnection(url, userName, password);    System.out.println("Connected");}catch (Exception e){    System.err.println("Cannot connect to server");    System.exit(1);}if (conn != null){    try    {        conn.close();        System.out.println("Disconnected");    }    catch (Exception e)    { /* ignore close errors */ } }
阅读全文
0 0
原创粉丝点击