一、文件名:insert1.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*, java.util.* , java.io.* " %>
<div align="center"><h2> 学生入库信息 </h2>
<form method="post" action="Test.jsp">
<p>学生学号:<input type="text" name="sno" ></P>
<P>学生姓名:<input type="text" name="sname"></P>
<P>学生性别:<input type="text" name="ssex"></P>
<P>学生年龄:<input type="text" name="sage"></P>
<p><input type="submit" value="提交"></P>
</form></div>
二、文件名:Test.jsp
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*, java.util.* , java.io.* " %>
<%
String driverName="com.mysql.jdbc.driver";
String userName="root";
String userPasswd="123";
String dbName="student";
String tableName="stu";
String url="jdbc:mysql://localhost:3306/"+dbName;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection(url,userName,userPasswd);
Statement stmt=conn.createStatement();
String sno=request.getParameter("sno");
String sname=request.getParameter("sname");
String ssex=request.getParameter("ssex");
String sage=request.getParameter("sage");
if(sno.equals("")|sname.equals("")|ssex.equals("")|sage.equals(""))
{response.sendRedirect("Da.jsp");}
else{
String sql="insert into stu(sno,sname,ssex,sage) values("+"'"+sno+"'"+","+"'"+sname+"'"+","+"'"+ssex+"'"+","+"'"+sage+"'"+");";
stmt.executeUpdate(sql);
out.print("数据添加成功!");
}
stmt.close();
conn.close();
%>