jsp 向数据库中插入一条数据
已知Mysql数据库student中有表xs(xh char(10),xm char(8),cj int(2))，Mysql中user=root,password=root。设计一个页面show_xs.jsp,插入记录（“08013001”，“赵六”，97）
你把以下代码复制过去创建2哥jsp文件即可
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="ww" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>注册密码</title>
</head>
<body>
<form name="pageName" action="<%=request.getContextPath()%>/jsp/teacher_zhuce-js2.jsp" action="post">
教师姓名：<INPUT type="text" name="TEA_NAME" maxlength="30"><br>
教师密码：<INPUT type="text" name="TEA_PASSWORD" maxlength="30" ><br>
教师权限：<INPUT type="text" name="TEA_QUAN_ID" maxlength="30" /><br>
<INPUT type="submit" maxlength="15" value="注册" >
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="ww" %>
<%@ page import="java.sql.*" %>
<%@ page import="login.Teacher" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Test</title>
</head>
<body>
这是一个教师的注册页面
<form method="post" action="<%=request.getContextPath() %>/jsp/tea_zhuce_jie.jsp">
<%
//页面的值
Connection con;
Statement stmt;
ResultSet rs;
//加载驱动程序，下面的代码为加载JDBD-ODBC驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
//用适当的驱动程序连接到数据库，test"是系统dsn名
String url="jdbc:oracle:thin:@localhost:1521:lxq";
//建立连接，类似于ASP中的创建数据库联接
con=DriverManager.getConnection(url, "jobTable", "jobTable");
//查询该记录是否存在
stmt=con.createStatement();
String sql="insert into teacher(tea_id, tea_name, tea_password, tea_quan_id)values(lxq.nextval, ?, ?, ?)";
PreparedStatement pst = con.prepareStatement(sql);
Teacher tea=new Teacher();
//String TEA_ID = request.getParameter("TEA_ID");
String TEA_NAME = request.getParameter("TEA_NAME");
String TEA_PASSWORD = request.getParameter("TEA_PASSWORD");
String TEA_QUAN_ID = request.getParameter("TEA_QUAN_ID");
//pst.setString(1,TEA_ID);
pst.setString(1,TEA_NAME);
pst.setString(2,TEA_PASSWORD);
pst.setString(3,TEA_QUAN_ID);
pst.executeUpdate();
%>
<br><br>
<input type="submit" name="display" value="显示数据">
<input type="reset" value="重设">
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="ww" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>注册密码</title>
</head>
<body>
<form name="pageName" action="<%=request.getContextPath()%>/jsp/teacher_zhuce-js2.jsp" action="post">
教师姓名：<INPUT type="text" name="TEA_NAME" maxlength="30"><br>
教师密码：<INPUT type="text" name="TEA_PASSWORD" maxlength="30" ><br>
教师权限：<INPUT type="text" name="TEA_QUAN_ID" maxlength="30" /><br>
<INPUT type="submit" maxlength="15" value="注册" >
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="ww" %>
<%@ page import="java.sql.*" %>
<%@ page import="login.Teacher" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Test</title>
</head>
<body>
这是一个教师的注册页面
<form method="post" action="<%=request.getContextPath() %>/jsp/tea_zhuce_jie.jsp">
<%
//页面的值
Connection con;
Statement stmt;
ResultSet rs;
//加载驱动程序，下面的代码为加载JDBD-ODBC驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
//用适当的驱动程序连接到数据库，test"是系统dsn名
String url="jdbc:oracle:thin:@localhost:1521:lxq";
//建立连接，类似于ASP中的创建数据库联接
con=DriverManager.getConnection(url, "jobTable", "jobTable");
//查询该记录是否存在
stmt=con.createStatement();
String sql="insert into teacher(tea_id, tea_name, tea_password, tea_quan_id)values(lxq.nextval, ?, ?, ?)";
PreparedStatement pst = con.prepareStatement(sql);
Teacher tea=new Teacher();
//String TEA_ID = request.getParameter("TEA_ID");
String TEA_NAME = request.getParameter("TEA_NAME");
String TEA_PASSWORD = request.getParameter("TEA_PASSWORD");
String TEA_QUAN_ID = request.getParameter("TEA_QUAN_ID");
//pst.setString(1,TEA_ID);
pst.setString(1,TEA_NAME);
pst.setString(2,TEA_PASSWORD);
pst.setString(3,TEA_QUAN_ID);
pst.executeUpdate();
%>
<br><br>
<input type="submit" name="display" value="显示数据">
<input type="reset" value="重设">
</form>
</body>
</html>
温馨提示：内容为网友见解，仅供参考
无其他回答
相似回答
