查询的结果可以正常显示出来
但是输入后点提交按钮 跳转到newDatabase.jsp 却是个空白页 没有报错
修改纪录和添加纪录都是这样的问题********************************<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<P>添加新的记录到数据库:
<hr>
<FORM action="newDatabase.jsp" method=post>
同学学号:
<Input type="text" name="id">
<BR>同学姓名:
<Input type="text" name="name">
<BR>性别:
<Input type="text" name="sex">
<BR>年龄:
<Input type="text" name="age">
<BR><Input type="submit" name="b" value="提交添加">
<hr>
<P>数据库添加记录前的数据记录是:
<%
String name,sex;
int id,age;
Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try { con=DriverManager.getConnection("jdbc:odbc:GDMS","sa","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM Students");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"学号");
out.print("<TH width=100>"+"姓名");
out.print("<TH width=50>"+"性别");
out.print("<TH width=50>"+"年龄 ");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
id=rs.getInt(1);
out.print("<TD >"+id+"</TD>");
name=rs.getString(2);
out.print("<TD >"+name+"</TD>");
sex=rs.getString(3);
out.print("<TD >"+sex+"</TD>");
age=rs.getInt(4);
out.print("<TD >"+age+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
}
catch(SQLException e1) {}
%>
</form>
</BODY>
</HTML>
**********newDatabase.jsp*************
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<% //获取提交的学号:
String id=request.getParameter("id");
if(id==null)
{
id="";
}
byte b[]=id.getBytes("ISO-8859-1");
id=new String(b);
//获取提交的姓名:
String name=request.getParameter("name");
if(name==null)
{
name="";
}
byte c[]=name.getBytes("ISO-8859-1");
name=new String(c);
//获取提交的新的性别:
String s=request.getParameter("sex");
if(s==null)
{
s="";
}
//获取提交的新的年龄:
String a=request.getParameter("age");
if(a==null)
{
a="";
}
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException event){}
try {
con=DriverManager.getConnection("jdbc:odbc:GDMS","sa","");
sql=con.createStatement();
String condition=
"INSERT INTO students VALUES"+"("+"'"+id+"','"+name+"',"+s+","+a+")";
sql.executeUpdate(condition); //执行添加操作。
//显示添加新记录后表中的记录:
%>
<P>添加新记录后的表:
<%
rs=sql.executeQuery("SELECT * FROM Students ORDER BY ID ");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"学号");
out.print("<TH width=100>"+"姓名");
out.print("<TH width=50>"+"性别");
out.print("<TH width=50>"+"年龄");
out.print("</TR>");
while(rs.next())
{
out.print("<TR>");
String n=rs.getString(1);
out.print("<TD >"+n+"</TD>");
String xingming=rs.getString(2);
out.print("<TD >"+xingming+"</TD>");
String sex=rs.getString(3);
out.print("<TD >"+sex+"</TD>");
int age=rs.getInt(4);
out.print("<TD >"+age+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
}
catch(SQLException event)
{ }
%>
</BODY>
</HTML>
但是输入后点提交按钮 跳转到newDatabase.jsp 却是个空白页 没有报错
修改纪录和添加纪录都是这样的问题********************************<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<P>添加新的记录到数据库:
<hr>
<FORM action="newDatabase.jsp" method=post>
同学学号:
<Input type="text" name="id">
<BR>同学姓名:
<Input type="text" name="name">
<BR>性别:
<Input type="text" name="sex">
<BR>年龄:
<Input type="text" name="age">
<BR><Input type="submit" name="b" value="提交添加">
<hr>
<P>数据库添加记录前的数据记录是:
<%
String name,sex;
int id,age;
Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try { con=DriverManager.getConnection("jdbc:odbc:GDMS","sa","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM Students");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"学号");
out.print("<TH width=100>"+"姓名");
out.print("<TH width=50>"+"性别");
out.print("<TH width=50>"+"年龄 ");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
id=rs.getInt(1);
out.print("<TD >"+id+"</TD>");
name=rs.getString(2);
out.print("<TD >"+name+"</TD>");
sex=rs.getString(3);
out.print("<TD >"+sex+"</TD>");
age=rs.getInt(4);
out.print("<TD >"+age+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
}
catch(SQLException e1) {}
%>
</form>
</BODY>
</HTML>
**********newDatabase.jsp*************
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<% //获取提交的学号:
String id=request.getParameter("id");
if(id==null)
{
id="";
}
byte b[]=id.getBytes("ISO-8859-1");
id=new String(b);
//获取提交的姓名:
String name=request.getParameter("name");
if(name==null)
{
name="";
}
byte c[]=name.getBytes("ISO-8859-1");
name=new String(c);
//获取提交的新的性别:
String s=request.getParameter("sex");
if(s==null)
{
s="";
}
//获取提交的新的年龄:
String a=request.getParameter("age");
if(a==null)
{
a="";
}
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException event){}
try {
con=DriverManager.getConnection("jdbc:odbc:GDMS","sa","");
sql=con.createStatement();
String condition=
"INSERT INTO students VALUES"+"("+"'"+id+"','"+name+"',"+s+","+a+")";
sql.executeUpdate(condition); //执行添加操作。
//显示添加新记录后表中的记录:
%>
<P>添加新记录后的表:
<%
rs=sql.executeQuery("SELECT * FROM Students ORDER BY ID ");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"学号");
out.print("<TH width=100>"+"姓名");
out.print("<TH width=50>"+"性别");
out.print("<TH width=50>"+"年龄");
out.print("</TR>");
while(rs.next())
{
out.print("<TR>");
String n=rs.getString(1);
out.print("<TD >"+n+"</TD>");
String xingming=rs.getString(2);
out.print("<TD >"+xingming+"</TD>");
String sex=rs.getString(3);
out.print("<TD >"+sex+"</TD>");
int age=rs.getInt(4);
out.print("<TD >"+age+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
}
catch(SQLException event)
{ }
%>
</BODY>
</HTML>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货