Java+Web+应用程序开发试题库6
Java Web 程序开发试题6JSP（二）【作业】1. 创建表单收集客户的基本信息，然后存入数据库当中<form action="c2s" method="post"> <input type="text" name="EMPNO" placeholder="编号"><br /> <input type="text" name="ENAME" placeholder="姓名"><br /> <input type="text" name="JOB" placeholder="职位"><br /> <input type="text" name="MGR" placeholder="经理"><br /> <input type="date" name="HIREDATE" placeholder="入职时间"><br /> <input type="text" name="SAL" placeholder="工资"><br /> <input type="text" name="COMM" placeholder="奖金"><br /> <input type="text" name="DEPTNO" placeholder="部门"><br /> <input type="submit" value="提交"> </form>public void service(ServletRequest req, ServletResponse res)throws ServletException, IOException System.out.println("啊实打实大声道");res.setContentType("text/html");PrintWriter out = res.getWriter();String EMPNO=req.getParameter("EMPNO");String ENAME=req.getParameter("ENAME");String JOB=req.getParameter("JOB");String MGR=req.getParameter("MGR");String HIREDATE=req.getParameter("HIREDATE");String SAL=req.getParameter("SAL");String COMM=req.getParameter("COMM");String DEPTNO=req.getParameter("DEPTNO");SimpleDateFormat sdf= new SimpleDateFormat("d-M月-yy");String sql="insert into emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values ("+EMPNO+","+ENAME+","+JOB+","+MGR+","+sdf.format(new Date()+","+SAL+","+COMM+","+DEPTNO+")"System.out.println(sql);try boolean rs= SqlHelper.getQueryResult(sql);/此处添加response响应 catch (Exception e) System.out.println(e);2. 利用response将上题中写入数据库的内容发回客户端res.getWriter().println("<h1>"+EMPNO+","+ENAME+","+JOB+","+MGR+","+new Date()+","+SAL+","+COMM+","+DEPTNO+"</h1>");【思考题】1. 我们可以使用<%.%>脚本为什么还要利用out对象？通过out对象等效于直接在设计页面时输入的HTML文本。使用out可以通过一定的条件选择输出不同的文本或者不输出,并且可以提高代码简洁性。
