JAVA连接MYSQL配置

来源:互联网 发布:龙华数据恢复 编辑:程序博客网 时间:2024/06/08 15:36
mysql-connector-java-5.0.4-bin解压后里面有一个mysql-connector-java-5.0.4-bin.jar的文件,把此文件复制到C:\Program Files\Java\jre1.5.0_11\lib\ext下
修改系统变量  ;C:\Program Files\Java\jdk1.5.0_11\bin


try {Class.forName("com.mysql.jdbc.Driver");String url = "jdbc:mysql://localhost/first?user=root&password=....1234";Connection connection = DriverManager.getConnection(url);Statement statement = connection.createStatement();ResultSet resultSet = statement.executeQuery("select * from test");while(resultSet.next()){System.out.print(resultSet.getString("name"));}statement.close();} catch (ClassNotFoundException | SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}


0 0