javaweb中mysql数据库连接步骤方法及其实例

一、直接连接，不封装到工具类中，主要步骤：

先导包:mysql-connector-java-5.0.8-bin.jar(点击跳转到下载界面),放在WEBRoot/WEB-INF/lib/下

加载驱动//com.Mysql.jdbc.Driver

获取连接 Connection对象

获取用于向数据库发送sql的Statement对象

执行sql,获取数据，解析数据

关闭连接，释放资源

Stringurl="jdbc:mysql://localhost:3306/jdbctest";//mysql数据库的用户名与密码，安装时自己设置，一般默认为rootStringuser="root";StringpassWord="root";Connectionconnection=null;Statementstatement=null;ResultSetresultSet=null;try{//1.加载驱动//com.mysql.jdbc.DriverClass.forName("com.mysql.jdbc.Driver");//2.获取连接connection=DriverManager.getConnection(url,user,password);//3.获取用于向数据库发送SQL的Statement对象statement=connection.createStatement();//4.执行sql,获取数据resultSet=statement.executeQuery("SELECT*FROMusers;");//解析数据while(resultSet.next()){intid=resultSet.getInt("id");Stringname=resultSet.getString("name");Stringpsd=resultSet.getString("password");Stringemail=resultSet.getString("email");Stringbirthday=resultSet.getString("birthday");System.out.println(id+""+name+""+psd+""+email+""+birthday);}}catch(ClassNotFoundExceptione){e.printStackTrace();}catch(SQLExceptione){e.printStackTrace();}finally{//5.关闭连接，释放资源if(resultSet!=null){try{resultSet.close();}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}resultSet=null;}if(statement!=null){try{statement.close();}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}statement=null;}if(connection!=null){try{connection.close();}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}connection=null;}String url = "jdbc:mysql://localhost:3306/jdbctest";// mysql数据库的用户名与密码，安装时自己设置，一般默认为rootString user = "root";String password = "root";Connection connection = null;Statement statement = null;ResultSet resultSet = null;try {  // 1.加载驱动//com.mysql.jdbc.Driver    Class.forName("com.mysql.jdbc.Driver");  // 2.获取连接  connection = DriverManager.getConnection(url, user, password);  // 3.获取用于向数据库发送SQL的Statement对象  statement = connection.createStatement();  // 4.执行sql,获取数据  resultSet = statement.executeQuery("SELECT * FROM users;");  // 解析数据  while (resultSet.next()) {int id = resultSet.getInt("id");String name = resultSet.getString("name");String psd = resultSet.getString("password");String email = resultSet.getString("email");String birthday = resultSet.getString("birthday");System.out.println(id + " " + name + " " + psd + " " + email+ " " + birthday);  }} catch (ClassNotFoundException e) {  e.printStackTrace();} catch (SQLException e) {  e.printStackTrace();} finally {     //5.关闭连接，释放资源  if (resultSet != null) {try {  resultSet.close();} catch (SQLException e) {  // TODO Auto-generated catch block  e.printStackTrace();}resultSet = null;  }  if (statement != null) {try {  statement.close();} catch (SQLException e) {  // TODO Auto-generated catch block  e.printStackTrace();}statement = null;  }  if (connection != null) {try {  connection.close();} catch (SQLException e) {  // TODO Auto-generated catch block  e.printStackTrace();}connection = null;  }}