java connect_ConnectMySQL.java

package week20;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class ConnectMySQL {

public static void main(String[] args) {

// JDBC的一些配置

String URL = "jdbc:mysql://localhost:3306/mysql2";

String driverName = "com.mysql.jdbc.Driver";

String sql = "select * from new_table";

String userName = "root";// root

String password = "123456";// 123456

Connection conn = null;

Statement statement = null;

ResultSet resultSet = null;

try {

Class.forName(driverName);// jdbc4.0 后无需使用这句进行驱动注册操作

conn = DriverManager.getConnection(URL, userName, password);

statement = conn.createStatement();

resultSet = statement.executeQuery(sql);

// id | name | gender | birthdate | politicalOutlook | familyLocate | phone | dormitoryNum

while (resultSet.next()) {

int id = resultSet.getInt("id");

String name = resultSet.getString("name");

String gender = resultSet.getString("gender");

String birthdate = resultSet.getString("birthdate");

String politicalOutlook = resultSet.getString("politicalOutlook");

String familyLocate = resultSet.getString("familyLocate");

int phone = resultSet.getInt("phone");

int dormitoryNum = resultSet.getInt("dormitoryNum");

System.out.print("[id=" + id + " name=" + name + " gender=" + gender+" birthdate="+ birthdate +" politicalOutlook="+politicalOutlook+" familyLocate="+familyLocate+" phone="+phone+" dormitoryNum="+dormitoryNum+"]");

}

} catch (SQLException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} finally {/*下面资源释放，可以使用try..with..resources语法简化*/

if (resultSet != null) {

try {

resultSet.close();

resultSet.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if (statement != null) {

try {

statement.close();

statement = null;

} catch (SQLException e) {

e.printStackTrace();

}

}

if (conn != null)

try {

conn.close();

conn = null;

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

一键复制

编辑

Web IDE

原始数据

按行查看

历史