<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
动物数据信息查询
输入动物编号:
<%
request.setCharacterEncoding("UTF-8");
try{
String drugs=request.getParameter("drugs");
if(drugs!=null)
{
if(!drugs.equals(""))
{
Class.forName("oracle.jdbc.driver.OracleDriver");
String username="SYSTEM";
String password="Zxy11111";
String url="jdbc:oracle:thin:@localhost:1521:ZXY";
Connection conn=DriverManager.getConnection(url, username, password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select*from adata where animal='"+drugs+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs!=null)
{
while(rs.next())
{
%>
动物编号:<%=rs.getString("animal")%>
喂食量:<%=rs.getString("feed") %>
瘤胃PH:<%=rs.getString("lwph") %>
饮水量:<%=rs.getString("drink") %>
体重:<%=rs.getString("weight") %>
性别:<%=rs.getString("sex") %>
饲养天数:<%=rs.getString("aday") %>
数据采集时间:<%=rs.getString("atime") %>
<%
}
}
else
{
%>
没有该动物信息
<%
}
rs.close();
stmt.close();
conn.close();
}
}
}
catch(ClassNotFoundException e)
{
out.println("驱动程序类异常!
");
out.println(e.getMessage());
}
catch(SQLException e)
{
out.println("数据库连接或SQL查询异常!
");
out.println(e.getMessage());
}
catch(Exception e)
{
out.println("其他异常!
");
out.println(e.getMessage());
}%>
</div>
运行后出现问题:
数据库连接或SQL查询异常!
ORA-01009: 必需的参数缺失
求大神解决