<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.util.*"%>
<%@ page import="dbcore.*"%>
<%@ page import="java.lang.*"%>
<%@ page import="java.sql.*"%>
Map insert page
<%
String driver = "com.mysql.jdbc.Driver";
String jdbc = "jdbc:mysql:";
String database = "//localhost:3306/MapCollection";
String username = "root", password = "root";
String insertcmd, mapid, maptype, countries;
String[] country;
int mapscale=0;
boolean transOK = true;
// create connection
DatabaseAccess db = new DatabaseAccess();
db.loadDriver(driver);
db.connectDatabase(jdbc + database, username, password);
db.autoCommit(false);
//form data
mapid = request.getParameter("mapid");
mapscale = Integer.parseInt(request.getParameter("mapscale"));
maptype = request.getParameter("maptype");
country = request.getParameterValues("countries");
// insert the map
try {
insertcmd = "INSERT INTO map VALUES (" + "'" + mapid + "',"
+ mapscale + "," + "'" + maptype + "'" + ");";
db.insertTransactionSQL(insertcmd);
// insert the countries
for (int loopInx = 0; loopInx < country.length; loopInx++) {
insertcmd = "INSERT INTO mapCountry VALUES (" + "'"
+ mapid + "'," + "'" + country[loopInx] + "'" + ");";
db.insertTransactionSQL(insertcmd);
}
}
catch (InsertException error) {
System.out.println("Insert error");
transOK = false;
}
if (transOK) {
db.dbCommit(); // all inserts successful
}
else {
db.dbRollback(); // at least one insert failed
}
db.dbClose();
%>