nethravathi-m / lab-jdbc-show-playername-skill

ProGrad Lab | ProGrad Premier League

Like the Indian Premier League (IPL) which happens during April & May every year. Our team organizes ProGrad Premier League at the same time for all the Cricketers in our team. Our PPL schema is a complete repository of limited-over format of Cricket, that includes details like teams competing, player representing each team, scoring details, umpire details etc.

Can you help out with the below task and take our database creation to completion?

What Should You Do

Fork this repo
Clone this repo
Practice Java JDBC - class and object, Statements, Connections and CRUD.

How To Submit

Upon completion, run the following commands:

git add .
git commit -m "ProGrad ID"
git push origin master

And finally, create a pull request so your ProGrad Mentor (PM) can review your work.

Instructions

1. Do not modify the entire code.
2. Edit the code as per the instructions.
3. Go to Java Resources -> src folder.
4. You database connection code should exist inside the utlity package.
5. Your CREATE, READ, UPDATE and DELETE code should exist inside the dao package.
6. Once the progressions are completed follow the instructions to run the application and test your code.
7. Add appropriate jars to your project directory.
8. To add dependencies, right click on your project, select build path - configure build path - select libraries tab - select add external jars and add the downloaded jar files.

Requirements

If you haven't downloaded OJDBC driver (ojdbc6.jar), then download using this link [https://www.oracle.com/database/technologies/jdbcdriver-ucp-downloads.html]

Database Schema

Progression 0:

1. Right click on src folder and select new - file and name it as jdbc.properties.
2. You can use the jdbc properties given below in the NOTE section.

Progression 1:

1. Create a class called as ConnectionManager inside the utility package.
2. Create a method public static Connection getConnection() which returns a connection object.
3. Use the method public static Properties loadPropertiesFile() to load the jdbc properties from the jdbc.properties file.

Progression 2:

1. Create a class called as skill with below attributes,
   • skillld - Long
   • skillName - String
2. Include appropriate getters and setters.
3. Include getter and setter method for all the attributes Include constructor with below arguments, public Skill(skillId, skillName).

Progression 3:

1. Create a dao-class called as SkillDAO with the below method,
   • public Skill getSkillBylD(Long id) - Method used to fetch the skill information from the database based on the skill id.

Progression 4:

2. Create a class called as Player with below attributes,
   • playerld - Long
   • name - String
   • country - String
   • skill - Skill
3. Include getter and setter method for all the attributes.
4. Include constructor with below arguments - public Player(Long playerld,String name, String country,Skill skill)

Progression 5:

1. Create a class called as PlayerDAO with below methods,
   • public List< Player > getAllPlayers() - Method used to fetch all the players and their corresponding skill from the database.

Progression 6:

1. Create a controller called as Main inside the controller package.
2. Create appropriate objects for the classes - Player, PlayerDAO, Skill and SkillDAO.
3. Refer sample output given below for output format.

Note:

Use the below code to retreive the connection details from jdbc.properties to establish connection

public static Properties loadPropertiesFile() throws Exception {
	Properties prop = new Properties();	
	InputStream in = ConnectionManager.class.getClassLoader().getResourceAsStream("jdbc.properties");
	prop.load(in);
	in.close(); 
	return prop;
}

Create a file called as jdbc.properites. To create a file right click on the application - new - file - name the file as jdbc.properties.

jdbc.properties
#JDBC properties entry for ORACLE server
driver = oracle.jdbc.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:xe
username=your_username
password=your_password

Sample Output

 List of all player and their skill
 Id 	Name 		Country 	Skill 
 26 	Aaron Finch 	Australia 	Batting 
 80 	AB de Villiers 	South Africa 	Batting 
 82 	Abu Nechim 	India 		Bowling 
 85 	Adam Milne 	New Zealand 	Bowling 
 16 	Akshdeep Nath 	India 		All Rounder

Happy Coding ❤️