感兴趣的小伙伴可以先看看我的这篇文章哦,打开看看,说不定能帮到你一些~~
编写一个 JDBC 的使用程序,对商品表 gds_goods 进行操作,要求
1.使用 statement
显示全部表中记录
向商品表中增加一种数据
然后更改这一条商品信息
使用键盘输入序号的方式,删除这一条商品信息
实现代码:
package com.zhangyufan.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
public class TestJdbcGoodsQuery {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/zyf";
Connection conn = DriverManager.getConnection(url, "root", "root");
System.out.println("联接成功");
Statement st = conn.createStatement();
System.out.println("--------------------显示全部表中记录--------------------");
String sql = "select * from gds_goods";
ResultSet rs = st.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getInt("gds_id") + "\t" + rs.getString("gds_no") + "\t" + rs.getString("gds_name")
+ "\t" + rs.getDouble("gds_price") + "\t" + rs.getString("gds_memo"));
}
System.out.println("--------------------向商品表中增加一种数据--------------------");
sql = "insert into gds_goods(gds_no,gds_name,gds_price) values('300','printer',500)";
int result = st.executeUpdate(sql);
System.out.println("插入记录数是:" + result);
System.out.println("--------------------更改这一条商品信息--------------------");
Scanner sc = new Scanner(System.in);
System.out.println("请输入想要修改的商品序号:");
int gds_id = sc.nextInt();
sql = "select * from gds_goods where gds_id=" + gds_id;
rs = st.executeQuery(sql);
if (rs.next()) {
System.out.println("将要修改的商品内容是:");
System.out.println("商品编号:" + rs.getString("gds_no"));
System.out.println("商品名称:" + rs.getString("gds_name"));
System.out.println("商品单价:" + rs.getString("gds_price"));
} else {
System.out.println("输入的商品序号有错!");
return;
}
System.out.println("------------------------------");
System.out.println("请输入要修改的商品信息的编号:");
String gds_no = sc.next();
System.out.println("请输入要修改的商品信息的名称:");
String gds_name = sc.next();
System.out.println("请输入要修改的商品信息的单价:");
double gds_price = sc.nextDouble();
sql = "update gds_goods set gds_no='" + gds_no + "',";
sql += "gds_name='" + gds_name + "',";
sql += "gds_price=" + gds_price;
sql += "where gds_id=" + gds_id;
result = st.executeUpdate(sql);
if (result > 0) {
System.out.println("更新成功!");
} else {
System.out.println("更新不成功!");
}
System.out.println("--------------------使用键盘输入序号的方式,删除这一条商品信息--------------------");
System.out.println("请输入想要删除的商品序号:");
gds_id = sc.nextInt();
sql = "select * from gds_goods where gds_id=" + gds_id;
rs = st.executeQuery(sql);
if (rs.next()) {
System.out.println("将要删除的商品内容是:");
System.out.println("商品编号:" + rs.getString("gds_no"));
System.out.println("商品名称:" + rs.getString("gds_name"));
System.out.println("商品单价:" + rs.getString("gds_price"));
} else {
System.out.println("输入的商品序号有错!");
return;
}
System.out.println("------------------------------");
sql = "delete from gds_goods where gds_id=" + gds_id;
result = st.executeUpdate(sql);
if (result > 0) {
System.out.println("删除成功!");
} else {
System.out.println("删除不成功!");
}
rs.close();
st.close();
conn.close();
}
}
运行结果:
1.显示全部表中记录。
2.向商品表中增加一种数据。
3.然后更改这一条商品信息。
4.使用键盘输入序号的方式,删除这一条商品信息。