JDBC编写及编写过程

先导入java.sql包

加载并注册驱动程序

Class.forName(driverClass)
//加载MySql驱动
Class.forName("com.mysql.jdbc.Driver")
//加载Oracle驱动
Class.forName("oracle.jdbc.driver.OracleDriver")

创建connection对象获得数据库连接

Connection conn = DriverManager.getConnection(url,"root","root");

创建statement/prepareStatement对象

//conn.createStatement();
//conn.prepareStatement(sql);
PreparedStatement pstmtment = conn.prepareStatement(sql);

执行SQL语句

ResultSet result = pst.executeQuery();

使用resultset对象想了解resultset方面的知识可以去

ResultSet用法集锦_leefang_cvic的博客-CSDN博客_resultset

if (result.next()){
            int cid = result.getInt("cid");
            String comname = result.getString("comname");
            String comprice = result.getString("comprice");
            String complace = result.getString("complace");
            String period = result.getString("period");
            String commid = result.getString("commid");
//            System.out.println(commid+"  "+comname+"  "+comprice + "  "+complace + " "
//            + period+"  "+commid);
            Com user = new Com(cid,comname,comprice,complace,period,commid);
            use=user;
        }else {
            System.out.println("没有商品");
        }

以下是测试类全部代码

package Sqljdbc;

import java.sql.*;
import java.util.Arrays;
import java.util.Scanner;

import java.sql.DriverManager;

public class Brand {

    private static String DRIVER = "com.mysql.jdbc.Driver";
    private static String URL = "jdbc:mysql:///workplan";
    private static String UNAME = "root";
    private static String PWD = "root";
    private static Connection CONN = null;
    private static Scanner sc = new Scanner(System.in);
    private static Com use= null;

    public static Connection getConnection(){
        try{
        Class.forName(DRIVER);
        CONN = DriverManager.getConnection(URL,UNAME,PWD);
        } catch (Exception e){
            e.printStackTrace();
        }
        return CONN;
    }

    public static void addbrand(String sql) throws Exception{
        PreparedStatement pst = CONN.prepareStatement(sql);
        int i = pst.executeUpdate();
        System.out.println(i);
        pst.close();
        CONN.close();
    }

    public static void updatabrand(String sql2) throws Exception{
        PreparedStatement pst = CONN.prepareStatement(sql2);
        int i = pst.executeUpdate();
        System.out.println(i);
        pst.close();
        CONN.close();
    }

    public static void deletebrand(String sql3) throws Exception{
        PreparedStatement pst = CONN.prepareStatement(sql3);
        int i = pst.executeUpdate();
        System.out.println(i);
        pst.close();
        CONN.close();
    }

    public static void selectbrand(int i) throws Exception{
        String sql = "SELECT * FROM commplany WHERE commid = ?";
        PreparedStatement pst = CONN.prepareStatement(sql);
        pst.setInt(1,i);
        ResultSet result = pst.executeQuery();
        if (result.next()){
            int cid = result.getInt("cid");
            String comname = result.getString("comname");
            String comprice = result.getString("comprice");
            String complace = result.getString("complace");
            String period = result.getString("period");
            String commid = result.getString("commid");
//            System.out.println(commid+"  "+comname+"  "+comprice + "  "+complace + " "
//            + period+"  "+commid);
            Com user = new Com(cid,comname,comprice,complace,period,commid);
            use=user;
        }else {
            System.out.println("没有商品");
        }
        System.out.println(use);
        result.close();
        pst.close();
        CONN.close();
    }

    public static void main(String[] args) throws Exception {
        System.out.println("新增商品");
        String sql = "INSERT INTO commplany VALUES (4,'牛肉','70','山东','6',1)";
        System.out.println("修改价格");
        String sql2 = "UPDATE commplany SET comprice = 60 WHERE comname = '牛肉'";
        getConnection();

        System.out.println("删除");
        String sql3="DELETE FROM commplany WHERE comname = '牛肉' ";

        System.out.println("输入商品编号查看商品");
        int i = sc.nextInt();
        selectbrand(i);
//        deletebrand(sql3);
//        addbrand(sql);
//        updatabrand(sql2);
    }
}