package com.zj.jdbc.demo;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import org.junit.jupiter.api.Test;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.Statement;

public class JDBCDemo {

@Test

public void demo() {

Connection connection = null;

Statement statement = null;

ResultSet resultSet = null;

try {

Class.forName("com.mysql.jdbc.Driver");//注册驱动

//获取链接

connection = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/test"+"?useUnicode=true&characterEncoding=utf-8","root","root");

String sql = "select * from goods where price < 3500";

statement = (Statement) connection.createStatement();

resultSet = statement.executeQuery(sql);//执行sql语句

while (resultSet.next()) {

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

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

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

float price = resultSet.getFloat("price");

System.out.println(id+" "+name+" "+price+" "+desp);

}

} catch (Exception e) {

e.printStackTrace();

} finally {

if (statement!=null) {

try {

statement.close();

} catch (SQLException e) {

e.printStackTrace();

}

statement = null;

}

if (connection!=null) {

try {

connection.close();

} catch (SQLException e) {

e.printStackTrace();

}

connection = null;

}

if (resultSet!=null) {

try {

resultSet.close();

} catch (SQLException e) {

e.printStackTrace();

}

resultSet = null;

}

}

}

}