tag:blogger.com,1999:blog-5753708308358578222024-02-20T16:52:40.847-08:00Simple ThinkingAnonymoushttp://www.blogger.com/profile/13909274394205982429noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-575370830835857822.post-47797469840028619552012-04-18T03:09:00.000-07:002012-04-18T03:14:31.412-07:00How to get MySQL AUTO_INCREMENT field in JSP?<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<b>Database Table:<o:p></o:p></b></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
CREATE TABLE
STUDENT</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
(</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
SID INT AUTO_INCREMENT,</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
SNAME VARCHAR (100),</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
SAGE INT,</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
CONSTRAINT student_id_pk PRIMARY
KEY (SID)</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
); </div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<b><span style="font-size: 17pt; line-height: 115%;">JSP:<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<b><span style="font-size: 12pt; line-height: 115%;">Procedure 1 :<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%-- </div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
Document
: studentReg</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
Created on : Apr 14, 2012, 7:23:48 PM</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
Author
: pkjana</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
--%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.SQLException"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.DriverManager"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.ResultSet"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.Statement"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.PreparedStatement"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.Connection"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
contentType="text/html" pageEncoding="UTF-8"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<!DOCTYPE
html></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<html></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<head></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<meta
http-equiv="Content-Type" content="text/html;
charset=UTF-8"></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<title>JSP Page</title></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
</head></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<body></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%! </div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm; text-indent: 36.0pt;">
Connection conn = null;</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
PreparedStatement
ps = null;</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ResultSet
rs = null;</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
try {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
DriverManager.registerDriver(new com.mysql.jdbc.Driver());</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/otbdc",
"userid", "password");</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
String sql = "INSERT INTO
STUDENT (SID, SNAME, SAGE) VALUES(?,?,?)";</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps = conn.prepareStatement(sql,
Statement.RETURN_GENERATED_KEYS);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.setInt(1, 0);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.setString(2,
"Brahma");</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.setInt(3, 10);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
int returnLastInsertId =
ps.executeUpdate();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
if (returnLastInsertId != -1) {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
rs = ps.getGeneratedKeys();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
rs.next();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
out.println("STUDENT
ID: " + rs.getInt(1));</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
}</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
} catch (Exception e) {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
out.println("Error:"
+e);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
} finally { </div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
try {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
rs.close();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.close();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
conn.close();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
} catch (SQLException e) {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
out.println("Error:" + e);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
}</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
}</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
</body></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
</html></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<b><span style="font-size: 12pt; line-height: 115%;">Procedure 2 :( By Table Column Name)<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%-- </div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
Document
: studentReg</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
Created on : Apr 14, 2012, 7:23:48 PM</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
Author
: pkjana</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
--%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.SQLException"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.DriverManager"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.ResultSet"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.Statement"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.PreparedStatement"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.Connection"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
contentType="text/html" pageEncoding="UTF-8"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<!DOCTYPE
html></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<html></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<head></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<meta
http-equiv="Content-Type" content="text/html;
charset=UTF-8"></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<title>JSP Page</title></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
</head></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<body></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%! </div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
Connection conn = null;</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
PreparedStatement ps = null;</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ResultSet rs = null;</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
try {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
DriverManager.registerDriver(new com.mysql.jdbc.Driver());</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
conn =
DriverManager.getConnection("jdbc:mysql://localhost:3306/otbdc",
"userid", "password");</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
String sql = "INSERT INTO
STUDENT (SID, SNAME, SAGE) VALUES (?,?,?)";</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
String rv[] =
{"SID"};</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps = conn.prepareStatement(sql,
rv);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.setInt(1, 0);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.setString(2, "Krishna");</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.setInt(3, 12);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
int returnLastInsertId =
ps.executeUpdate();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
if (returnLastInsertId != -1) {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
rs = ps.getGeneratedKeys();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
rs.next();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
out.println("STUDENT
ID: " + rs.getInt(1));</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
}</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
} catch (Exception e) {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
out.println("Error:"
+e);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
} finally { </div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
try {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
rs.close();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.close();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
conn.close();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
} catch (SQLException e) {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
out.println("Error:" + e);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
}</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
}</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
</body></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
</html></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<b><span style="font-size: 12pt; line-height: 115%;">Procedure 3 :( By Table Column Index)<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%-- </div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
Document
: studentReg</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
Created on : Apr 14, 2012, 7:23:48 PM</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
Author
: pkjana</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
--%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.SQLException"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.DriverManager"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.ResultSet"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.Statement"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.PreparedStatement"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
import="java.sql.Connection"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%@page
contentType="text/html" pageEncoding="UTF-8"%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<!DOCTYPE
html></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<html></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<head></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<meta
http-equiv="Content-Type" content="text/html; charset=UTF-8"></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<title>JSP Page</title></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
</head></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<body></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%! </div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
Connection conn = null;</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
PreparedStatement ps = null;</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ResultSet rs = null;</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<%</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
try {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
DriverManager.registerDriver(new com.mysql.jdbc.Driver());</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
conn =
DriverManager.getConnection("jdbc:mysql://localhost:3306/otbdc",
"userid", "password");</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
String sql = "INSERT INTO
STUDENT (SID, SNAME, SAGE) VALUES (?,?,?)";</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
int rtv[]={1};</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm; text-indent: 36.0pt;">
ps = conn.prepareStatement(sql,
rtv);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.setInt(1, 0);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.setString(2, "Siba");</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.setInt(3, 20);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
int returnLastInsertId =
ps.executeUpdate();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
if (returnLastInsertId != -1) {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
rs = ps.getGeneratedKeys();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
rs.next();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
out.println("STUDENT
ID: " + rs.getInt(1));</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
}</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
} catch (Exception e) {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
out.println("Error:"
+e);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
} finally { </div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
try {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
rs.close();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
ps.close();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
conn.close();</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
} catch (SQLException e) {</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
out.println("Error:" + e);</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
}</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
}</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
%></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
</body></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
</html></div>
</div>Anonymoushttp://www.blogger.com/profile/13909274394205982429noreply@blogger.com0