JDBC建立数据库连接的代码

本文实例为大家分享了JDBC建立数据库连接的具体代码，供大家参考，具体内容如下

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;

public class Test {
 public static void main(String[] args) {

//声明Connection对象
   Connection conn = null;
   PreparedStatement preparedStatement = null;
   ResultSet resultSet = null;
   //驱动程序名
   String driver = "com.mysql.jdbc.Driver";
   //用户名
   String user = "root";
   //密码
   String password = "1234";
   //url
   String url = "jdbc:mysql://localhost:3306/db_person";

try {
     String sql = "SELECT * FROM student";
     //1.加载驱动
     Class.forName(driver);
     //2.获得connect连接
     conn = (Connection) DriverManager.getConnection(url, user, password);
     //3.获得PreparedStatement
     preparedStatement = (PreparedStatement) conn.prepareStatement(sql);
     //4.获得结果集
     resultSet = preparedStatement.executeQuery();

while(resultSet.next()) {
       int id = resultSet.getInt(1);
       String name = resultSet.getString(2);
       String sex = resultSet.getString(3);
       int age = resultSet.getInt(4);

System.out.println(id +" "+ name + " " + sex + " " + age);
     }

} catch (Exception e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   }finally {
     if(resultSet != null) {
       try {
         resultSet.close();
       } catch (SQLException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
       }
     }

if(preparedStatement != null) {
       try {
         preparedStatement.close();
       } catch (SQLException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
       }
     }

if(conn != null) {
       try {
         conn.close();
       } catch (SQLException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
       }
     }

}
 }
}

来源：http://www.cnblogs.com/SkyeAngel/p/7864823.html