Hallo ...
habe noch ein Problem bei der Erstellung von Servlet in Tomcat bei der web.xml Datei...
...so hab noch mal mein Pfad eingeschrieben
+ angela2|
- database ...Datenbank
- graphics....Dateien ...Bilder und .html Dateien
+ WEB-INF
|
+ classes ...alle Java Dateien mit .class
- web.xml
unter http://127.0.0.1:8080/angela2/ aufrufen
zb: eine Showall.java Datei dazu:
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Showall extends HttpServlet
{
public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
java.util.Properties props = new java.util.Properties();
props.put("user", " ");
props.put("password", " ");
String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
String connectionURL = "jdbc
dbc:angela2";
out.println("<html>");
out.println("<body>");
out.println("<head>");
out.println("<title>Programmierung III</title>");
out.println("<link REL='stylesheet' TYPE='text/css' HREF='../../style.css' TITLE='formal'>");
out.println("</head>");
out.println("<body bgcolor='aliceblue' topmargin='0' leftmargin='0'>");
buildtabledel(driverName,connectionURL,props,out);
out.println("</body>");
out.println("</html>");
}
void buildtabledel(String driverName,String connectionURL, java.util.Properties props, PrintWriter out)
{
out.println("<form name='frm4' method='get' action='showallresp'>");
out.println("<table border=0>");
out.println("<tr>");
out.println("<td bgcolor='yellow' height='30'><font color='blue'>&LISTING ALL RECORDS MODULE</font>&&&&&");
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td bgcolor='WHITE'>");
listregid(driverName,connectionURL,props,out);
out.println("</td>");
out.println("</tr>");
out.println("</table>");
out.println("</form>");
}
void listregid(String driverName,String connectionURL, java.util.Properties props, PrintWriter out)
{
String query = "SELECT * FROM student_det";
boolean rc = true;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
int rowCount = 0;
out.println("<center><table border='1' bordercolor='#000000' style='border: Black;'>");
try
{
Class.forName(driverName).newInstance();
con = DriverManager.getConnection(connectionURL, props);
stmt = con.createStatement();
rs = stmt.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
String tempval="";
int columnCount = rsmd.getColumnCount();
out.println("<tr bgcolor='gray'>");
for (int i = 1; i <= 3; i++)
{
out.println("<td><font color='white'>" + rsmd.getColumnLabel(i + 1) + "</font></td>");
}
out.println("</tr>");
while (rs.next())
{
out.println("<tr>");
for (int i = 1; i <= 3; i++)
{
if(i==1)
{
tempval=rs.getString(i+1);
out.println("<td><font color='black'>"+tempval+"</font></td>");
}
else
{
out.println("<td><font color='black'>"+rs.getString(i+1)+"</font></td>");
}
}
out.println("</tr>");
}
out.println("</table></center>");
}
catch (Exception ex)
{
out.println("Exception!");
ex.printStackTrace(out);
rc = false;
}
finally
{
try
{
if (rs != null)
{
rs.close();
}
if (stmt != null)
{
stmt.close();
}
if (con != null)
{
con.close();
}
}
catch (Exception ex)
{
// Do Nothing here
}
}
}
}
web.xml :
<!DOCTYPE web-app PUBLIC
'-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
'http://java.sun.com/dtd/web-app_2_3.dtd'>
<web-app>
<!DOCTYPE web-app PUBLIC
'-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
'http://java.sun.com/dtd/web-app_2_3.dtd'>
<web-app>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Addrec</servlet-name>
<servlet-class>Addrec</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Addrec </servlet-name>
<url-pattern>/Addrec</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Addrecresp</servlet-name>
<servlet-class>Addrecresp</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Addrecresp</servlet-name>
<url-pattern>/Addrecresp</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Delrec</servlet-name>
<servlet-class>Delrec</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Delrec</servlet-name>
<url-pattern>/Delrec</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Delrecresp</servlet-name>
<servlet-class>Delrecresp</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Delrecresp</servlet-name>
<url-pattern>/Delrecresp</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Modrec</servlet-name>
<servlet-class>Modrec</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Modrec</servlet-name>
<url-pattern>/Modrec</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Modrecresp2</servlet-name>
<servlet-class>Modrecresp2</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Modrecresp2</servlet-name>
<url-pattern>/Modrecresp2</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Modrecresp</servlet-name>
<servlet-class>Modrecresp</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Modrecresp</servlet-name>
<url-pattern>/Modrecresp</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Showall</servlet-name> ... .java Datei
<servlet-class>Showall</servlet-class> ... .class Datei ....benutze aber kein Package
Was muß da genau denn da hin ??????????????????
</servlet>
<servlet-mapping>
<servlet-name>Showall</servlet-name> ... .java Datei
<url-pattern>/Showall</url-pattern> ....URL
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
</welcome-file-list>
</web-app>
Folgende Fehlermeldung bekomme ich:
HTTP Status 404 - /WEB-INF/classes/Showall
type Status report
message /WEB-INF/classes/Showall
description The requested resource (/WEB-INF/classes/Showall) is not available
Woran kann das liegen...oder...Was mach ich da falsch?????
Bitte um Hilfe...Verzweifle bald....(((( Vielen Dank!!! )))
Angela
habe noch ein Problem bei der Erstellung von Servlet in Tomcat bei der web.xml Datei...
...so hab noch mal mein Pfad eingeschrieben
+ angela2|
- database ...Datenbank
- graphics....Dateien ...Bilder und .html Dateien
+ WEB-INF
|
+ classes ...alle Java Dateien mit .class
- web.xml
unter http://127.0.0.1:8080/angela2/ aufrufen
zb: eine Showall.java Datei dazu:
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Showall extends HttpServlet
{
public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
java.util.Properties props = new java.util.Properties();
props.put("user", " ");
props.put("password", " ");
String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
String connectionURL = "jdbc
dbc:angela2";out.println("<html>");
out.println("<body>");
out.println("<head>");
out.println("<title>Programmierung III</title>");
out.println("<link REL='stylesheet' TYPE='text/css' HREF='../../style.css' TITLE='formal'>");
out.println("</head>");
out.println("<body bgcolor='aliceblue' topmargin='0' leftmargin='0'>");
buildtabledel(driverName,connectionURL,props,out);
out.println("</body>");
out.println("</html>");
}
void buildtabledel(String driverName,String connectionURL, java.util.Properties props, PrintWriter out)
{
out.println("<form name='frm4' method='get' action='showallresp'>");
out.println("<table border=0>");
out.println("<tr>");
out.println("<td bgcolor='yellow' height='30'><font color='blue'>&LISTING ALL RECORDS MODULE</font>&&&&&");
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td bgcolor='WHITE'>");
listregid(driverName,connectionURL,props,out);
out.println("</td>");
out.println("</tr>");
out.println("</table>");
out.println("</form>");
}
void listregid(String driverName,String connectionURL, java.util.Properties props, PrintWriter out)
{
String query = "SELECT * FROM student_det";
boolean rc = true;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
int rowCount = 0;
out.println("<center><table border='1' bordercolor='#000000' style='border: Black;'>");
try
{
Class.forName(driverName).newInstance();
con = DriverManager.getConnection(connectionURL, props);
stmt = con.createStatement();
rs = stmt.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
String tempval="";
int columnCount = rsmd.getColumnCount();
out.println("<tr bgcolor='gray'>");
for (int i = 1; i <= 3; i++)
{
out.println("<td><font color='white'>" + rsmd.getColumnLabel(i + 1) + "</font></td>");
}
out.println("</tr>");
while (rs.next())
{
out.println("<tr>");
for (int i = 1; i <= 3; i++)
{
if(i==1)
{
tempval=rs.getString(i+1);
out.println("<td><font color='black'>"+tempval+"</font></td>");
}
else
{
out.println("<td><font color='black'>"+rs.getString(i+1)+"</font></td>");
}
}
out.println("</tr>");
}
out.println("</table></center>");
}
catch (Exception ex)
{
out.println("Exception!");
ex.printStackTrace(out);
rc = false;
}
finally
{
try
{
if (rs != null)
{
rs.close();
}
if (stmt != null)
{
stmt.close();
}
if (con != null)
{
con.close();
}
}
catch (Exception ex)
{
// Do Nothing here
}
}
}
}
web.xml :
<!DOCTYPE web-app PUBLIC
'-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
'http://java.sun.com/dtd/web-app_2_3.dtd'>
<web-app>
<!DOCTYPE web-app PUBLIC
'-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
'http://java.sun.com/dtd/web-app_2_3.dtd'>
<web-app>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Addrec</servlet-name>
<servlet-class>Addrec</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Addrec </servlet-name>
<url-pattern>/Addrec</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Addrecresp</servlet-name>
<servlet-class>Addrecresp</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Addrecresp</servlet-name>
<url-pattern>/Addrecresp</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Delrec</servlet-name>
<servlet-class>Delrec</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Delrec</servlet-name>
<url-pattern>/Delrec</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Delrecresp</servlet-name>
<servlet-class>Delrecresp</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Delrecresp</servlet-name>
<url-pattern>/Delrecresp</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Modrec</servlet-name>
<servlet-class>Modrec</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Modrec</servlet-name>
<url-pattern>/Modrec</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Modrecresp2</servlet-name>
<servlet-class>Modrecresp2</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Modrecresp2</servlet-name>
<url-pattern>/Modrecresp2</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Modrecresp</servlet-name>
<servlet-class>Modrecresp</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Modrecresp</servlet-name>
<url-pattern>/Modrecresp</url-pattern>
</servlet-mapping>
<display-name>angela2</display-name>
<servlet>
<servlet-name>Showall</servlet-name> ... .java Datei
<servlet-class>Showall</servlet-class> ... .class Datei ....benutze aber kein Package
Was muß da genau denn da hin ??????????????????
</servlet>
<servlet-mapping>
<servlet-name>Showall</servlet-name> ... .java Datei
<url-pattern>/Showall</url-pattern> ....URL
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
</welcome-file-list>
</web-app>
Folgende Fehlermeldung bekomme ich:
HTTP Status 404 - /WEB-INF/classes/Showall
type Status report
message /WEB-INF/classes/Showall
description The requested resource (/WEB-INF/classes/Showall) is not available
Woran kann das liegen...oder...Was mach ich da falsch?????
Bitte um Hilfe...Verzweifle bald....
(((( Vielen Dank!!! )))Angela
