Week 10 : Programming Assignments - NPTEL >> Programming In Java - 2025

Week 10 : Programming Assignment 1

Solution :

		// Answer
		import java.sql.Connection;
		import java.sql.DriverManager;
		//End
		

	public class W10_P1 {
    public static void main(String[] args) {

        // The below code requires correct imports to compile
        Connection con = null;
        DriverManager dm = null;

        // Output statement, for portal testing only
        System.out.println("import successful");
    }
}

Week 10 : Programming Assignment 2

Solution :

		// Answer
		 String url = "jdbc:sqlite:test.db";
		//End
		

	// Portal test output
        if (url.equals("jdbc:sqlite:test.db")) {
            System.out.println("connection string ready");
        } else {
            System.out.println("incorrect connection string");
        }
    }
}

Week 10 : Programming Assignment 3

Solution :

		// Answer
		 String sql = "INSERT INTO students (id, name) VALUES (1, 'Alice');";
		//End
		

	// Portal test output
        if (sql.equals("INSERT INTO students (id, name) VALUES (1, 'Alice');")) {
            System.out.println("insert statement ready");
        } else {
            System.out.println("incorrect statement");
        }
    }
}

Week 10 : Programming Assignment 4

Solution :

		// Answer
		 String sql = "SELECT * FROM students;";
		//End
		

	if (sql.equals("SELECT * FROM students;")) {
            System.out.println("select statement ready");
        } else {
            System.out.println("incorrect statement");
        }
    }
}

Week 10 : Programming Assignment 5

Solution :

		// Answer
		  String sql = "UPDATE students SET name = 'Bob' WHERE id = 1;";
		//End
		

	// Portal test output
        if (sql.equals("UPDATE students SET name = 'Bob' WHERE id = 1;")) {
            System.out.println("update statement ready");
        } else {
            System.out.println("incorrect statement");
        }
    }
}