简单的订单系统

AilingMin

已于 2022-04-14 13:37:19 修改

阅读量979

点赞数 2

文章标签： java intellij-idea mysql

于 2022-04-03 16:24:01 首次发布

本文链接：https://blog.csdn.net/Ailing_kildd/article/details/123939293

版权

一、数据库方面

USE foodmenu;
DROP TABLE IF EXISTS menu7;
CREATE TABLE menu7(
	num INT PRIMARY KEY,
	TypeDishes VARCHAR(255)

)CHARSET=utf8;
INSERT INTO menu7(num,TypeDishes) VALUES(1,'炒饭'),(2,'盖饭'),(3,'面食'),(4,'饮料');

USE foodmenu;
DROP TABLE IF EXISTS menu8;
CREATE TABLE menu8(
	num INT,
	Dishes VARCHAR(255)
)CHARSET=utf8;
INSERT INTO menu8(num,Dishes) VALUES(101,'蛋炒饭'),(102,'青椒炒肉丝'),(103,'鱼香肉丝');

USE foodmenu;
DROP TABLE IF EXISTS menu9;
CREATE TABLE menu9(
	num INT ,
	Dishes VARCHAR(255)
)CHARSET=utf8;
INSERT INTO menu9(num,Dishes) VALUES(111,'宫保鸡丁'),(112,'土豆肉丝'),(113,'怪味鸭');

USE foodmenu;
DROP TABLE IF EXISTS menu10;
CREATE TABLE menu10(
	num INT ,
	Dishes VARCHAR(255)
)CHARSET=utf8;
INSERT INTO menu10(num,Dishes) VALUES(121,'重庆小面'),(122,'牛肉面'),(123,'杂酱面');

USE foodmenu;
DROP TABLE IF EXISTS menu11;
CREATE TABLE menu11(
	num INT ,
	Dishes VARCHAR(255)
)CHARSET=utf8;
INSERT INTO menu11(num,Dishes) VALUES(131,'元气森林'),(132,'冰红茶'),(133,'可乐');

二、jdbc配置文件

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/foodmenu
user=root
password=123456

三、JDBC工具类

package com.xh.jdbc.menu2;

import java.sql.*;
import java.util.ResourceBundle;

/**
 * JDBC工具类
 */
public class DBUtil {
    //静态变量，类加载时执行
    //属性资源文件绑定
    private static ResourceBundle bundle = ResourceBundle.getBundle("resources.jdbc1");
    //根据属性配置文件key获取value
    private static String driver = bundle.getString("driver");
    private static String url = bundle.getString("url");
    private static String user = bundle.getString("user");
    private static String password = bundle.getString("password");

    static {//注册驱动，只需要注册一次就够了，放在静态代码块中，DBUtil类加载时执行
        try {
            Class.forName(driver);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    /**
     * 获取数据库连接对象
     * @return conn 连接对象
     * @throws SQLException
     */
    public static Connection getConnection()throws SQLException{
        Connection conn = DriverManager.getConnection(url,user,password);
        return conn;
    }

    /**
     * 释放资源
     * @param conn 连接对象
     * @param ps 数据库操作对象
     * @param rs 结果集对象
     */
    public static void close(Connection conn, Statement ps, ResultSet rs){
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (ps != null) {
            try {
                ps.close();
            } catch (SQLException e) {