| |
<%@ page contenttype="text/html" import="operate_db.*,java.sql.*" %>
<jsp:usebean id="querybean" scope="request" class="operate_db.querybean" />
<%
string prm1,prm2,prm3;
resultset rst=null;
prm1 = ...;
prm2 = ...;
prm3 = ...;
querybean.setconnection("sun.jdbc.odbc.jdbcodbcdriver","jdbc:odbc:数据源名","sa","");
try{
string[] param = {prm1,prm2,prm3};
/*设置select语句*/
querybean.setquerystatement("select * from table where field1 = ? and field2=? and field3=?");
querybean.setparam(param);
rst=querybean.getresult();
}catch(exception e){system.out.println(e); }
while (rst.next()){
%><%=rst.getstring(1)%>
<%}%>
|
|
