<SELECT size='1' name=CUSERTABLE48_FIELD804 style="WIDTH: 154px" value='CUSERTABLE48.FIELD804' "" onChange="seconddic2()">
<%
String dictext3="";
selectRS = MyConn.executeQuery("select * from dictionary where forder=804");
%>
<%
while (selectRS.next()){
String ctext3=TurnCharSet(selectRS.getString("ctext"));
if (ctext3 != null) ctext3=MyTrim(ctext3);
else ctext3="";
%>
<option value="<%=ctext3%>" ><%=ctext3%></option>
<%
}
%>
</select><script language="JavaScript">
function butt()
{
alert("梨花院落融融月,柳絮池塘淡淡风 呵呵,大家好,我是朱建明!");
}
</script>
<div align="center"><input type="button" name="button" value="button" onclick="butt()">
</div>
<%
String dictext3="";
selectRS = MyConn.executeQuery("select * from dictionary where forder=804");
%>
<%
while (selectRS.next()){
String ctext3=TurnCharSet(selectRS.getString("ctext"));
if (ctext3 != null) ctext3=MyTrim(ctext3);
else ctext3="";
%>
<option value="<%=ctext3%>" ><%=ctext3%></option>
<%
}
%>
</select><script language="JavaScript">
function butt()
{
alert("梨花院落融融月,柳絮池塘淡淡风 呵呵,大家好,我是朱建明!");
}
</script>
<div align="center"><input type="button" name="button" value="button" onclick="butt()">
</div>
.......
<jsp:useBean id="DBconn" scope="session" class="dataBean.DBconn"/>
//自己写的一个读取数据库的javabean !
........
<select name="select" size="1">
<%
String sql4="select storename from storehouse" ;
ResultSet rs4=DBconn.executeQuery(sql4);
try
{
while(rs4.next())
{
%>
<option><%= rs4.getString("storename") %>
<%
}
rs4.close();
}
catch(SQLException e)
{
out.println("<br>"+"SQLException 异常 !");
}
catch(Exception e)
{
out.println("<br>"+"Exception 异常 !");
}
%>
</select>
.............JavaBean代码: package dataBean;import java.sql.*;
public class DBconn
{
String dbDriver="org.gjt.mm.mysql.Driver";
String conStr="jdbc:mysql://localhost:3306/3dsoft";
String myUser="root";
String myPassword="";
Connection con = null;
ResultSet rs = null;
public DBconn()
{
try
{
Class.forName(dbDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("DBconn (): " + e.getMessage());
}
} public String getDbDriver()
{
return dbDriver;
}
public void setDbDriver(String dbDriver)
{
this.dbDriver=dbDriver;
}
public String getConStr()
{
return conStr;
}
public void setConStr(String conStr )
{
this.conStr = conStr ;
}
public String getMyUser()
{
return myUser ;
}
public void setMyUser(String myUser )
{
this. myUser= myUser ;
}
public String getMyPassword()
{
return myPassword ;
}
public void setMyPassword(String myPassword )
{
this.myPassword = myPassword ;
}
public ResultSet executeQuery(String sql) throws SQLException, Exception
{
rs = null;
try
{
con = DriverManager.getConnection(conStr,myUser,myPassword);
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("executeQuery:"+ex.getMessage());
return null;
}
catch(Exception e)
{
System.err.println("executeQuery:"+e.getMessage());
return null;
}
return rs;
} public int executeUpdate(String sql)
{
int n=0;
try
{
con = DriverManager.getConnection(conStr,myUser,myPassword);
Statement stmt = con.createStatement();
n=stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("executeUpdate:"+ex.getMessage());
return 0;
}
catch(Exception e)
{
System.err.println("executeQuery:"+e.getMessage());
return 0;
}
return n;
}
}试试看!
public class SelectData
{
public String getSelectData(String strSQL,String dataField )
{
String optionData="";
try
{
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/3dsoft","root","");
Statement stmt = con.createStatement();
ResultSet rs;
rs = stmt.executeQuery(strSQL);
while(rs.next())
{
optionData=optionData+"<option>"+rs.getString(dataField)+"</option><br>";
}
}
catch(SQLException ex)
{
System.err.println("executeQuery:"+ex.getMessage());
return "Some Error !";
}
catch(Exception e)
{
System.err.println("executeQuery:"+e.getMessage());
return "Some Error !";
}
return optionData;
}
}
Jsp文件:<jsp:useBean id="selectData" scope="session" class="beans.SelectData" />
.............<select name="storename" size="1" id="storename">
<%
String strSQL2="select storename from storeinfo" ;
String dataField2="storename";
out.println(selectData.getSelectData(strSQL2,dataField2 )) ;
%>
</select>
............
<%
sSQL="select * from F_Tbl";
rs=conn.ExeQuery(sSQL);
%>
<%
while(rs.next())
{
String sDeptName=rs.getString("DeptName");
%>
<option value="<%=sDeptName%>"><%=sDeptName%></option>
<%
}
%>
</select>
如
<web:select sql="select value,text from table_test"/>
最简单拉!