<form name="form1" method="post" action="page1.jsp">
<%String propVal = request.getParameter("prop");
out.print(propVal);
if (propVal.equals("klcv")) {
//response.sendRedirect(response.encodeRedirectUrl("klcv_write_online_registration.jsp"));
String server = "localhost";
session.setAttribute("server", server);
String database = propVal;
session.setAttribute("database", database);
Class.forName("org.gjt.mm.mysql.Driver");
DriverManager.registerDriver((Driver) Class.forName("org.gjt.mm.mysql.Driver").newInstance());
String url = ("jdbc:mysql://"+server+"/"+database+"" );
Connection conn = (Connection)DriverManager.getConnection(url,"","");
String sql_1 = "SELECT * FROM smbyer INTO OUTFILE 'klcv_smbyer.txt' "+
"FIELDS TERMINATED BY '|' LINES TERMINATED BY '\r\n' ";
Statement stmt_1 = conn.createStatement();
ResultSet rset_1 = stmt_1.executeQuery(sql_1);
conn.close();
} else if (propVal.equals("sv")) {
//response.sendRedirect(response.encodeRedirectUrl("sv_write_online_registration.jsp"));
String server = "localhost";
session.setAttribute("server", server);
String database = propVal;
session.setAttribute("database", database);
Class.forName("org.gjt.mm.mysql.Driver");
DriverManager.registerDriver((Driver) Class.forName("org.gjt.mm.mysql.Driver").newInstance());
String url = ("jdbc:mysql://"+server+"/"+database+"" );
Connection conn = (Connection)DriverManager.getConnection(url,"","");
String sql_1 = "SELECT * FROM smbyer INTO OUTFILE 'sv_smbyer.txt' "+
"FIELDS TERMINATED BY '|' LINES TERMINATED BY '\r\n' ";
Statement stmt_1 = conn.createStatement();
ResultSet rset_1 = stmt_1.executeQuery(sql_1);
conn.close();
}
String brv= "brv";
session.setAttribute ("database", brv);%>
<h1> </h1>
<h1> </h1>
<META HTTP-EQUIV="refresh" CONTENT="2; URL=page1.jsp">
<h2 align="center"><font color="#000099">Data transfer completed!</font></h2>
</form>