Maria Mina

Greenhorn

+ Follow

2 Posts 2 Threads 0 Cows

since Nov 19, 2005

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Total given

Likes

Total received

Received in last 30 days

Total given

Given in last 30 days

Forums and Threads

Scavenger Hunt

Ranch Hand Scavenger Hunt

Greenhorn Scavenger Hunt

Recent posts by Maria Mina

Connect servlet to MySQL using NetBeans IDE 4.1

Hello
I am coding a connection and is not connecting.

Here is my coding:

'lmupums' is my db name
'lmupums' is the username and 'DWA' is the password
Where is my error? Can you please help me?

18 years ago

Servlets

Error with jsp and JavaBeans

hello I really need your help. I am writting some codes using jsp,javabeans and mysql database. I have an error page and I don't know how to solve this problem. It compiles and builds successfully my coding. My first page of my project is working correctly and when I want to link to customers page it loads this error. Can you please help me? It is very important and urgent! Thank you

//customers2.jsp
<html>
<head><title></title></head>
<body>
<%@ page import="myBeans.customerBean, myBeans.employeeBean, java.util.Vector, java.util.Enumeration" %>
<jsp:useBean id="s" scope="session" class="myBeans.authBean"/>
<h3 align="center"></h3>
<br>
<table align ="center" border=0 width = 80%>
<tr>
<td><a href = "pumps.jsp">Pumps</a></td>
<td>Customers</td>
</tr>
</table></br>
<p>
<h4 align="justify"><font color="blue" size="4">
<br>Hello <%= ((employeeBean) session.getAttribute("employee")).getEmployeeName()%>.
Below are the information of all the customers of the company:</br>
</font></h4>
<ul>
<%
Vector customers = s.getCustomerInfo(((customerBean) session.getAttribute("customer")).getCid(),out);
%>
<table align ="center" border="1">
<br><tr>
<br><tr>
<td width = 150px>CustomerId</td>
<td width = 150px>First Name</td>
<td width = 150px>Last Name</td>
<td width = 150px>Usn</td>
<td width = 150px>Pwd</td>
<td width = 150px>Birthdate</td>
<td width = 150px>Phone1</td>
<td width = 150px>Phone2</td>
<td width = 150px>Identity</td>
<td width = 150px>Cardtype</td>
<td width = 150px>Account Num.</td>
<td width = 150px>Card Holder</td>
<td width = 150px>Card Num.</td>
<td width = 150px>Expired Date</td>
<td width = 150px>Address</td>
<td width = 150px>Code</td>
<td width = 150px>City</td>
<td width = 150px>Country</td>
</tr></br>
<%
Enumeration ls = customers.elements();
while(ls.hasMoreElements()) {
customerBean c = (customerBean) ls.nextElement();
%>
<tr>
<td width = 150px><%= c.getCid()%></td>
<td width = 150px><%= c.getFname()%></td>
<td width = 150px><%= c.getLname()%></td>
<td width = 150px><%= c.getUsn()%></td>
<td width = 150px><%= c.getPwd()%></td>
<td width = 150px><%= c.getBirthdate()%></td>
<td width = 150px><%= c.getPhone1()%></td>
<td width = 150px><%= c.getPhone2()%></td>
<td width = 150px><%= c.getIdentity()%></td>
<td width = 150px><%= c.getCardtype()%></td>
<td width = 150px><%= c.getAcnum()%></td>
<td width = 150px><%= c.getCardholder()%></td>
<td width = 150px><%= c.getCardnum()%></td>
<td width = 150px><%= c.getExpdate()%></td>
<td width = 150px><%= c.getAddress()%></td>
<td width = 150px><%= c.getCode()%></td>
<td width = 150px><%= c.getCity()%></td>
<td width = 150px><%= c.getCountry()%></td>
</tr>
<%
}
%>
</br>
</body>
</html>
//authBean.java
package myBeans;
//the bean uses the sql package to connect to the database as well as the value beans
import java.sql.*;
import myBeans.employeeBean;
import myBeans.customerBean;
import myBeans.ordersBean;
import myBeans.pumpBean;
import java.util.Vector;
import javax.servlet.jsp.JspWriter;
public class authBean {
Connection cn = null;
public authBean() {
try {
Class.forName("com.mysql.jdbc.Driver");
cn = DriverManager.getConnection("jdbc:mysql://localhost/lmpumps?user=lmpumps&password=DWA");
}
catch (Exception e) { System.out.println(e.getMessage()); }
}
//for customers2.jsp
public Vector getCustomerInfo(int cid,JspWriter out) {
ResultSet rs = null;
Statement st = null;
String sqlStr = null;
Vector customers = new Vector();
try {
st = cn.createStatement();
sqlStr = "SELECT customer.* FROM customer WHERE cid =" + cid;
rs = st.executeQuery(sqlStr);
while (rs.next()) {
customerBean c = new customerBean();
c.setCid(rs.getInt(1));
c.setFname(rs.getString(2));
c.setLname(rs.getString(3));
c.setUsn(rs.getString(4));
c.setPwd(rs.getString(5));
c.setBirthdate(rs.getString(6));
c.setPhone1(rs.getString(7));
c.setPhone2(rs.getString(8));
c.setIdentity(rs.getString(9));
c.setCardtype(rs.getString(10));
c.setAcnum(rs.getString(11));
c.setCardholder(rs.getString(12));
c.setCardnum(rs.getString(13));
c.setExpdate(rs.getString(14));
c.setAddress(rs.getString(15));
c.setCode(rs.getString(16));
c.setCity(rs.getString(17));
c.setCountry(rs.getString(18));
customers.addElement(c);
}
return customers;
}
catch (Exception e) { try{out.println(sqlStr);out.println(e.getMessage());return null;}
catch (Exception dum) {return null;}
}
}
//returns an employee bean with the employee data.if such a lecturer does not exists then the method returns null
public employeeBean validate(String usn, String pwd, JspWriter out) {
ResultSet rs = null;
Statement st = null;
String sqlStr = null;
try {
st = cn.createStatement();
sqlStr = "SELECT eid, fname, lname FROM employee WHERE usn = '" + usn + "' AND pwd = '" + pwd + "'";
rs = st.executeQuery(sqlStr);
//if a result set exists with the username and password set then the employee is correct
if (rs.next()) {
employeeBean emp = new employeeBean();
//construct the employee bean and set its data based on the information of the resultset
emp.setEid(rs.getInt(1));
emp.setFname(rs.getString(2));
emp.setLname(rs.getString(3));
return emp;
}
else return null;
}
catch (Exception e) {
try{out.println(sqlStr);out.println(e.getMessage()); return null;}
catch (Exception dum) {return null;} }
}
}

[ERROR MSG]
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.NullPointerException
org.apache.jsp.customers_jsp._jspService(org.apache.jsp.customers_jsp:64)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.7 logs.

[/ERROR MSG]
mariakmina82@yahoo.com

18 years ago

JSP