運(yùn)行環(huán)境 tomcat5.5+MySql5.0
編寫一個(gè)簡單的HTML表單：
<html>
????<head>
????</head>
????<body>
????????<form?action="http://127.0.0.1/test/login.jsp"?method="post">
????????????????學(xué)號：<input?type="text"?name="id"><br>
????????????????姓名：<input?type="text"?name="name"><br>
????????????????<label>
??????<input?type="radio"?name="sex"?value="boy"?checked>
????????????男</label>
??????<label>
??????<input?type="radio"?name="sex"?value="girl">
????????????女</label><br>
????????????????電話:<input?type="text"?name="tel"><br>
????????????????<input?type="submit"?value="提交">
????????????????<input?type="reset"?value="重填">
????????</form>
????</body>
</html>接這編寫一個(gè)JSP文件用于讀取表單數(shù)據(jù)
Connection?conn?=?null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn?=?java.sql.DriverManager.getConnection("jdbc:mysql://localhost/mydb","root","corsair");
if(conn==null)
{
System.out.println("get?Conn?Error");
}
Statement?stmt=conn.createStatement();
ResultSet?rs=null;
%>
<%
????String?id,name,sex,tel;
????id=request.getParameter("id");
????name=request.getParameter("name");
????sex=request.getParameter("sex");
????tel=request.getParameter("tel");
????try{
????stmt.executeUpdate("INSERT?INTO?inf_student(id,name,sex,tel)?VALUES?('"+id+"','"+name+"','"+sex+"','"+tel+"')");
????}catch(SQLException?e){}
stmt.close();
conn.close();
%> 將以上文件保存在tomcat5.5的webapps目錄下；然后啟動(dòng)tomcat5.5和mysql數(shù)據(jù)庫，最后打開表單，插入數(shù)據(jù)提交，并可以mysqlQueryBrower查看到插入數(shù)據(jù)的情況了。