📄 leafbm.java
字号:
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;
}}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -