高考问答手机版香港速成输入法:jsp问题？
来源：百度文库 编辑：高考问答 时间：2024/04/29 15:01:42
提交后页面空白，无法调出数据库中的数据。请看下面的程序是否有错，请指点，数据库配置正确，可运行其它程序。谢谢了！
页面2：
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<% String mu=request.getParameter("mudi");
if(mu==null)
{mu="";
}
byte b[]=mu.getBytes("ISO-8859-1");
mu=new String(b);
String na=request.getParameter("name");
if(na==null)
{na="";
}
byte c[]=na.getBytes("ISO-8859-1");
na=new String(c);
String m=request.getParameter("mingcheng");
if(m==null)
{m=""; }
String ma=request.getParameter("math");
if(ma==null)
{ma=""; }
String t=request.getParameter("tel");
if(t==null)
{t=""; }
String t3=request.getParameter("textarea3");
if(t3==null)
{t3=""; }
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:sun","","");
sql=con.createStatement();
String condition=
"INSERT INTO dengji VALUES"+"("+","+mu+","+na+","+m+","+ma+","+t+","+t3+")";
sql.executeUpdate(condition); %>
<P>添加新记录后的表：
<%
rs=sql.executeQuery("SELECT * FROM dengji ORDER BY mudi ");
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("<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 mudi=rs.getString(2);
out.print("<TD >"+mudi+"</TD>");
int name=rs.getInt("姓名");
out.print("<TD >"+name+"</TD>");
int mingcheng=rs.getInt("名称");
out.print("<TD >"+mingcheng+"</TD>");
int math=rs.getInt("价格");
out.print("<TD >"+math+"</TD>");
int textarea3=rs.getInt("简介");
out.print("<TD >"+textarea3+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
}
catch(SQLException event)
{ }
%>
页面2：
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<% String mu=request.getParameter("mudi");
if(mu==null)
{mu="";
}
byte b[]=mu.getBytes("ISO-8859-1");
mu=new String(b);
String na=request.getParameter("name");
if(na==null)
{na="";
}
byte c[]=na.getBytes("ISO-8859-1");
na=new String(c);
String m=request.getParameter("mingcheng");
if(m==null)
{m=""; }
String ma=request.getParameter("math");
if(ma==null)
{ma=""; }
String t=request.getParameter("tel");
if(t==null)
{t=""; }
String t3=request.getParameter("textarea3");
if(t3==null)
{t3=""; }
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:sun","","");
sql=con.createStatement();
String condition=
"INSERT INTO dengji VALUES"+"("+","+mu+","+na+","+m+","+ma+","+t+","+t3+")";
sql.executeUpdate(condition); %>
<P>添加新记录后的表：
<%
rs=sql.executeQuery("SELECT * FROM dengji ORDER BY mudi ");
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("<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 mudi=rs.getString(2);
out.print("<TD >"+mudi+"</TD>");
int name=rs.getInt("姓名");
out.print("<TD >"+name+"</TD>");
int mingcheng=rs.getInt("名称");
out.print("<TD >"+mingcheng+"</TD>");
int math=rs.getInt("价格");
out.print("<TD >"+math+"</TD>");
int textarea3=rs.getInt("简介");
out.print("<TD >"+textarea3+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
}
catch(SQLException event)
{ }
%>
你在catch语句里添加System.out.println(e);打印错误，然后在web服务器的控制台里看看哪有错误！
还有，你可以在页面里添加一句out.print("******");添加到不同的行，看看加到哪之前能显示，就说明后面的语句是错误的