|
A,
B,
C,
D,
E,
F,
G,
H,
I,
J,
K,
L,
M,
N,
O,
P,
R,
S,
T,
U,
V,
W,
Z,
0,
1,
2
<%
String bildvorhanden, id_kuenstler, sql, buchstabe, firstletter, firsletter, initialletter, link, NameI;
String NameII, id, beschreibung, strasse, plz, ort, telefon, linkwerk1, header1_kommentar, kommentar_vorhanden, bildlink;
String arraybuchstabe[] = new String[27];
buchstabe = "";
link = "";
firstletter = "ja";
NameI = "";
NameII = "";
beschreibung = "";
id = "";
strasse = "";
plz = "";
ort = "";
telefon = "";
linkwerk1 = "";
initialletter = "";
id_kuenstler = "";
header1_kommentar = "";
bildvorhanden = "";
kommentar_vorhanden = "";
bildlink = "";
int empfehlungen = 0;
int kritik = 0;
int i = 0;
int zaehlera = 0;
int zaehler2 = 0;
int b = 0;
int d = 0;
ResultSet res;
arraybuchstabe[0]="A";
arraybuchstabe[1]="B";
arraybuchstabe[2]="C";
arraybuchstabe[3]="D";
arraybuchstabe[4]="E";
arraybuchstabe[5]="F";
arraybuchstabe[6]="G";
arraybuchstabe[7]="H";
arraybuchstabe[8]="I";
arraybuchstabe[9]="J";
arraybuchstabe[10]="K";
arraybuchstabe[11]="L";
arraybuchstabe[12]="M";
arraybuchstabe[13]="N";
arraybuchstabe[14]="O";
arraybuchstabe[15]="P";
arraybuchstabe[16]="Q";
arraybuchstabe[17]="R";
arraybuchstabe[18]="S";
arraybuchstabe[19]="T";
arraybuchstabe[20]="U";
arraybuchstabe[21]="V";
arraybuchstabe[22]="W";
arraybuchstabe[23]="z";
arraybuchstabe[24]="0";
arraybuchstabe[25]="1";
arraybuchstabe[26]="2";
Random r = new Random();
int obergrenze=25;
int z=r.nextInt(obergrenze);
if (request.getQueryString() != null) {
buchstabe = request.getParameter("buchstabe");
}
if (buchstabe.equals("") == true) {
buchstabe = arraybuchstabe[z];
}
buchstabe = buchstabe.toUpperCase();
ResultSet res4;
try {
Class.forName( "com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection
("jdbc:mysql://localhost/main","admin","zQmxXyUc");
Statement stmt=conn.createStatement();
sql="SELECT NameII, Name, Ort, link, Schwerpunkt, Titel, Beschreibung, id, empfehlungen, kritik, Strasse, PLZ, Telefon, kommentar_vorhanden, bildlink from galerien_links where (Left(Name, 1) = '" +buchstabe+ "' or Left(Name, 1) = '" +buchstabe.toLowerCase()+ "') and CHAR_LENGTH(Link) > 5 order by Name";
ResultSet res2=stmt.executeQuery(sql);
res2.last();
int a = res2.getRow();
res2.first();
while(res2.next()) {
NameII = res2.getString(1);
if (res2.getString(2) != null) {
NameI = res2.getString(2);
} else {
NameI = "___";
}
ort = res2.getString(3);
link = res2.getString(4);
beschreibung = res2.getString(7);
id = res2.getString(8);
empfehlungen = Integer.parseInt(res2.getString(9));
kritik = Integer.parseInt(res2.getString(10));
strasse = res2.getString(11);
plz = res2.getString(12);
telefon = res2.getString(13);
kommentar_vorhanden = res2.getString(14);
bildlink = res2.getString(15);
if (NameII == null) {
NameII = " ";
}
if (ort == null) {
ort = " ";
}
if (link == null) {
link = " ";
}
if (beschreibung == null) {
beschreibung = " ";
}
if (strasse == null) {
strasse = " ";
}
if (plz == null) {
plz = " ";
}
if (telefon == null) {
telefon = " ";
}
if (kommentar_vorhanden == null) {
kommentar_vorhanden = "nein";
}
if (NameI != null) {
initialletter = NameI.substring(0,1);
initialletter = initialletter.toUpperCase();
} else {
initialletter = " ";
}
//out.println("_" +NameI + "_" + initialletter +"
");
//ort = ort.trim();
//strasse = strasse.trim();
//plz = plz.trim();
if ((bildlink != null) && (bildlink.length() > 5 == true)) {
out.println( "| ");
} else {
out.println( " | | ");
}
if (link.equals(" ") == true) {
out.println( " | ");
out.println("![](../profile/") ");
}
out.println("
| ");
}
}
catch(ClassNotFoundException err) {
out.println("DB-Driver nicht gefunden!");
out.println(err);
}
catch(SQLException err) {
out.println("Connect nicht möglich");
out.println(err);
}
%>
A,
B,
C,
D,
E,
F,
G,
H,
I,
J,
K,
L,
M,
N,
O,
P,
R,
S,
T,
U,
V,
W,
Z,
0,
1,
2
Sie möchten, daß wir einen Link auf Ihre Website setzen?
|
