jsp中使用JavaBeam连接数据库查询数据的源码实例，包括了SQLServer相关jar包的下载，数据库的连接java实例源码，数据库查询等。
以下是使用javabean查询数据库后显示信息的jsp页面源码：
<%@ page contentType=”text/html; charset=gb2312″ language=”java” import=”java.sql.*” errorPage=”" %>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=gb2312″>
<link href=”Css/Css.css” rel=”stylesheet” type=”text/css”>
<jsp:useBean id=”connection” scope=”request” class=”com.JDBConnection”/>
<title>把数据库中的记录显示到下拉列表中</title>
</head>
<body>
<table width=”100″ border=”1″ align=”center” cellpadding=”0″ cellspacing=”0″ background=”images/00.gif” bordercolordark=”#CCCCCC” bordercolorlight=”#FFFFFF”>
<tr>
<td><form name=”form” method=”post” >
<table width=”565″ height=”258″ border=”0″ align=”center” cellpadding=”0″ cellspacing=”0″>
<tr>
<td height=”38″ colspan=”2″ valign=”bottom” >
<table width=”556″ height=”29″ border=”0″ cellpadding=”0″ cellspacing=”0″>
<tr>
<td width=”65″> </td>
<td width=”491″> 添加个人详细信息</td>
</tr>
</table></td>
</tr>
<tr>
<td width=”120″ height=”15″> 姓名：</td>
<td width=”445″ height=”20″><input name=”user_name” type=”text” class=”text” size=”20″> </td>
</tr>
<tr>
<td height=”20″> 性别： </td>
<td height=”20″><select name=”user_sex”>
<option value=”我是男生”>我是男生</option>
<option value=”我是女生” selected>我是女生</option>
</select>
</td>
</tr>
<tr>
<td height=”20″> 生日：</td>
<td height=”20″><input name=”user_birthday” type=”text” class=”text” size=”30″>
<span class=”style5″>*</span> 如(1984-03-13或1984/03/13)</td>
</tr>
<tr>
<td height=”20″> 昵称：</td>
<td height=”20″><input name=”user_nick” type=”text” class=”text”>
同学都是怎么称呼你的？</td>
</tr>
<tr>
<td height=”20″> 所属班级：</td>
<td height=”20″>
<select name=”user_class” >
<%
String sql=”select * from tb_wyClass”;
ResultSet rs=connection.executeQuery(sql);
try{
while(rs.next()){
%>
<option value=”<%=rs.getString(“name”)%>”><%=rs.getString(“name”)%></option>
<%}}catch (Exception e){}%> </select>
</td>
</tr>
<tr>
<td height=”20″> 通信地址：</td>
<td height=”20″><input name=”user_address” type=”text” class=”text” size=”35″></td>
</tr>
<tr>
<td height=”20″> 邮政编码：</td>
<td height=”20″><input name=”user_size” type=”text” class=”text”></td>
</tr>
<tr>
<td height=”20″> 电话号码：</td>
<td height=”20″><input name=”user_telephone” type=”text” class=”text” size=”30″></td>
</tr>
<tr>
<td height=”20″> OICQ：</td>
<td height=”20″><input name=”user_OICQ” type=”text” class=”text”></td>
</tr>
<tr>
<td height=”20″> 个人主页：</td>
<td height=”20″><input name=”user_homepage” type=”text” class=”text ” size=”30″></td>
</tr>
<tr>
<td height=”20″ colspan=”2″>
<input name=”button” type=”submit” class=”button” value=”提交” >
<input name=”button” type=”reset” class=”button” value=”重置”></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>
查询数据的javabean源码实例，JDBConnection.java：
package com;
import java.sql.*;
public class JDBConnection {
private final String dbDriver =
“com.microsoft.jdbc.sqlserver.SQLServerDriver”; //连接sql数据库的方法
private final String url =
“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_database02″;
private final String userName = “sa”;
private final String password = “”;
private Connection con = null;
public JDBConnection() {
try {
Class.forName(dbDriver).newInstance(); //加载数据库驱动
} catch (Exception ex) {
System.out.println(“数据库加载失败”);
}
}
//创建数据库连接
public boolean creatConnection() {
try {
con = DriverManager.getConnection(url, userName, password);
con.setAutoCommit(true);
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println(“creatConnectionError!”);
}
return true;
}
//对数据库的查询操作
public ResultSet executeQuery(String sql) {
ResultSet rs;
try {
if (con == null) {
creatConnection();
}
Statement stmt = con.createStatement();
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
System.out.println(e.getMessage());
return null;
}
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println(“executeQueryError!”);
return null;
}
return rs;
}
//关闭数据库的操作
public void closeConnection() {
if (con != null) {
try {
con.close();
} catch (SQLException e) {
e.printStackTrace(); //To change body of catch statement use File | Settings | File Templates.
System.out.println(“Failed to close connection!”);
} finally {
con = null;
}
}
}
}
以上javabean源码是连接到SQLServer数据库的，因此还应该为项目增加连接SQLServer数据库相关的jar包到项目中，以下是java连接SQLServer数据库相关的jar包下载：
http://pan.baidu.com/s/1i3fuYvr