我自己写了个JSP页面，只是查询formA表中数据，没有用Beans,执行的时候也是出错。谁能帮我改改啊？
<%@ page contentType="text/html;charset=GB2312" language="java" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY bgcolor=orange ><Font size=1>
<form action="" Method=post>
请输入查询内容：
<Input type=text name=number>
<Input type=submit name=g value=查询>
</form>
<%! Connection con=null;//声明一个共享的连接对象。
%>
<% //获取查询。
String aa=request.getParameter("number");
if(aa==null)
{aa="?";
}
byte b[]=aa.getBytes("ISO-8859-1");
aa=new String(b);
Statement sql=null;
ResultSet rs=null;
if(con==null)
{ try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{out.print(e);
}
try {con=DriverManager.getConnection("jdbc:odbc:数据源名","","");
String condition="SELECT * from formA WHERE AA = "+"'"+ aa +"'";
rs =sql.executeQuery(condition);
}
catch(SQLException e)
{out.print(e);
}
}
else
{ synchronized(con)
{ try {sql=con.createStatement();
String condition="SELECT * from formA WHERE AA = "+"'"+ aa +"'";
rs =sql.executeQuery(condition);
}
catch(SQLException e)
{out.print(e);
}
}
}
try { out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"AA");
out.print("<TH width=100>"+"BB");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
String number=rs.getString(1);
out.print("<TD >"+number+"</TD>");
String bb=rs.getString("BB");
out.print("<TD >"+bb+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
}
catch(SQLException e1) {}
%>
</FONT>
</BODY>
</HTML>
您所在位置：
yoyo23mir
[专家分：0] 发布于 2005-05-10 16:09:00 