- package com.***.www.test;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.Properties;
- public class JDBCDriver {
- private static Connection conn;
- private static PreparedStatement ps;
- private static ResultSet rs ;
- public static void main(String[] args) {
- try {
- DriverManager.registerDriver(new com.mysql.embedded.jdbc.MySqlEmbeddedDriver());
- //mysql为你要连接的database,必须保证data里面存在这个database
- String url = "jdbc:mysql-embedded/mysql";
- Properties props = new Properties();
- //以下为一些配置,建议写到配置文件中方便修改
- props.put("library.path", "mysql/lib/");
- props.put("--datadir", "/mysql/data");
- props.put("--basedir","/mysql/");
- props.put("--default-character-set","utf8");
- props.put("--default-collation","utf8_general_ci");
- DriverManager.getDriver(url);
- conn = DriverManager.getConnection(url,props);
- String sql = "show tables;";
- ps = conn.prepareStatement(sql);
- rs = ps.executeQuery();
- while(rs.next())
- {
- System.out.println(rs.getString(1));
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- finally
- {
- //关闭rs,ps,conn
- }
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/2110201410738.html
来源: http://www.codesnippet.cn/detail/2110201410738.html