页面1:
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@page import="java.util.*,java.sql.*"%><html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>创建空白问卷</title>
</head><body> <h2>问卷信息</h2><div>
<form id="form1" name="form1" method="post" action="Wjxx.jsp">
<p>问卷名称</p>
<p>
<input type="text" name="wjmc" />
</p>
<p><font align="top">问卷描述</font></p>
<p>
<textarea name="wjms" rows="7"></textarea>
</p>
<p>出题人</p>
<p><input type="text" name="ctr"></p>
<p>
<%!
String transfer(int i) //将时间数值转换为标准格式
{
if(i>=10)
return (String.valueOf(i));
else
return ("0"+String.valueOf(i));
}
%> <%int year,month,day,hour,minute,second;
String time;
GregorianCalendar calendar;
calendar = new GregorianCalendar();
year = calendar.get(Calendar.YEAR);
month = calendar.get(Calendar.MONTH)+1;
day = calendar.get(Calendar.DAY_OF_MONTH);
hour = calendar.get(Calendar.HOUR_OF_DAY);
minute = calendar.get(Calendar.MINUTE);
second = calendar.get(Calendar.SECOND);
time = year +"-"+transfer(month)+"-" + transfer(day) +" "+transfer(hour)+":"+transfer(minute)+":"+transfer(second);
%>
<p>出题时间:</p>
<p><input type="text" name="time" value="<%=time%>"></p>
<p>
<input type="submit" name="Submit" value="提交" />
</p>
</form></div>
</body>
</html>
=================================================
页面2:Wjxx.jsp
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@page import="com.liuning.Wjxx"%>
<%@page import="com.liuning.WriteinWjxx"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:useBean id="wjxx" scope="session" class="com.liuning.Wjxx">
<jsp:setProperty name="wjxx" property="*"/>
</jsp:useBean><jsp:useBean id="writeinwjxx" scope="session" class="com.liuning.WriteinWjxx"/>
<%
writeinwjxx.setWjxx(wjxx);
writeinwjxx.write();
%>
<HTML>
<HEAD>
<TITLE> show the wjxx in the table </TITLE>
</HEAD>
<BODY>
<p align="center"><strong>问卷信息</strong></p>
<hr>
<TABLE width="100%" align="center" border=0 brcolor=99ccff cellspacing="0" cellpadding="0" bordercolordark="#000000" bordercolorlight="#CCCC99">
<tr><td >问卷名称:</td>
<td><%=wjxx.getWjmc()%></td></tr>
<tr><td>问卷描述:</td>
<td>
<%=wjxx.getWjms()%>
</td></tr>
<tr><td >出 题 人:</td>
<td>
<%=wjxx.getCtr()%>
</td></tr>
<tr><td >出题时间:</td><td colspan=3>
<%
out.println("<font size=2>"+wjxx.getTime()+"</font>");
%>
</td></tr>
</table>
<hr>
<%
out.println(writeinwjxx.getWjbh());
session.setAttribute("wjbh",(Integer)writeinwjxx.getWjbh());
%>
<h2>请为问卷添加题目</h2>
<table width="400" height="65" border="0" align="left">
<tr>
<td width="180" height="61" align="left" valign="top"><h3>请先选择题目类型</h3></td>
<td width="210">
<form id="form2" name="form2" method="post" action="tx.jsp">
<select name="tx">
<option>请选择题型</option>
<option value="tk">填空题</option>
<option value="dan">单项选择题</option>
<option value="duo">多项选择题</option>
<option value="jd">简答题</option>
</select>
<p><input type="submit" value="提交">
</form>
</td>
</tr>
</table>
<p></body>
</html>===============================================
Wjxx.java
package com.liuning;
public class Wjxx {
private String wjmc;
private String wjms;
private String ctr;
private String time;public void setWjmc(String wjmc){
this.wjmc=wjmc;
}public void setWjms(String wjms){
this.wjms=wjms;
}public void setCtr(String ctr){
this.ctr=ctr;
}public void setTime(String time){
this.time=time;
}public String getWjmc(){
return this.wjmc;
}public String getWjms(){
return this.wjms;
}public String getCtr(){
return this.ctr;
}public String getTime(){
return this.time;
}}
========================================
WrintinWjxx.java
package com.liuning; import java.sql.*;
import java.util.Calendar;
import java.util.GregorianCalendar; public class WriteinWjxx {
private Wjxx wjxx;
private Connection con;
private Statement smt; private int wjbh;
private String sql; public WriteinWjxx(){
try{
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ").newInstance();
String url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=wj ";
con= DriverManager.getConnection(url, "wj ", "wj ");
smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
}
catch(Exception e){
e.printStackTrace();
}
} public void setWjxx(Wjxx wjxx){
this.wjxx=wjxx;
} public void write() throws Exception{ try{ sql= "insert into wjxx(wjmc,wjms,ctr,time) values( ' "+wjxx.getWjmc()+ " ', ' "+wjxx.getWjms()+ " ', ' "+wjxx.getCtr()+ " ', ' "+wjxx.getTime()+ " ') ";
smt.executeUpdate(sql);//这里报错!! nullpointexcption?
}catch(Exception e){
e.printStackTrace();
throw e;
}
}
}
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@page import="java.util.*,java.sql.*"%><html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>创建空白问卷</title>
</head><body> <h2>问卷信息</h2><div>
<form id="form1" name="form1" method="post" action="Wjxx.jsp">
<p>问卷名称</p>
<p>
<input type="text" name="wjmc" />
</p>
<p><font align="top">问卷描述</font></p>
<p>
<textarea name="wjms" rows="7"></textarea>
</p>
<p>出题人</p>
<p><input type="text" name="ctr"></p>
<p>
<%!
String transfer(int i) //将时间数值转换为标准格式
{
if(i>=10)
return (String.valueOf(i));
else
return ("0"+String.valueOf(i));
}
%> <%int year,month,day,hour,minute,second;
String time;
GregorianCalendar calendar;
calendar = new GregorianCalendar();
year = calendar.get(Calendar.YEAR);
month = calendar.get(Calendar.MONTH)+1;
day = calendar.get(Calendar.DAY_OF_MONTH);
hour = calendar.get(Calendar.HOUR_OF_DAY);
minute = calendar.get(Calendar.MINUTE);
second = calendar.get(Calendar.SECOND);
time = year +"-"+transfer(month)+"-" + transfer(day) +" "+transfer(hour)+":"+transfer(minute)+":"+transfer(second);
%>
<p>出题时间:</p>
<p><input type="text" name="time" value="<%=time%>"></p>
<p>
<input type="submit" name="Submit" value="提交" />
</p>
</form></div>
</body>
</html>
=================================================
页面2:Wjxx.jsp
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@page import="com.liuning.Wjxx"%>
<%@page import="com.liuning.WriteinWjxx"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:useBean id="wjxx" scope="session" class="com.liuning.Wjxx">
<jsp:setProperty name="wjxx" property="*"/>
</jsp:useBean><jsp:useBean id="writeinwjxx" scope="session" class="com.liuning.WriteinWjxx"/>
<%
writeinwjxx.setWjxx(wjxx);
writeinwjxx.write();
%>
<HTML>
<HEAD>
<TITLE> show the wjxx in the table </TITLE>
</HEAD>
<BODY>
<p align="center"><strong>问卷信息</strong></p>
<hr>
<TABLE width="100%" align="center" border=0 brcolor=99ccff cellspacing="0" cellpadding="0" bordercolordark="#000000" bordercolorlight="#CCCC99">
<tr><td >问卷名称:</td>
<td><%=wjxx.getWjmc()%></td></tr>
<tr><td>问卷描述:</td>
<td>
<%=wjxx.getWjms()%>
</td></tr>
<tr><td >出 题 人:</td>
<td>
<%=wjxx.getCtr()%>
</td></tr>
<tr><td >出题时间:</td><td colspan=3>
<%
out.println("<font size=2>"+wjxx.getTime()+"</font>");
%>
</td></tr>
</table>
<hr>
<%
out.println(writeinwjxx.getWjbh());
session.setAttribute("wjbh",(Integer)writeinwjxx.getWjbh());
%>
<h2>请为问卷添加题目</h2>
<table width="400" height="65" border="0" align="left">
<tr>
<td width="180" height="61" align="left" valign="top"><h3>请先选择题目类型</h3></td>
<td width="210">
<form id="form2" name="form2" method="post" action="tx.jsp">
<select name="tx">
<option>请选择题型</option>
<option value="tk">填空题</option>
<option value="dan">单项选择题</option>
<option value="duo">多项选择题</option>
<option value="jd">简答题</option>
</select>
<p><input type="submit" value="提交">
</form>
</td>
</tr>
</table>
<p></body>
</html>===============================================
Wjxx.java
package com.liuning;
public class Wjxx {
private String wjmc;
private String wjms;
private String ctr;
private String time;public void setWjmc(String wjmc){
this.wjmc=wjmc;
}public void setWjms(String wjms){
this.wjms=wjms;
}public void setCtr(String ctr){
this.ctr=ctr;
}public void setTime(String time){
this.time=time;
}public String getWjmc(){
return this.wjmc;
}public String getWjms(){
return this.wjms;
}public String getCtr(){
return this.ctr;
}public String getTime(){
return this.time;
}}
========================================
WrintinWjxx.java
package com.liuning; import java.sql.*;
import java.util.Calendar;
import java.util.GregorianCalendar; public class WriteinWjxx {
private Wjxx wjxx;
private Connection con;
private Statement smt; private int wjbh;
private String sql; public WriteinWjxx(){
try{
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ").newInstance();
String url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=wj ";
con= DriverManager.getConnection(url, "wj ", "wj ");
smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
}
catch(Exception e){
e.printStackTrace();
}
} public void setWjxx(Wjxx wjxx){
this.wjxx=wjxx;
} public void write() throws Exception{ try{ sql= "insert into wjxx(wjmc,wjms,ctr,time) values( ' "+wjxx.getWjmc()+ " ', ' "+wjxx.getWjms()+ " ', ' "+wjxx.getCtr()+ " ', ' "+wjxx.getTime()+ " ') ";
smt.executeUpdate(sql);//这里报错!! nullpointexcption?
}catch(Exception e){
e.printStackTrace();
throw e;
}
}
}
把异常贴上来研究一下
异常如下:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NullPointerException
com.bean.WriteinWjxx.write(WriteinWjxx.java:36)
org.apache.jsp.Wjxx_jsp._jspService(Wjxx_jsp.java:75)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.0.28
在TOMCAT那个work目录下,你看看。。
这里面可能没取到值........