Week 11 Programming Assignment : Programming in JAVA 2023

 

What is Programming in Java?

Java is a popular object-oriented programming language that was first released in 1995. It is used for developing a wide range of applications, including desktop applications, mobile applications, web applications, and enterprise applications.

Here are some key features and concepts of Java programming:

Object-oriented programming: Java is an object-oriented language, which means that it focuses on the creation of objects that contain both data and methods that operate on that data.

Platform independence: Java programs can run on any platform that supports a Java Virtual Machine (JVM), which makes it a popular choice for cross-platform development.

Memory management: Java uses automatic memory management through a garbage collector, which helps to prevent memory leaks and makes it easier to write memory-safe code.

Exception handling: Java has a built-in mechanism for handling runtime errors or exceptions, which helps to ensure that programs can recover gracefully from unexpected errors.

Multi-threading: Java supports multi-threading, which allows programs to execute multiple threads of execution simultaneously, making it well-suited for developing concurrent applications.

Standard libraries: Java provides a large number of standard libraries that developers can use to build applications more quickly and easily, including libraries for networking, database access, and user interface development.

To get started with Java programming, you will need to install the Java Development Kit (JDK) on your computer. Once you have installed the JDK, you can use an Integrated Development Environment (IDE) like Eclipse or IntelliJ IDEA to write and debug your code.

To learn Java programming, you can start with the basics of the language, such as data types, control structures, and object-oriented programming concepts. There are many online resources and tutorials available for learning Java, including Oracle's official Java tutorials, which cover everything from the basics to advanced topics like concurrency and networking.

Week 11 : Programming Assignment 1

Due on 2023-04-13, 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 :

PreparedStatement preparedStmt = conn.prepareStatement("insert into Players values(?,?,?,?)"); preparedStmt.setInt (1, 1); preparedStmt.setString (2, "Ram"); preparedStmt.setString (3, "Gopal"); preparedStmt.setInt(4, 26); int xxx= preparedStmt.executeUpdate(); PreparedStatement preparedStmt2 = conn.prepareStatement("insert into Players values(?,?,?,?)"); preparedStmt2.setInt (1, 2); preparedStmt2.setString (2, "John"); preparedStmt2.setString (3, "Mayer"); preparedStmt2.setInt(4, 22); int xyz= preparedStmt2.executeUpdate();

Week 11 : Programming Assignment 2

Due on 2023-04-13, 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 a1="update players "+"set AGE =24 WHERE UID==1"; stmt.execute(a1); String bb="update players "+"set LAST_NAME ='Gopala' WHERE UID==1"; stmt.execute(bb); String c_z="update players "+"set FIRST_NAME='Rama' WHERE UID==1"; stmt.execute(c_z);

Week 11 : Programming Assignment 3

Due on 2023-04-13, 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 :

String My_fav_Query="DELETE FROM PLAYERS "+"WHERE UID=1"; stmt.executeUpdate(My_fav_Query);

Week 11 : Programming Assignment 4

Due on 2023-04-13, 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 :

ResultSet ans=stmt.executeQuery("SELECT * from players"); int ccdd=0; int sum_is_sum=0; while(ans.next()) { ccdd++; sum_is_sum+=Integer.parseInt(ans.getString(4)); } System.out.println("Average age of players is "+sum_is_sum/ccdd); conn.close();

Week 11 : Programming Assignment 5

Due on 2023-04-13, 23:59 IST

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

Solution :

//Below is the required query to run okkkk query = "DROP TABLE players;"; stmt.executeUpdate(query);

CRITERIA TO GET A CERTIFICATE

Average assignment score = 25% of the average of the best 8 assignments out of the total 12 assignments given in the course.
Exam score = 75% of the proctored certification exam score out of 100

Final score = Average assignment score + Exam score

YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF THE AVERAGE ASSIGNMENT SCORE >=10/25 AND THE EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100.

Programming in JAVA	Answers
Assignment 1	Click Here
Assignment 2	Click Here
Assignment 3	Click Here
Assignment 4	Click Here
Assignment 5	Click Here
Assignment 6	Click Here
Assignment 7	Click Here
Assignment 8	Click Here
Assignment 9	Click Here
Assignment 10	Click Here
Assignment 11	Click Here
Assignment 12	Click Here