Announcement

**Eberhard Liedtke** · 10.09.2001, 21:31

Ich sch�tze, da� der Fehler in der nicht gefundenen Tabelle, auf die zugegriffen werden soll, liegt. Der Quelltext w�rde mich mal interessieren und die Tabellenbezeichnung. Eventuell ist die Bezeichnung nicht als Parameter �bergeben worden

**Ralf Zschemisch** · 10.09.2001, 22:42

mmh... ich kann dir leider nicht sagen, warum es nun funtioniert ...

ich habe nur die mysql_comp.jar und mysql_uncomp.jar nach /jre/1.3/ kopiert und
in der system steuerung den CLASSPATH C:\mm.mysql.jdbc-1.2c; D:\Programme\JavaSoft\Jre\1.3\; neu eingerichtet...

evtl. lag es auch nur daran, dass ich den rechner neu gestartet habe :-)

hier nun der quelltext, den ultra def mit *einem klick* nach der erstellung des formulars
erzeugte

8<-- eingabe.jsp

<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%>
<%@ include file="Connections/personal.jsp" %>
<%
// *** Edit Operations: declare variables

// set the form action variable
String MM_editAction = request.getRequestURI();
if (request.getQueryString() != null && request.getQueryString().length() > 0) {
MM_editAction += "?" + request.getQueryString();
}

// connection information
String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null;

// redirect information
String MM_editRedirectUrl = null;

// query string to execute
StringBuffer MM_editQuery = null;

// boolean to abort record edit
boolean MM_abortEdit = false;

// table information
String MM_editTable = null, MM_editColumn = null, MM_recordId = null;

// form field information
String[] MM_fields = null, MM_columns = null;
%>
<%
// *** Insert Record: set variables

if (request.getParameter("MM_insert") != null) {

MM_editDriver = MM_personal_DRIVER;
MM_editConnection = MM_personal_STRING;
MM_editUserName = MM_personal_USERNAME;
MM_editPassword = MM_personal_PASSWORD;
MM_editTable = "personal";
MM_editRedirectUrl = "danke.jsp";
String MM_fieldsStr = "vname|value|nname|value|age|value|phon|value|besc hreibung|value|imageurl|value";
String MM_columnsStr = "vname|',none,''|nname|',none,''|age|none,none,NUL L|phon|',none,''|beschreibung|',none,''|imageurl|' ,none,''";

// create the MM_fields and MM_columns arrays
java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_fieldsStr,"|");
MM_fields = new String[tokens.countTokens()];
for (int i=0; tokens.hasMoreTokens(); i++) MM_fields[i] = tokens.nextToken();

tokens = new java.util.StringTokenizer(MM_columnsStr,"|");
MM_columns = new String[tokens.countTokens()];
for (int i=0; tokens.hasMoreTokens(); i++) MM_columns[i] = tokens.nextToken();

// set the form values
for (int i=0; i+1 < MM_fields.length; i+=2) {
MM_fields[i+1] = ((request.getParameter(MM_fields[i])!=null)?(String)request.getParameter(MM_fields[i]):"");
}

// append the query string to the redirect URL
if (MM_editRedirectUrl.length() != 0 && request.getQueryString() != null) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + request.getQueryString();
}
}
%>
<%
// *** Insert Record: construct a sql insert statement and execute it

if (request.getParameter("MM_insert") != null) {

// create the insert sql statement
StringBuffer MM_tableValues = new StringBuffer(), MM_dbValues = new StringBuffer();
for (int i=0; i+1 < MM_fields.length; i+=2) {
String formVal = MM_fields[i+1];
String elem;
java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_columns[i+1],",");
String delim = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
String altVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
String emptyVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
if (formVal.length() == 0) {
formVal = emptyVal;
} else {
if (altVal.length() != 0) {
formVal = altVal;
} else if (delim.compareTo("'") == 0) { // escape quotes
StringBuffer escQuotes = new StringBuffer(formVal);
for (int j=0; j < escQuotes.length(); j++)
if (escQuotes.charAt(j) == '

Announcement

Error: 500 bei Zugriff auf MySql datenbank

Error: 500 bei Zugriff auf MySql datenbank

Comment

Comment