hehe~~~<select>
while(rs.next()){
out.println("<option>"+rs.getString(i)+"</option>");
}
</select>
while(rs.next()){
out.println("<option>"+rs.getString(i)+"</option>");
}
</select>
解决方案 »
- dtree.js 如何增加右键点击事件? 弹出增删改操作,并获取所点击节点的ID
- java代码中调用controller类控制跳转
- jsp中forward一个很困惑的问题。。高手进。。。。
- struts2标签问题
- 关于tomcat5.5的server.xml中有没有"defaultcontext"元素的问题。
- 怎样实现return actionmapping.findForward("/system/admin/ListUserActions?pageNum=" + ct)的转发
- 关于js 加载顺序问题
- 请教一个jsp urlRewrite的问题!
- 新手向高手大哥求救,我连MySQL出现如下错误,是什么错误啊,百思不得其解.
- 在JSP可以调用MS的COM组件吗?
- jbuilder 8 personal for linux 哪里有下载?
- 请高手指点
DBconn.java
__________________________________
package bean;
import java.sql.*;
public class DBconn {
String DBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String ConnStr = "jdbc:microsoft:sqlserver://zyb:1433";
String user="zyb";
String password="zyb";
Connection conn = null;
ResultSet rs = null;
public DBconn() {
try
{
Class.forName(DBDriver);
//加载数据库驱动程序
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("DBconn(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(ConnStr,user,password);
//与DBMS建立链接
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
}
____________________________________
jsp页面调用
test.jsp<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="conn" scope="page" class="bean.DBconn"/>
<select name="select" size="1" id="tag" style="HEIGHT: 22px; WIDTH: 80px">
<%
String sql="selectd '员工姓名' from employees";
ResultSet RS=conn.executeQuery(sql);
try
{
while(RS.next())
{
out.print("<option>");
out.print(RS.getString("name").trim());
out.print("</option>");
}
}
catch(Exception e)
{
}
RS.close();
%>
</select>