myJDBC.java:

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import org.junit.Test;

import com.mysql.jdbc.Driver;

public class myJDBC {

@Test

public void demo1() throws Exception {

DriverManager.registerDriver(new Driver());

Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbctest?serverTimezone=GMT%2B8","root","xf@123");

String sql="select * from goods";

Statement stmt=conn.createStatement();

ResultSet resultset=stmt.executeQuery(sql);

while(resultset.next())

{

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

if(price>3500)

continue;

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

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

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

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

}

}

}

建表:

use jdbctest;

create table goods(

id int primary key auto_increment,

name varchar(20) not null,

price float not null,

desp varchar(30) not null

);

insert into goods(name,price,desp) values('手机',20000.0,"黑色,存储容量32G");

insert into goods(name,price,desp) values('冰箱',1500.0,"银色,对开门");

insert into goods(name,price,desp) values('洗衣机',3000.0,"滚筒");

insert into goods(name,price,desp) values('空调',4000,"变频空间");