日期:2014-05-16 浏览次数:20492 次
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!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 Call Value</title> </head> <script type="text/javascript" language="javascript"> function checkinput(){ var frm=document.getElementById("iform"); var input=frm.getElementsByTagName("input"); var textcount1=0; var textcount2=0; for(i=0;i<input.length;i++){ { if(input[i].type=="text"){ textcount1++; if(input[i].value==""||input[i].value=="0"){ textcount2++; } } } } if(textcount1==textcount2){ alert("请选择您要预订的房间及数量"); } } function checkname(){ var name=document.getElementsByName("name").value; if(name==""){ alert("姓名为空,请您认真填写"); } } checkreg=function(){ var _user=document.getElementById("iname"); var _clas=document.getElementById("iclas"); var _istuid=document.getElementById("istuid"); var _iterm=document.getElementById("iterm"); var _introduce=document.getElementById("iitroduce"); if(_user.value==""){ alert("请输入用户名称"); _user.focus(); return; } if(_clas.value==""){ alert("请输入班级,呵呵,朋友你错啦"); _clas.focus(); return; } if(_istuid.value==""){ alert("学号为空,请您认真填写"); _istuid.focus(); return; } if(_iterm.value==""){ alert("您的学期为空,请您认真填写"); _iterm.focus(); return; } if(_introduce.value==""){ alert("您的介绍为空,请认真填写,呵呵。朋友你错啦"); _introduce.focus(); return; } } </script> <body> <form id="iform" name="tform" method="method" action="two.jsp"> 姓名 <input id="iname" name="name" type="text" /><br/> 班级 <input id="iclas" name="clas" type="text" /><br/> 学号 <input id="istuid" name="stuid" type="text" /><br/> 学期 <input id="iterm" name="term" type="text" /><br/> 简介 <input id="iitroduce" name="introduce" type="text" /><br/> <input type="submit" value="提交" onclick="checkreg();" /><br/> </form> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@ page import="java.sql.*,java.util.*,java.text.*" %> <!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> <% String name=request.getParameter("name"); String clas=request.getParameter("clas"); String stuid=request.getParameter("stuid"); String term=request.getParameter("term"); String introduce=request.getParameter("introduce"); Connection conn=null; PreparedStatement ps=null; int i=0; try{ String url="jdbc:oracle:thin:@localhost:1521:orcl"; conn=DriverManager.getConnection(url,"zhang","zhang"); String sql="insert into call (name,class,stuid,term,introduce) values (?,?,?,?,?)"; ps=conn.prepareStatement(sql); ps.setString(1,name); ps.setString(2,clas); ps.setString(3,stuid); ps.setString(4,term); ps.setString(5,introduce); ps.executeUpdate(); }catch(Exception e){ e.printStackTrace(); }finally{ if(ps!=null){ ps.close(); } if(conn!=null){ conn.close(); } } out.println("//以下是从数据库里面读取出来的内容"); out.println("<br/>"); Connection connl=null; PreparedStatement psl=null; ResultSet rs=null; try{ String url="jdbc:oracle:thin:@localhost:1521:orcl"; conn=DriverManager.getConnection(url,"zhang","zhang"); String sql="select * from call order by createtime desc"; ps=conn.prepareStatement(sql); rs=ps.executeQuery(); while(rs.next()){ out.println("id:"+rs.getString("id")); out.println("-n