<%@ 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>
ORACLE数据库插入记录
最新推荐文章于 2024-04-23 10:32:10 发布