展开全部
在jsp中使用JavaScript获得性别标签填入的数据,然后使用jdbc插入到数据库中,实例如下:636f707962616964757a686964616f31333337616636
pageEncoding="UTF-8"%>
html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
注册密码/jsp/teacher_zhuce-js2.jsp" action="post">教师姓名:
教师密码:
教师权限:
pageEncoding="UTF-8"%>
html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
Test这是一个教师的注册页面
/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();
%>