PreparedStmt.java Source code

Introduction

Here is the source code for PreparedStmt.java

Source

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class PreparedStmt {
    public static void main(String args[]) throws Exception {

        String query = "SELECT * FROM Stock WHERE Item_Number = ?";
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con = DriverManager.getConnection("jdbc:odbc:Inventory");
        PreparedStatement pstmt = con.prepareStatement(query);
        pstmt.setInt(1, 2);
        ResultSet rs = pstmt.executeQuery();
        while (rs.next()) {
            String name = rs.getString("Name");
            String desc = rs.getString("Description");
            int qty = rs.getInt("Qty");
            float cost = rs.getFloat("Cost");
            System.out.println(name + ", " + desc + "\t: " + qty + "\t@ $" + cost);
        }
    }
}