Bug Tracking System

Friends, I am introducing Web Application with below mentioned Key feature: 1- Project Management System 2- N Level Maintenance for Location, Role, Module and Task 3- User Wise Application Control 4- Tracking of Bugs 5- Tracking of Task Status 6- Interactive Graphs ......Continued Further, I will host it soon and help you to manage your project in a minute. With Regards Deepak Pandey

Read value from properties file

To get the value of database connection or fetch labels for JSP, it is better to use properties file. So that if you change at one place, it will be reflected to all places. Code to read properties file and return value import java.io.IOException; import java.io.InputStream; import java.util.Properties; public class ReadLabelProperties { public static String getProperties(String key) throws IOException { InputStream inputStream=ReadLabelProperties.class.getClassLoader().getResourceAsStream("label.properties"); Properties myproperties = new Properties(); myproperties.load(inputStream); return myproperties.getProperty(key); } } label.properties are having entries like below dbserver=jdbc:mysql://localhost:3306/ dbdriver=com.mysql.jdbc.Driver Hope the same is useful while creating web application Deepak

Web Application

After a long time, I got chance to design a web application: Dynamic web application, using JSP and Servlet -Download Java (JDK and JRE) and install -Download Eclipse IDE and install -Download Tomcat and install -Download MySql and install - File - Download - Dynamic Web Project Give Project Name-(Next)-src-(Next)-Click on web.xml (deployment descriptor) web.xml: (file would be like this WebApp1 login.jsp Login LoginServlet LoginServlet /login/* - login.jsp

First Web Application

Login Name
Password

-loginBean.jsp Class: 1- LoginBean public class LoginBean { String userName=""; String password=""; public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } }2- LoginServlet import javax.servlet.annotation.WebServlet; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import javax.sql.*; import java.sql.*; /** * Servlet implementation class Login */ @WebServlet("/Login") public class Login extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public Login() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub response.getWriter().append("Server at: ").append(request.getContextPath()); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub //doGet(request, response); response.setContentType("text/html"); PrintWriter out = response.getWriter(); String username=request.getParameter("username").toString(); String userpass=request.getParameter("password").toString(); HttpSession session = request.getSession(true); if(username.equalsIgnoreCase(userpass)) { response.sendRedirect("welcome.jsp"); } else { response.sendRedirect("login.jsp"); } } catch (Exception e) { e.printStackTrace(); } } } - Select Project-Run on Server

Suggestion:When anyone defaults in PSB's repayment, restrictions can be put to utilize the benefit of government schemes(subsidy/(ies), pension, Ayushman...). So that defaulted borrower may not be able to use public funds twice (PSBs loan+ GOI Welfare funds).Since GOI is putting efforts for a better life of people by way of collateral free loans like Mudra, Stand up, small KCC etc. There is a thin line of willful/ actual default, hence there would be something which may motivate the citizens for loan repayment. GoI may relase the restricted funds during default once he repays the loan. https://twitter.com/DeepakP89467637

पुलवामा के सभी शहीदों को शत् शत् नमन

Discontinuation of LoU/Buyer's Credit

The Reserve Bank of India has decided in the month of March-2018 to discontinue issuance of letters of undertaking (LoU) and letters of comfort (LoC) for trade credit for imports into India. Authorised dealer-1 (AD-1) category banks will not be allowed to issue LoCs and LoUs for this line of business, the regulator said in a notification on its website. Banks may continue to issue letters of credit and bank guarantees for trade credit for imports into India as per the current guidelines applicable, the notification added.This is part of a series of moves from the RBI after details of the Nirav Modi scam came to light. In the case, Nirav Modi’s associates approached the domestic branch of Punjab National Bank to issue fraudulent LoUs to foreign branches of other Indian banks through the SWIFT network. These LoUs were not registered in the core banking system for PNB. This means that the bank was virtually unaware of any such transactions taking place. The difference between these products is that LoUs and LoCs were issued by domestic banks at the behest of the importer. The importer would negotiate the right price for these loans from the foreign branches of other Indian banks and then get these letters issued by a domestic bank. The exporter, or seller, would be paid from the nostro account.In the case of letters of credit and bank guarantees, domestic banks issue these in favour of the exporter, or seller’s, bank. Typically in these transactions, the seller would take the foreign exchange cost and would build that into the price of the product. LoUs in itself were a good product and the fraud at PNB was more of a systemic issue. Banking industry is having inherent risk like other segments. Hence Govt/RBI/Banks are required to ensure that transaction happening through any window is genuine rather than closing the window for always. Domestic buyer has to arrange for rupee or foreign currency funds to make the payment on the due date which actually was going to take place after 1 or 3 year.It would not only increase liquidity problems to domestic players but would come with other problems also.

EDPMS: Export Data Processing and Monitoring System RBI has directed AD Category-I Banks to update the EDPMS with data of export proceeds on “as and when realised basis” and, with effect from October 16, 2017 generate Electronic Bank Realisation Certificate (eBRC) only from the data available in EDPMS, to ensure consistency of data in EDPMS and consolidated eBRC. Nice initiatives taken by RBI to monitor export related information on real time basis. Here we need to understand the EDPMS data. There are 2 legs mainly: 1)- Shipping bill is being generated by customs. 2)- That shipping bill is being transferred to RBI EDPMS data. If there is any issue in data related with shipping bill, Exporter need to contact the custom for taking corrective action.For example, that shipping bill status is LEO Cancelled or the same was sample bill and exporter did not submit GR waiver. There may be other cases also. In 2nd case, banks handling the documents need to clear the GR with received payments/ as per RBI guidleines WOFF, extension etc whatever is possible. As observed by me, at present, bills are appearing due to below mentioned reasons: > BRCs has been generated while it is showing pending.: In this, first check the AD code bills appearing in Shipping Bills, and if AD code of other Bank is appearing, transfer the same in your AD and clear the entry with the help of data center or whatever the process is there. Particular in this case, Banks are more responsible to clear the entries as payment has already been received.\ > LEO Cancelled/SAMPLE BILLS (Where GR waiver was not taken): In such case, one of the solution is to make necessary correction at customs and clear the same entry. > In case of non receipt of payment/any other technical reason: Follow the master circular of Export of goods and services dated 01.01.2016 updated on 12.05.2016 for taking corrective action. Basically where payment has been received, Banks who handled the documents has to be more proactive to clear the bills. Above are illustrative and based on while working on EDPMS.