Programming In Java Week 11: Programming Assignments Jan-Jun 2022

  NPTEL PROGRAMMING ASSIGNMENTS

Programming In Java

Week 11 : Programming Assignment 1

Due Date of Submission 2022-04-14, 23:59 IST

Complete the code segment to insert the following data using prepared statement in the existing table ‘PLAYERS’.

Column	UID	First_Name	Last_Name	Age
Row 1	1	Ram	Gopal	26
Row 2	2	John	Mayer	22

--Solution-- 

  String que = " insert into PLAYERS (UID, first_name, last_name, age)" + " values (?, ?, ?, ?)"; PreparedStatement preparedStmt = conn.prepareStatement(que); preparedStmt.setInt (1, 1); preparedStmt.setString (2, "Ram"); preparedStmt.setString (3, "Gopal"); preparedStmt.setInt(4, 26); preparedStmt.execute(); preparedStmt.setInt (1, 2); preparedStmt.setString (2, "John"); preparedStmt.setString (3, "Mayer"); preparedStmt.setInt(4, 22); preparedStmt.execute();

            }catch(Exception e){ System.out.println(e);}  

}  

}

Week 11 : Programming Assignment 2

Due Date of Submission 2022-04-14, 23:59 IST

Write the required code in order to update the following data in the table ‘PLAYERS’.

Column	UID	First_Name	Last_Name	Age
From	1	Ram	Gopal	26
To	1	Rama	Gopala	24

--Solution-- 

  String sq1 = "UPDATE PLAYERS " + "SET Age = 24 WHERE UID == 1"; stmt.executeUpdate(sq1); String sq2 = "UPDATE PLAYERS " + "SET Last_Name = 'Gopala' WHERE UID == 1"; stmt.executeUpdate(sq2); String sq3 = "UPDATE PLAYERS " + "SET First_Name = 'Rama' WHERE UID == 1"; stmt.executeUpdate(sq3);

                  }

                catch(Exception e){ System.out.println(e);}  

}  

}  

Week 11 : Programming Assignment 3

Due Date of Submission 2022-04-14, 23:59 IST

Write the appropriate code in order to delete the following data in the table ‘PLAYERS’.

Column	UID	First_Name	Last_Name	Age
Delete	1	Rama	Gopala	24

--Solution-- 

  // Execute the command in order to delete a row from the table String sq1 = "DELETE FROM PLAYERS " +"WHERE UID == 1"; stmt.executeUpdate(sq1);

                }

                catch(Exception e){ System.out.println(e);}  

}  

}  

Week 11 : Programming Assignment 4

Due Date of Submission 2022-04-14, 23:59 IST

Complete the following program to calculate the average age of the players in the table ‘PLAYERS’.

Structure of Table 'PLAYERS' is given below:

Column	UID	First_Name	Last_Name	Age
Type	Integer	Varchar(45)	Varchar(45)	Integer

--Solution-- 

  preparedStmt.setInt (1, 1); preparedStmt.setString (2, "Rama"); preparedStmt.setString (3, "Gopala"); preparedStmt.setInt(4, 24); preparedStmt.execute(); preparedStmt.setInt (1, 2); preparedStmt.setString (2, "John"); preparedStmt.setString (3, "Mayer"); preparedStmt.setInt(4, 22); preparedStmt.execute(); preparedStmt.setInt (1, 3); preparedStmt.setString (2, "Leo"); preparedStmt.setString (3, "Martin"); preparedStmt.setInt(4, 27); preparedStmt.execute(); ResultSet rss = stmt.executeQuery("SELECT * FROM players;"); int count=0,totall=0; while(rss.next()){ count++; totall = totall + Integer.parseInt(rss.getString(4)); } System.out.println("Average age of players is " +(totall/count)); conn.close();

              }

                catch(Exception e){ System.out.println(e);}  

}  

}  

Week 11 : Programming Assignment 5

Due Date of Submission 2022-04-14, 23:59 IST

Complete the code segment to drop the table named ‘PLAYERS’.

--Solution-- 

  // Write the SQL command to drop a table String sql = "Drop table PLAYERS"; stmt.executeUpdate(sql);

                }
                catch(Exception e){ System.out.println(e);}  
}  
}