package study.example.demofx;
import javafx.fxml.FXML;
import cn.hutool.json.JSONUtil;
import javafx.scene.control.Label;
import javafx.scene.control.TextField;
import study.example.demofx.Class_Car.HttpClient;
import study.example.demofx.Class_Car.HttpOil;
import study.example.demofx.DBHelper.DBHelper;
import study.example.demofx.Oil.Oil_price;
import study.example.demofx.Weather.Weather;
import study.example.demofx.data.Phone;
import java.sql.Connection;
import java.sql.ResultSet;
public class HelloController {
@FXML
private Label carText;
@FXML
private TextField carTextField;
@FXML
private Label Text;
@FXML
private TextField oilField;
@FXML
private Label oilText;
@FXML
private Label oiladdText;
@FXML
private TextField weatherField;
@FXML
private Label weatherText;
@FXML
private Label addweatherText;
@FXML
protected void oncarButton() {
String number = carTextField.getText();
String dbUser = "root";
String dbPassword = "1234";
String dbName = "number";
String connUrl = "jdbc:mysql://localhost:3306/" + dbName + "?useUnicode=true&useSSL=false";
Connection conn = DBHelper.getMySQLConnection(connUrl, dbUser, dbPassword);
String sqlQuery = "select * from carnumber where abbreviation='" + number + "'";//读取数据
ResultSet rs = DBHelper.executQuery(conn, sqlQuery);
String msg = "";
try {
int i = 0;
while (rs.next()) {
i++;
String Abbreviation = rs.getString("province");
String addcity = rs.getString("city");
String abbreviation = rs.getString("abbreviation");
msg += "车牌号码归属:" + Abbreviation + "\n城市位置:" + addcity + "\n车牌号码:" + abbreviation;
carText.setText(msg);
String car = "查询成功!";
Text.setText(car);
}
if (i == 0) {
String url = "https://qqlykm.cn/api/plateNumber/?key=fIXKxATkWPpyhgDLU8anZ6Bbrv&word=" + number;
String data = HttpClient.get(url);
Phone phone = JSONUtil.toBean(data, Phone.class);
String CarNumber = "车牌号码归属:" + phone.getData().getProvince() + "\n城市位置:" + phone.getData().getCity() + "\n车牌号码:" + phone.getData().getAbbreviation();
carText.setText(CarNumber);
String sqlInsert = "insert into carnumber (province,city,abbreviation) values ('" + phone.getData().getProvince() + "','" + phone.getData().getCity() + "','" + phone.getData().getAbbreviation() + "')";
DBHelper.excuteUpdate(conn, sqlInsert);
String addcar = "从网络接口查询的车牌添加到本地中";
Text.setText(addcar);
}
} catch (Exception e) {
e.printStackTrace();
String car = "没有该车牌号";
Text.setText(car);
}
}
@FXML
protected void onOilButton() {
String oil = oilField.getText();
String dbUser = "root";
String dbPassword = "1234";
String dbName = "number";
String connUrl = "jdbc:mysql://localhost:3306/" + dbName + "?useUnicode=true&useSSL=false";
Connection conn = DBHelper.getMySQLConnection(connUrl, dbUser, dbPassword);
String sqlQuery = "select * from oil where province='" + oil + "'";//读取数据
ResultSet rs = DBHelper.executQuery(conn, sqlQuery);
String msg = "";
try {
int i = 0;
while (rs.next()) {
i++;
String province = rs.getString("province");
Double p0 = rs.getDouble("p0");
Double p89 = rs.getDouble("p89");
Double p92 = rs.getDouble("p92");
Double p95 = rs.getDouble("p95");
msg += "当前省份:" + province + "\n0号柴油:" + p0 + "元\n89号汽油:" + p89 + "元\n92号汽油:" + p92 + "元\n95号汽油;" + p95+"元";
oilText.setText(msg);
String car = "查询成功!";
oiladdText.setText(car);
}
if (i == 0) {
String url = "https://qqlykm.cn/api/oilprice/get?key=fIXKxATkWPpyhgDLU8anZ6Bbrv&name=" + oil;
String data = HttpOil.get(url);
Oil_price oil_price = JSONUtil.toBean(data, Oil_price.class);
String CarNumber = "当前省份:" + oil_price.getProvince() + "\n0号柴油:" + oil_price.getData().getP0() + "元\n89号汽油:" + oil_price.getData().getP89() + "元\n92号汽油:" + oil_price.getData().getP92() + "元\n95号汽油:" + oil_price.getData().getP95();
oilText.setText(CarNumber);
String sqlInsert = "insert into oil (province,p0,p89,p92,p95) values ('" + oil_price.getProvince() + "','" + oil_price.getData().getP0() + "','" + oil_price.getData().getP89() + "','" + oil_price.getData().getP92() + "','" + oil_price.getData().getP95() + "')";
DBHelper.excuteUpdate(conn, sqlInsert);
String addcar = "从网络接口查询的油价添加到本地中";
oiladdText.setText(addcar);
}
} catch (Exception e) {
e.printStackTrace();
String car = "没有该油价";
oiladdText.setText(car);
}
}
@FXML
protected void onWeatherBUtton() {
String weather_City = weatherField.getText();
String dbUser = "root";
String dbPassword = "1234";
String dbName = "number";
String connUrl = "jdbc:mysql://localhost:3306/" + dbName + "?useUnicode=true&useSSL=false";
Connection conn = DBHelper.getMySQLConnection(connUrl, dbUser, dbPassword);
String sqlQuery = "select * from weather where areaName='" + weather_City + "' " ;//读取数据
ResultSet rs = DBHelper.executQuery(conn, sqlQuery);
String msg = "";
try {
int i = 0;
while (rs.next()) {
i++;
String province = rs.getString("province");
String city = rs.getString("city");
String areaName = rs.getString("areaName");
String temperature = rs.getString("temperature");
String weather = rs.getString("weather");
String RainDescribe = rs.getString("RainDescribe");
int aqi = rs.getInt("aqi");
String aqiLevelInfo = rs.getString("aqiLevelInfo");
msg += "当前省份:" + province + "\n当前市:" + city + "\n县或区名:" + areaName + "\n当前温度:" + temperature + "°\n当前天气;" + weather + "\n天气说明:" + RainDescribe + "\n空气指数:" + aqi + "\n空气质量:" + aqiLevelInfo;
weatherText.setText(msg);
String car = "查询成功!";
addweatherText.setText(car);
}
if (i == 0) {
String url = "https://qqlykm.cn/api/weatherv2/get?key=fIXKxATkWPpyhgDLU8anZ6Bbrv&city=" + weather_City;
String data = HttpClient.get(url);
Weather weather = JSONUtil.toBean(data, Weather.class);
String CarNumber = "当前省份:" + weather.getData().getProvince() + "\n当前市:" + weather.getData().getCity() + "\n县或区名:" + weather.getData().getAreaName() + "\n当前温度:" + weather.getData().getRealtime().getTemp() + "°\n当前天气:" + weather.getData().getRealtime().getWeather() + "\n天气说明:" + weather.getData().getRealtime().getRainDescribe() + "\n空气指数:" + weather.getData().getRealtime().getAqi() + "\n空气质量:" + weather.getData().getRealtime().getAqiLevelInfo();
weatherText.setText(CarNumber);
String sqlInsert = "ins
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
MYSQL基于JAVAFX的查询应用程序。是 OSCHINA 推出的基于 Git 的代码托管平台(同时支持 SVN)。专为开发者提供稳定、高效、安全的云端软件开发协作平台 无论是个人、团队、或是企业,都能够用 Gitee 实现代码托管、项目管理、协作开发
资源推荐
资源详情
资源评论
收起资源包目录
mysql-is-based-on---javafx-master.zip (57个子文件)
mysql-is-based-on---javafx-master
demofx
pom.xml 3KB
src
main
resources
study
example
demofx
hello-view.fxml 2KB
java
module-info.java 732B
study
example
demofx
DBHelper
DBHelper.java 3KB
data
Phone.java 1KB
Data.java 790B
Weather
Weather.java 571B
Realtime.java 1KB
Hourlyweather.java 767B
Data.java 1KB
Class_Car
HttpClient.java 2KB
HttpOil.java 2KB
HelloController.java 9KB
Oil
Oil_price.java 981B
Data.java 829B
HelloApplication.java 664B
demofx.iml 2KB
.idea
jarRepositories.xml 864B
codeStyles
codeStyleConfig.xml 153B
libraries
Maven__org_openjfx_javafx_graphics_11_0_2.xml 563B
Maven__org_openjfx_javafx_base_11_0_2.xml 535B
Maven__org_junit_jupiter_junit_jupiter_api_5_8_1.xml 594B
Maven__org_junit_jupiter_junit_jupiter_engine_5_8_1.xml 615B
mysql_connector_java.xml 363B
Maven__org_openjfx_javafx_controls_11_0_2.xml 563B
Maven__org_openjfx_javafx_graphics_win_11_0_2.xml 571B
Maven__org_openjfx_javafx_fxml_11_0_2.xml 535B
Maven__org_openjfx_javafx_base_win_11_0_2.xml 543B
Maven__org_junit_platform_junit_platform_commons_1_8_1.xml 633B
Maven__org_opentest4j_opentest4j_1_2_0.xml 533B
Maven__org_junit_platform_junit_platform_engine_1_8_1.xml 626B
Maven__org_apiguardian_apiguardian_api_1_1_2.xml 572B
Maven__org_openjfx_javafx_fxml_win_11_0_2.xml 543B
cn_hutool_all.xml 334B
Maven__org_openjfx_javafx_controls_win_11_0_2.xml 571B
workspace.xml 7KB
misc.xml 464B
compiler.xml 638B
modules.xml 259B
.gitignore 190B
encodings.xml 352B
target
classes
module-info.class 569B
study
example
demofx
HelloApplication.class 1KB
DBHelper
DBHelper.class 3KB
data
Phone.class 1KB
Data.class 939B
hello-view.fxml 2KB
Weather
Realtime.class 1KB
Data.class 2KB
Hourlyweather.class 957B
Weather.class 813B
Class_Car
HttpClient.class 3KB
HttpOil.class 3KB
HelloController.class 9KB
Oil
Oil_price.class 1KB
Data.class 1KB
generated-sources
annotations
.keep 0B
共 57 条
- 1
资源评论
Java程序员-张凯
- 粉丝: 1w+
- 资源: 6705
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 基于JavaScript和CSS的随寻订购网页设计源码 - web-order
- 基于MATLAB的声纹识别系统设计源码 - VoiceprintRecognition
- 基于Java的微服务插件集合设计源码 - wsy-plugins
- 基于Vue和微信小程序的监理日志系统设计源码 - supervisionLog
- 基于Java和LCN分布式事务框架的设计源码 - tx-lcn
- 基于Java和JavaScript的茶叶评级管理系统设计源码 - tea
- IMG_5680.JPG
- IMG_0437.jpg
- 基于Java的JAVA项目分析工具设计源码 - JAVAProjectAnalysis
- top888.json
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功