package dw;
import java.sql.*;public class DropDownDataWindow {
public String getSelect(String tablename,String columnname) {
String s="";
String columnvalue="";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=databasename";
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select "+columnname+" as a from "+tablename;
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
columnvalue=rs.getString(1);
s+="<option value=\""+columnvalue\">"+columnvalue+"</option>";
}
return s;
}
}
---------------------------
在jsp调用:
-------------
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="selectdata" scope="session" class="dw.DropDownDataWindow"/>
<select name="month" style="width:125" >
<%=selectdata.getSelect(tablename,columnname);%>
</select>
import java.sql.*;public class DropDownDataWindow {
public String getSelect(String tablename,String columnname) {
String s="";
String columnvalue="";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=databasename";
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select "+columnname+" as a from "+tablename;
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
columnvalue=rs.getString(1);
s+="<option value=\""+columnvalue\">"+columnvalue+"</option>";
}
return s;
}
}
---------------------------
在jsp调用:
-------------
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="selectdata" scope="session" class="dw.DropDownDataWindow"/>
<select name="month" style="width:125" >
<%=selectdata.getSelect(tablename,columnname);%>
</select>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货