User: janaudy
Date: 00/09/15 09:04:40
Modified: webstore/db cs.java
Log:
I added some logins for people to test the webstore for the following
languages: french, english and finnish.
Logins and passwords are french, english and finnish
Revision Changes Path
1.3 +66 -27 zola/webstore/db/cs.java
Index: cs.java
===================================================================
RCS file: /products/cvs/ejboss/zola/webstore/db/cs.java,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- cs.java 2000/05/22 16:57:13 1.2
+++ cs.java 2000/09/15 16:04:40 1.3
@@ -9,28 +9,28 @@
* @date May, 10, 2000
* @version 1.0
*/
-
+
import java.sql.*;
public final class cs {
private static Connection connection = null;
private static Statement statement = null;
-
+
public static void main(String _[]) {
log("Downloading the driver...");
try {
Class.forName("org.hsql.jdbcDriver");
- connection = DriverManager.getConnection("jdbc:HypersonicSQL:ZOLDB","sa","");
+ connection = DriverManager.getConnection("jdbc:HypersonicSQL:ZOLDB","sa","");
statement = connection.createStatement();
} catch (Exception e) {
- e.printStackTrace();
+ e.printStackTrace();
}
-
+
if (_.length > 0) {
seeContents(connection);
- exit();
+ exit();
}
-
+
log("Dropping the tables...");
try {
statement.executeUpdate("DROP TABLE "+PERSONENTITY);
@@ -39,8 +39,8 @@
// Should be thrown if the tables do not exist
//e.printStackTrace();
log("Tables do not exist!");
- }
-
+ }
+
log("Creating the tables...");
try {
String sql = "CREATE TABLE "+PRODUCTENTITY+
@@ -51,7 +51,7 @@
IMAGEURL+" VARCHAR(255))";
log(sql);
statement.execute(sql);
-
+
sql = "CREATE TABLE "+PERSONENTITY+
"("+EMAIL+" VARCHAR(255) PRIMARY KEY, "+
PASSWORD+" VARCHAR(255), "+
@@ -71,7 +71,7 @@
e.printStackTrace();
}
log("-------------------------------");
-
+
log("Populating the database...");
try {
log("Populating the products...");
@@ -116,7 +116,7 @@
ps.setDouble(4, 8.45);
ps.setString(5, "orchide3.jpg");
ps.execute();
-
+
log("Populating the users...");
sql = "INSERT INTO "+PERSONENTITY+
"("+EMAIL+", "+PASSWORD+", "+FIRSTNAME+", "+LASTNAME+", "+
@@ -138,9 +138,9 @@
ps.setString(11, "fr");
ps.setString(12, "");
ps.execute();
- ps.setString(1, "guest");
- ps.setString(2, "");
- ps.setString(3, "Guest");
+ ps.setString(1, "french");
+ ps.setString(2, "french");
+ ps.setString(3, "French guy");
ps.setString(4, "Tseug");
ps.setString(5, "0032346534566564");
ps.setString(6, "Moon");
@@ -148,17 +148,56 @@
ps.setString(8, "Sol 455");
ps.setString(9, "Tge");
ps.setString(10, "AZERTY");
+ ps.setString(11, "fr");
+ ps.setString(12, "");
+ ps.execute();
+ ps.setString(1, "finnish");
+ ps.setString(2, "finnish");
+ ps.setString(3, "Finnish guy");
+ ps.setString(4, "Tseug");
+ ps.setString(5, "0032346534566564");
+ ps.setString(6, "Moon");
+ ps.setString(7, "17");
+ ps.setString(8, "Sol 455");
+ ps.setString(9, "Tge");
+ ps.setString(10, "AZERTY");
+ ps.setString(11, "fi");
+ ps.setString(12, "");
+ ps.execute();
+ ps.setString(1, "german");
+ ps.setString(2, "german");
+ ps.setString(3, "German guy");
+ ps.setString(4, "Tseug");
+ ps.setString(5, "0032346534566564");
+ ps.setString(6, "Moon");
+ ps.setString(7, "17");
+ ps.setString(8, "Sol 455");
+ ps.setString(9, "Tge");
+ ps.setString(10, "AZERTY");
+ ps.setString(11, "de");
+ ps.setString(12, "");
+ ps.execute();
+ ps.setString(1, "english");
+ ps.setString(2, "english");
+ ps.setString(3, "English guy");
+ ps.setString(4, "Tseug");
+ ps.setString(5, "0032346534566564");
+ ps.setString(6, "Moon");
+ ps.setString(7, "17");
+ ps.setString(8, "Sol 455");
+ ps.setString(9, "Tge");
+ ps.setString(10, "AZERTY");
ps.setString(11, "en");
ps.setString(12, "");
ps.execute();
} catch (Exception e) {
e.printStackTrace();
}
-
+
log("____________________________________");
exit();
- }
-
+ }
+
private static void exit() {
log("Closing connection and exiting...");
try {
@@ -166,10 +205,10 @@
connection.close();
System.exit(1);
} catch (Exception e) {
- e.printStackTrace();
+ e.printStackTrace();
}
}
-
+
private static void seeContents(Connection connection) {
log("Printing the contents of the database...");
try {
@@ -181,7 +220,7 @@
rs.getString(DESCRIPTION)+tab+rs.getDouble(PRICE)+tab+
rs.getString(IMAGEURL));
}
-
+
sql = "SELECT * FROM "+PERSONENTITY;
rs = statement.executeQuery(sql);
log(EMAIL+tab+PASSWORD+tab+FIRSTNAME+tab+LASTNAME+tab+VISACARDNUMBER+
@@ -198,16 +237,16 @@
} catch (Exception e) {
e.printStackTrace();
}
-
+
exit();
}
-
+
private static void log(String s) {
- System.err.println(s);
+ System.err.println(s);
}
-
+
private static final String tab = "\t";
-
+
private static final String PERSONENTITY = "PERSONENTITY",
EMAIL = "EMAIL", //PK
PASSWORD = "PASSWORD",
@@ -221,7 +260,7 @@
COUNTRY = "COUNTRY",
LANGUAGELOCALE = "LANGUAGELOCALE",
COUNTRYLOCALE = "COUNTRYLOCALE";
-
+
private static final String PRODUCTENTITY = "PRODUCTENTITY",
ID = "ID", //PK
CATEGORY = "CATEGORY",
