pavanganeshbhagathi/project-builder-blog-update-and-delete-blog

ProGrad Project Builder | Blog - Stage 4 (Update and Delete Blog)

Remember your client Mr. Alex?

Well, he loves your work and is back for your help. He's reworking on the same project with the help of databases. Can you look into his requirements & sort things out? You can start building the project on top of Stage - 3

What Should You Do

Fork this repo
Clone this repo
Practice Java JDBC - connections, Statement and ResultSet.

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. Your database connection code should exist inside the utlity package.
5. Your crud operations should go inside the dao package.
6. Create the connection object in the controller and call the respective methods.
7. Once the progressions are completed follow the instructions to run the application and test your code.
8. Add appropriate jars to your project directory.

Requirements

Download ojdbc6.jar from the given link [https://www.oracle.com/database/technologies/jdbcdriver-ucp-downloads.html]

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 model class called as `Blog' inside the model package with the following arguments,
   • int blogId
     • String blogTitle;
     • String blogDescription;
     • LocalDate postedOn;
2. Include appropriate getters and setters method.

Progression 3:

1. Create an interface called BlogDaoInterface inside the dao package with the following methods,
   • void insertBlog(Blog blog)
   • List selectAllBlogs()
   • Blog selectBlog(int blogid);
   • boolean deleteBlog(int id)
     • boolean updateBlog(Blog blog)

Progression 4:

1. Create a dao-class called BlogDaoImpl inside the dao package.
2. It should implement the BlogDaoInterface.
3. Implement the following methods,
   • void insertBlog(Blog blog) - method to insert the blog into the database.
   • List selectAllBlogs() - method to retrieve the blogs from the database.
   • Blog selectBlog(int blogid) - method to retrieve a selected blog based on its id.
   • boolean deleteBlog(int id) - method to delete a selected blog.
     • boolean updateBlog(Blog blog) - method to update a blog.

Running the project

1. Do not modify any code in EditViewController, UpdateBlogController and DeleteBlogController.
2. Right click the project - select run as run on server.
3. Login with the username and password.
4. Click Edit button to edit your post.
5. Click Delete button to delete the selected blog.

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

Happy Coding ❤️