Week 10 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 10 : Programming Assignment 1

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

The following code needs some package to work properly. Write appropriate code to import the required package(s) in order to make the program compile and execute successfully.

Solution :

// Import required packages import java.sql.*; import java.lang.*;

Week 10 : Programming Assignment 2

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

Write the JDBC codes needed to create a Connection interface using the DriverManager class and the variable DB_URL.  Check whether the connection is successful using 'isAlive(timeout)' method to generate the output, which is either 'true' or 'false'.

Note the following points carefully:

1. Name the connection object as 'conn' only.

2. Use timeout value as 1.

Solution :

// Open a connection and check connection status // Open a connection conn = DriverManager.getConnection(DB_URL); System.out.print(conn.isValid(1));

Week 10 : Programming Assignment 3

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

Due to some mistakes in the below code, the code is not compiled/executable. Modify and debug the JDBC code to make it execute successfully.

Solution :

import java.sql.*; // All sql classes are imported import java.lang.*; // Semicolon is added import java.util.Scanner; public class Question103 { public static void main(String args[]) { try { Connection conn = null; Statement stmt = null; String DB_URL = "jdbc:sqlite:/tempfs/db"; System.setProperty("org.sqlite.tmpdir", "/tempfs"); // Connection object is created conn = DriverManager.getConnection(DB_URL); conn.close(); System.out.print(conn.isClosed()); } catch(Exception e){ System.out.println(e);} } }

Week 10 : Programming Assignment 4

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

Complete the code segment to create a new table named ‘PLAYERS’ in SQL database using the following information.

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

Solution :

// The statement containing SQL command to create table "players" String CREATE_TABLE_SQL="CREATE TABLE players (UID INT, First_Name VARCHAR(45), Last_Name VARCHAR(45), Age INT);"; // Execute the statement containing SQL command stmt.executeUpdate(CREATE_TABLE_SQL);

Week 10 : Programming Assignment 5

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

Complete the code segment to rename an already created table named ‘PLAYERS’ into ‘SPORTS’.

Solution :

// Write the SQL command to rename a table String alter="ALTER TABLE players RENAME TO sports;"; // Execute the SQL command stmt.executeUpdate(alter);

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	NA
Assignment 12	NA