package server.servlets;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class Execute {
public static String getSql(
String firstname,
String middlename,
String lastname,
String address1,
String address2,
String phone1,
String phone2,
String phone3) {
return "insert into phonelist"
+ "(firstname,middlename, lastname,"
+ "address1,address2,phone1,phone2,phone3) values "
+ "(" + quote(firstname)
+ quote(middlename)
+ quote(lastname)
+ quote(address1)
+ quote(address2)
+ quote(phone1)
+ quote(phone2)
+ nocommaQuote(phone3) + ")";
}
public static String nocommaQuote(String s) {
return "'" + s + "'";
}
public static String quote(String s) {
return "'" + s + "',";
}
public static void main(String args[]) {
String sql = getSql("doug", "adams", "lyon", "1313", "mockingbird lane",
"203-877-0899", "9990999", "1234567");
System.out.println(sql);
Execute.statement(sql);
}
public static void test1(String args[]) {
Execute.statement(
"insert into phonelist(firstname,lastname) values ('doug','lyon')"
);
}
public static void statement(String sql) {
try {
String url = server.db.SqlBean.getUrl();
String driver = server.db.SqlBean.getDriver();
System.out.println("trying sql statement:" + sql);
Class.forName(driver).newInstance();
Connection c = DriverManager.getConnection(
url, server.db.SqlBean.getUserId(), server.db.SqlBean.getPassword()
);
Statement s = c.createStatement();
s.execute(sql);
s.close();
c.close();
System.out.println("it worked! Now I am the destroyer of worlds!");
} catch (Exception e) {
e.printStackTrace();
}
}
}