Question

Write a JAVA program to create a table named FoodItem that contains the following columns : ID (number), Name(varchar), calories(number).

Now create an insert statement to insert a record into this database table.

Finally using a select statement print the record that you entered into the database.

Answer 1

from the given questions list I am going to explain about each question in step wise manner.

let start the process:

step 1: first we have to connect database. step 2: now we have to create table using executeUpdate method(), and the java code will be like this:

 import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class CreateTableFoodItem { private static final String CREATE_TABLE_SQL="CREATE TABLE FoodItem (" + "ID INT," + " NAME VARCHAR," + "CALORIES NUMBER"); public static void main(String[] args) { String Url = "here address of database in your system"; String username = "username of your database"; string password = "password of your database"; connection conn = null; Statement stmt = null; try { conn = Driveranager.getConnection(url, username, password); stmt = conn.createStatement(); stmt.executeUpdate(CREATE_TABLE_SQL); System.out.println("table created"); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (stmt != null) { stmt.close(); } if (conn != null) { conn.close(); } } catch (Exception e) { e.printStackTrace(); } } }

now the table has been created in the database and the table will be look like this:

Field	Type
ID	INT
Name	VARCHAR
Calories	NUMBER

step 3: now let us see how to use INSERT statement to insert a record in the table.

NOTE: for every connection of database with java use this code

string url = "url of your database";
string username = "username of your database";
string password = "password of your database";

try (Connection conn = DriverManager.getConnection(url , username, password);
Statement stmt = conn.createStatement();

now the java code for INSERT statement is:

 String query = "insert into users(ID, Name, Calories)" + " values(?,?,?)"; PreparedStatement preparedStmt = conn.prepareStatement(query); preparedStmt.setString (1, 001); preparedStmt.setString (2, "IceCream"); preparedStmt.setString (3, 400); preparedStmt.execute(); conn.close(); } catch (Exception e) { System.err.println("Got an exception!"); System.err.println(e.getMessage()); }

step 4: now let us see how to use select statement to get the record that i entered into the database

the java code to select the record is:

 public static void main(string[] args) { string url = "url of your database"; string username = "username of your database"; string password = "password of your database"; string sql = "select * from Fooditem"; try (Connection conn = DriverManager.getConnection(url , username, password); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql):) { int row = 0; while (rs.next()) { System.out.println("row" + row); System.out.println("ID" + rs.getstring(1)); System.out.println("row" + rs.getstring(2)); System.out.println("row" + rs.getstring(3)); System.out.println(); } } catch (SQLException e) { e.printStackTrace(); } } } 

now the output for this code will be like this

ID	Name	Calories
001	Icecream	400

Hope you got the answer and please rate it.