i have this code:
<HTML><HEAD><TITLE>Dynamic Form</TITLE></HEAD>
<BODY>
<%@ page import = "java.sql.*"%>
<%@ page import = "java.sql.SQLException"%>
<%@ page import = "javax.sql.rowset.CachedRowSet"%>
<%@ page import = "java.util.ArrayList"%>
<%@ page import = "com.sun.rowset.CachedRowSetImpl"%>
<CENTER>
<%
String Name = request.getParameter("FillName");
String SubjectS = request.getParameter("subject");
String EmailP = request.getParameter("email");
String Qtype1 = request.getParameter("Question1");
String Qtype2 = request.getParameter("Question2");
String b = request.getParameter("rating");
String connectionURL
= "jdbc:mysql://localhost/createquestions";
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
ResultSetMetaData metaData = null;
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection (connectionURL, "root", "");
statement = connection.createStatement();
//to register the information for the questions generator.
String query = "insert into publishers (publisherName,publisherSubject,publisherEmail) values('"+Name+"','"+SubjectS+"','"+EmailP+"')";
int d=statement.executeUpdate(query);
.
.
.
when i click refresh icon i got same registerd information in my data base i want to avoid this replication.
Oh, if forgot the idea of this code is to resive users and register thier informations in data base allow them to choose type of questions that they want to create them.
[ March 02, 2006: Message edited by: Bear Bibeault ]
<HTML><HEAD><TITLE>Dynamic Form</TITLE></HEAD>
<BODY>
<%@ page import = "java.sql.*"%>
<%@ page import = "java.sql.SQLException"%>
<%@ page import = "javax.sql.rowset.CachedRowSet"%>
<%@ page import = "java.util.ArrayList"%>
<%@ page import = "com.sun.rowset.CachedRowSetImpl"%>
<CENTER>
<%
String Name = request.getParameter("FillName");
String SubjectS = request.getParameter("subject");
String EmailP = request.getParameter("email");
String Qtype1 = request.getParameter("Question1");
String Qtype2 = request.getParameter("Question2");
String b = request.getParameter("rating");
String connectionURL
= "jdbc:mysql://localhost/createquestions";
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
ResultSetMetaData metaData = null;
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection (connectionURL, "root", "");
statement = connection.createStatement();
//to register the information for the questions generator.
String query = "insert into publishers (publisherName,publisherSubject,publisherEmail) values('"+Name+"','"+SubjectS+"','"+EmailP+"')";
int d=statement.executeUpdate(query);
.
.
.
when i click refresh icon i got same registerd information in my data base i want to avoid this replication.
Oh, if forgot the idea of this code is to resive users and register thier informations in data base allow them to choose type of questions that they want to create them.
[ March 02, 2006: Message edited by: Bear Bibeault ]