Auto_Increment
Hvordan kan jeg lave en auto_increment i jsp?!Jeg har Person_ID som skal være en auto_increment. I mysql Person_ID er en auto_increment men hvad ellers skal jeg gøre i selve koden?!
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page contentType="text/html; charset=Windows-1251"%>
<%
String ID;
String FirstName,LastName,DateOfBirth,Street,Nr,ZipCode,City,Country,Telephone,Fax,Email,Occupation,Sex,Record,HandicapClass;
String Tournement_ID = "";
String title = "Register";
try {
/* connect (commented out strings use classic MySQL driver) */
ID = request.getParameter("ID");
FirstName = request.getParameter("FirstName");
LastName = request.getParameter("LastName");
DateOfBirth = request.getParameter("DateOfBirth");
Street = request.getParameter("Street");
Nr = request.getParameter("Nr");
ZipCode = request.getParameter("ZipCode");
City = request.getParameter("City");
Country = request.getParameter("Country");
Telephone = request.getParameter("Telephone");
Fax = request.getParameter("Fax");
Email = request.getParameter("Email");
Occupation = request.getParameter("Occupation");
Sex = request.getParameter("Sex");
Record = request.getParameter("Record");
HandicapClass = request.getParameter("HandicapClass");
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/database", "sss", "sss");
con.setAutoCommit(true);
Statement st = con.createStatement();
/* do registration */
java.util.Date DateOfRegistered = new java.util.Date();
st.executeUpdate("INSERT INTO person(FirstName, LastName, DateOfBirth, DateOfRegistered, Street, Number, ZipCode, City, Country, Telephone, Fax, Email, Occupation, Sex) VALUES('" + FirstName + "','" + LastName + "','" + DateOfBirth +"','" + DateOfRegistered +"','" + Street +"','" + Nr +"','" + ZipCode +"','" + City +"','" + Country +"','" + Telephone +"','" + Fax +"','" + Email +"','" + Occupation +"','" + Sex +"')");
st.executeUpdate("INSERT INTO athlete(Tournement_ID, Record, HandicapClass) VALUES('" + Tournement_ID + "','" + Record + "','" + HandicapClass +"')");
%>
<%
st.close();
} catch (Exception e) {
throw (new ServletException(e));
}
%>
