leafbm.java

来自「这个是我们做土地局的一个项目。感觉不错。欢迎下载」· Java 代码 · 共 24 行

package huayi.xt.leafBM;
import java.sql.*;

import javax.servlet.*;
public class leafBM
{
huayi.gg.dbConn.dbConn DBbean=new huayi.gg.dbConn.dbConn();
public String leafBM() throws Exception
{String option="";
 int id;
 ResultSet rs=DBbean.executeQuery("select id,BMBH from T_QYJGSB order by id");
 while (rs.next())
 {
 id=rs.getInt("id");
 String BMBH="";
 ResultSet rs1=DBbean.executeQuery("select * from T_QYJGSB where PID="+id);
 if (!rs1.next())
	{option+="<option value="+rs.getString("BMBH")+">"+rs.getString("BMBH")+"</option>\n";   }
	}
	return option;
}}