JDBC建立数据库连接的代码

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();

http:// }

}

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();

}

}

}

}

}

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。