Linux-jsp-jdbc-mysql Test-Insert

Js|mysql <%--
Author: He Zhiqiang [hhzqq@21cn.com]
Date: 2000-08-04
Function: Linux-jsp-jdbc-mysql test-Insert
--%>

<%
Statement
Java.sql.Connection sqlconn;//Database Connection objects
Java.sql.Statement sqlstmt;//Statement Object
Java.lang.String strname;//data from the client: name
Long lngage;//data from the client: Age

Registering JDBC Drivers
Class.forName ("Org.gjt.mm.mysql.Driver"). newinstance ();

Connecting to a database
Sqlconn = Java.sql.DriverManager.getConnection ("Jdbc:mysql://localhost/test", "Test", "test");

To create a statement object
sqlstmt = Sqlconn.createstatement ();

Get data from the client
StrName = Request.getparameter ("name");
Lngage = Java.lang.Long.parseLong (Request.getparameter ("Age"), 10);

Execute SQL statement
Sqlstmt.executeupdate ("INSERT into Test (name,age) VALUES (' +strname+" ', "+lngage+") ");

Close Statement Object
Sqlstmt.close ();

To close a database connection
Sqlconn.close ();
%>

<jsp:forward page= "select.jsp"/>