mainpage

res.setContentType("text/html");
		PrintWriter out = res.getWriter();

		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE" , "system" , "connect");

			Statement st = con.createStatement();
			ResultSet rs = st.executeQuery("select * from product");

			while(rs.next())
			{
				String name = rs.getString(1);
				String category = rs.getString(2);
				String price = rs.getString(3);
				String desc = rs.getString(4);
				String owner = rs.getString(5);

				out.println("Product name : "+name);
				out.println("category : "+category);
				out.println("price : "+price);
				out.println("description : "+desc);
				out.println("uploaded by : "+owner);

			}
		}