public String makeSelect(String selectName, Connection conn, String querySQL, String specialOption, boolean selectedOrDelete)
{
String selectStr = "";
if(specialOption == null)
{
specialOption = "";
}
if(S.isContains(querySQL, "select; from", ";"))
{
if(selectName != null && !selectName.equals(""))
{
selectStr = "<select name=\"" + selectName + "\">";
}
try
{
if(conn != null)
{
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(querySQL);
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
if(columnCount >= 2)
{
while(rs.next())
{
String optionValue = rs.getString(1);
String selected = (optionValue.equals(specialOption))? "selected":"";
if(selectedOrDelete)
{
selectStr += "<option value=\"" + optionValue + "\" " + selected + ">" + rs.getString(2) + "</option>";
}
else
{
if(selected.equals(""))
{
selectStr += "<option value=\"" + optionValue + "\" " + selected + ">" + rs.getString(2) + "</option>";
}
}
}
if(selectName != null && !selectName.equals(""))
{
selectStr += "</select>";
}
}
else
{
System.out.println("SQLWarning:传入的SQL参数不合法。");
}
}
}
catch(SQLException e)
{
e.printStackTrace();
} }
return selectStr;
}
{
String selectStr = "";
if(specialOption == null)
{
specialOption = "";
}
if(S.isContains(querySQL, "select; from", ";"))
{
if(selectName != null && !selectName.equals(""))
{
selectStr = "<select name=\"" + selectName + "\">";
}
try
{
if(conn != null)
{
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(querySQL);
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
if(columnCount >= 2)
{
while(rs.next())
{
String optionValue = rs.getString(1);
String selected = (optionValue.equals(specialOption))? "selected":"";
if(selectedOrDelete)
{
selectStr += "<option value=\"" + optionValue + "\" " + selected + ">" + rs.getString(2) + "</option>";
}
else
{
if(selected.equals(""))
{
selectStr += "<option value=\"" + optionValue + "\" " + selected + ">" + rs.getString(2) + "</option>";
}
}
}
if(selectName != null && !selectName.equals(""))
{
selectStr += "</select>";
}
}
else
{
System.out.println("SQLWarning:传入的SQL参数不合法。");
}
}
}
catch(SQLException e)
{
e.printStackTrace();
} }
return selectStr;
}
var year = "<%=today.substring(0, 4)%>";
for(var i = 2001; i < 2016; i++)
{
var val = "";
// document.write("<option value=\"" + i + "\">" + i + "</option>");
val += i;
if(i != year)
{
document.write("<option value=\"" + i + "\">" + i + "</option>");
}
else
{
document.write("<option value=\"" + i + "\" selected>" + i + "</option>");
}
}
</script> </select></font><font size="2" face="Arial">年</font><font face="Arial"><select size="1" name="month" style="background-color: #FFFFCC"><script>
var month = "<%=today.substring(4, 6)%>";
var ii = "";
for(var i = 1; i < 13; i++)
{
ii = (i < 10) ? "0" + i : i;
if(ii != month)
{
document.write("<option value=\"" + ii + "\">" + ii + "</option>");
}
else
{
document.write("<option value=\"" + ii + "\" selected>" + ii + "</option>");
}
}
</script>
</select></font><font size="2" face="Arial">月</font><font face="Arial"><select size="1" name="date" style="background-color: #FFFFCC"><script>
var date = "<%=today.substring(6, 8)%>";
var ii = "";
for(var i = 1; i < 32; i++)
{
ii = (i < 10) ? "0" + i : i;
if(ii != date)
{
document.write("<option value=\"" + ii + "\">" + ii + "</option>");
}
else
{
document.write("<option value=\"" + ii + "\" selected>" + ii + "</option>");
}
}
</script>
</select><font size="2">日</font>