jdbc链接mysql程序

来源：互联网发布：linux init 0 编辑：程序博客网时间：2024/04/29 13:45

数据库名为test，表名为user，表中的内容如下

工程中需要加入mysql驱动包 mysql-connector-java-5.1.25，下载地址：点击跳转

工程目录结构如下

代码如下

String driver="com.mysql.jdbc.Driver";String url="jdbc:mysql://localhost:3306/test";String user="root";String password="12345678";Connection connection=null;PreparedStatement preparedStatement=null;ResultSet resultSet=null;try {Class.forName(driver);connection=DriverManager.getConnection(url,user,password);String sql="select * from user";preparedStatement=connection.prepareStatement(sql);resultSet=preparedStatement.executeQuery();while(resultSet.next()){System.out.println("id:"+resultSet.getInt("id")+"--name:"+resultSet.getString("name")+"--password:"+resultSet.getString("password")+"--email;"+resultSet.getString("email"));}} catch (Exception e) {e.printStackTrace();}finally{if(resultSet!=null){try {resultSet.close();} catch (Exception e2) {e2.printStackTrace();}}if(preparedStatement!=null){try {preparedStatement.close();} catch (Exception e2) {e2.printStackTrace();}}if(connection!=null){try {connection.close();} catch (Exception e2) {e2.printStackTrace();}}}

结果如下

0 0