Loh Peggie

Unable to find specific product

Thanks:)
Which mean I have to add it like this?

Thanks:D

15 years ago

Unable to find specific product

Hey guys currently i am using textfield to find the product name from the database and display the specific information. Like for example I type in Reb beanie and if the red beanie exists, it will show the record of it and i am able to click on the product name called reb beanie in order to view the specific detail of it.

I make use if servlet as well as jsp:

This is my servlet

package sg.edu.nyp.feppz;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;
import java.util.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class AdvanceSearch extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
System.out.println("MySQL Connect Example.");
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "feppz";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "";
Statement st;
try {
Class.forName(driver).newInstance();
conn = DriverManager
.getConnection(url + dbName, userName, password);
System.out.println("Connected to the database");
String ProdName = request.getParameter("ProdName");
ArrayList al = null;
ArrayList emp_list = new ArrayList();
String query = "select * from products where ProdName like'"
+ ProdName + "' order by ProdName";
System.out.println("query " + query);
st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while (rs.next()) {
al = new ArrayList();
al.add(rs.getString(1));
al.add(rs.getString(2));
al.add(rs.getString(3));
al.add(rs.getString(4));
al.add(rs.getString(5));
al.add(rs.getString(6));
al.add(rs.getString(7));
al.add(rs.getString(8));
al.add(rs.getString(9));
System.out.println("al :: " + al);
emp_list.add(al);
}
request.setAttribute("empList", emp_list);
System.out.println("empList " + emp_list);
// out.println("emp_list " + emp_list);
String nextJSP = "/AdvanceSearchResults.jsp";
RequestDispatcher dispatcher = getServletContext()
.getRequestDispatcher(nextJSP);
dispatcher.forward(request, response);
rs.close();
st.close();
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
e.printStackTrace();
}
}
}

This is my jsp find text field:

And when I type reb beanie in the text field it will show the record of it:

When I click on the product name called :reb beanie, it will go to the specific details of it:

<h3>Product Details</h3>
<p>
<%
//Retrieve the id of the product selected by the user
//the product id is sent via the URL as a parameter
int ProductId = -1;
String strProductId = request.getParameter("ProductId");
if(strProductId != null) {
//Convert from string to int
ProductId = Integer.parseInt(strProductId);
}
//Load the database driver
Class.forName("com.mysql.jdbc.Driver");
//Create a connection to our database
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/feppz", "root", "");
//create an SQL statement
PreparedStatement ps = con.prepareStatement("SELECT * FROM products WHERE ProdName=?");
//set the ID to be the id above
ps.setInt(1, ProductId);
//Execute and retrieve our result
ResultSet rs = ps.executeQuery();
%>
</p>
<%
//if there is a result, rs.next() will be true
//else it will be false
if(rs.next()) {
%>
<fieldset>
<legend>Product Information</legend>
<table border="0">
<tr>
<td>
<div style=""><img border="3"
src="images/Caps/<%=rs.getString("ProdImage") %>" height="150" width="150" /></div>
</td>
<td>Product Name: <%=rs.getString("ProdName")+"\t" %>
<div align="left">Product Color: <%=rs.getString("ProdColor")+"\t" %></div>
<div align="left">Product Description: <%=rs.getString("ProdDesc")+"\t" %></div>
<div align="left">Product Price: <%=String.format("$%.2f",rs.getDouble("UnitPrice"))+"\t" %></div>
<a href="javascript:PopupPic('images/sizechart.jpg')">View Size Chart</a><br>
<a href="Beanie.jsp" aligin = "right">Back to products</a>
<a href="ViewReview.jsp?ProductId=<%=rs.getString("ProductId")%>">View Product Review</a>
</td>
</tr>
</table>
</fieldset>
<%
}
else {
//if no record is found, simply display a no record message
%>
No record found.
<%
}
%>
<p> </p>

However do you guys know how to change this to correspond prodName?

Thanks you:)

15 years ago

Sum function sql statement

Thanks:)

Erm may I know is my sql statement correct:

Thanks!

15 years ago

Sum function sql statement

However my table is in t form of inner join.

Currently I am doing a shopping cart and I need to make use of inner join statement to display the details.

The two database that I make use of is called:
shoppingcartitems
Products
I link them together by using the productId:)

My shoppingcartitems attributes are:
SCId
UserId
ProductId
Quantity

My products attributes are:
ProductId
ProdName
ProdColor
ProdDesc
UnitPrice
Quantity
ProdCatId
UserId
ProdImage

The shopping cart will display ProdImage, UnitPrice, ProductName, quantity and TotalPrice(But i dont know how to write the sql statement that sum the unit price from the database)

Thanks:):)

15 years ago

Sum function sql statement

Hey guys do you know how to implement the sql statement for the sum unit price in jsp?

This is my code:

But the problem is I do not know how to add in the sum UnitPrice.

Thanks:)

15 years ago

Exampples of delete servlets and jsp

I see I see.Thanks:)

15 years ago

JSP

Exampples of delete servlets and jsp

Sorry can you explain it more. Cause I dont understand it. Sorry:(

15 years ago

JSP

Exampples of delete servlets and jsp

Hey guys I have done out a delete servlet, however I do not know how to carry on in my jsp like when I choose to delete the 1101 record it will delete.

This is my servlet:

package sg.edu.nyp.feppz;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import sg.edu.nyp.feppz.product.Product;
import sg.edu.nyp.feppz.user.User;
/**
* Servlet implementation class SaveDeleteProduct
*/
public class SaveDeleteProduct extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public SaveDeleteProduct() {
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
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//Retreive the user data from the session object
User user = (User)request.getSession().getAttribute("USER_DATA");
Product product = (Product)request.getSession().getAttribute("PROD_DATA");
try {
//Ensure the the driver class is loaded.
Class.forName("com.mysql.jdbc.Driver");
//Create a connection to our database.
//localhost = server name
//feppz = database name
//root = user name, password = empty
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/feppz", "root", "");
//create an SQL statement, ? marks denote values that we will add later
PreparedStatement ps = con.prepareStatement("DELETE FROM products WHERE ProductId=?");
//replace first ? mark with values from the ItemCode text box
ps.setInt(1, Integer.parseInt(request.getParameter("ProductId")));
//execute to insert into the database
ps.executeUpdate();
//close connection
con.close();
//redirect user to UpdateProductSuccessful.jsp page
response.sendRedirect("DeleteSuccess.jsp");
} catch (Exception e) {
e.printStackTrace();
return;
}
}

Thanks:) You guys have certainly help me a lot:)

15 years ago

JSP

Sure:)

This is the code that I make use of:)

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="org.apache.commons.fileupload.servlet.ServletFileUpload" %>
<%@ page import="org.apache.commons.fileupload.disk.DiskFileItemFactory" %>
<%@ page import="org.apache.commons.fileupload.FileItem" %>
<%@ page import="java.util.*, java.io.*" %>
<%@ page import="java.sql.*, java.text.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Receive the submitted file</title>
<%! //note we use <%! to declare static fields and methods
private static final String UPLOAD_FOLDER = "C:\\peiszetemp\\workspace\\FEPPZ\\WebContent\\useruploads";
//C:\peiszetemp\workspace
//Retrieve file and save to a folder
private void saveFileToFolder(FileItem item) throws Exception
{
//item.getName() will retrieve the full name (including directory)
//of the file to be uploaded
File f = new File(item.getName());
//File.getName() will return us only the name (without directory)
String filename = f.getName();
//Save the file to our directory (UPLOAD_FOLDER see top).
File uploadedFile = new File(UPLOAD_FOLDER + "\\" + filename);
item.write(uploadedFile);
}
// save to Database using Hashtable
// - item
// - input form
private void saveToDatabase(Hashtable ht) throws Exception
{
String ProductId = (String)ht.get("ProductId"); // WORK
String ProdName = (String)ht.get("ProdName");
String ProdColor = (String)ht.get("ProdColor");
String ProdDesc = (String)ht.get("ProdDesc");
String UnitPrice = (String)ht.get("UnitPrice");
String Quantity = (String)ht.get("Quantity");
String ProdCatId = (String)ht.get("ProdCatId");
String UserId = (String)ht.get("UserId");
String filename = "" ; // WORK
//ht.put("item", item);
FileItem item = (FileItem)ht.get("item");
InputStream inputStream= (InputStream)item.getInputStream() ; // WORK
//InputStream a = (F)ht.getInputStream());
File file = new File(item.getName());
filename = file.getName();
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/feppz", "root", "");
PreparedStatement ps = con.prepareStatement("INSERT INTO products (ProductId, ProdName, ProdColor, ProdDesc, UnitPrice, Quantity, ProdCatId, UserId, ProdImage, Image) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
//InputStream is = f.getInputStream();
// InputStream in = new FileInputStream(src);
ps.setString(1, ProductId);
ps.setString(2, ProdName);
ps.setString(3, ProdColor);
ps.setString(4, ProdDesc);
ps.setString(5, UnitPrice);
ps.setString(6, Quantity);
ps.setString(7, ProdCatId);
ps.setString(8, UserId);
ps.setString(9, filename);
ps.setBinaryStream(10, inputStream);
ps.executeUpdate();
con.close();
}
private void saveFileToDatabase(FileItem item) throws Exception
{
File f = new File(item.getName());
String filename = f.getName(); // WORK
InputStream inputStream= item.getInputStream(); // WORK
//Load our mySQL driver
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/feppz", "root", "");
PreparedStatement ps = con.prepareStatement("INSERT INTO products (ProdImage, Image) value( ?, ?)");
InputStream is = item.getInputStream();//where the secret is. Retrieve the list of file.getInputStream read the file.
ps.setBinaryStream(2, inputStream);
ps.setString(1, filename);
ps.executeUpdate();
con.close();
}
%>
</head>
<body>
<%
//Ensure that user send in a multipart form
boolean isMultiPart = ServletFileUpload.isMultipartContent(request);//in html in MultiPartContent
if(isMultiPart == false) {
response.sendRedirect("Collection(A).jsp");
return;
}
//Creating a new DiskFileItemFactory that is needed when we create
//a new ServletFileUpload object
DiskFileItemFactory factory = new DiskFileItemFactory();//this is the guy that can create thing for us create a file upload object that can save file for us
File f = new File(UPLOAD_FOLDER);//define at the very top at the
factory.setRepository(f);//telling the factory where to store the file C:\\Users\\cylaw\\Documents\\Workspaces\\demoImageInDatabase\\ImageInDb\\WebContent\\uploads"; and correspond to the upload folder at web content.
//Create a new file upload handler
ServletFileUpload upload = new ServletFileUpload(factory);//factory contains a file object where we cna store the file.
//The ServletFileUpload object will parse (ie read and extract data)
//the request to obtain the file and its related information
List files = upload.parseRequest(request); //parse is read the request and get the info for us.Go through the list of all the file.
//Go through the list of files
//Although we coded our form such that it only supports one upload
//we can actually handle muliple files, we use an iterator to go
//through all the files being uploaded
Iterator iter = files.iterator();
Hashtable ht = new Hashtable();
while (iter.hasNext()) {
//The iterator's next() method will return a FileItem
FileItem item = (FileItem) iter.next();
//if isFormField == true, it means that it is a regular string item
if (item.isFormField() == false) {
//a file, save to folder to database
//comment out the other
//saveFileToFolder(item);
//formfield is not string but is a file
//if want to save file and load
//Client want the file
//saveFileToDatabase(item); //to use this method you have to have database setup properly
ht.put("item", item);
}
else {
System.out.println(item.getString());
ht.put(item.getFieldName(), item.getString());
//ht.put(item.getFieldName(), item.getString());
}
}
saveToDatabase(ht);
%>
</body>
</html>

Thanks:)

15 years ago

I see I see. Do you guys have any exmaples of impleenting hashtable inside servlets that allow us to upload image as well as date into the database.

Thanks.

15 years ago

I see i see.
Which mean we have to implement the hashtable inside the servlet?

Thanks:D

15 years ago

Thanks:)

What happen if I am using hashtable in jsp page.

15 years ago