UC知道javabean连接数据库问题
来源：百度知道 编辑：UC知道 时间：2024/05/23 19:41:47
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="dbconn" scope="page" class="myapp.DBConnection"/>
<html>
<head>
<title>数据查询</title>
</head>
<body bgcolor="#FFFF00">
<p align="center">用户信息表</p>
<hr>
<table border="0" align="center">
<tr bgcolor="#ccff22" align="center">
<td>用户名</td>
<td>密码</td>
<td>性别</td>
<td>年级</td>
<td>院系</td>
<td>专业</td>
<td>住址</td>
<td>邮箱</td>
</tr>
<%
dbconn.getConnection();
String sql="select * from userInfo";
ResultSet rs=dbconn.executeQuery(sql);
while(rs.next()){
%>
<jsp:useBean id="dbconn" scope="page" class="myapp.DBConnection"/>
<html>
<head>
<title>数据查询</title>
</head>
<body bgcolor="#FFFF00">
<p align="center">用户信息表</p>
<hr>
<table border="0" align="center">
<tr bgcolor="#ccff22" align="center">
<td>用户名</td>
<td>密码</td>
<td>性别</td>
<td>年级</td>
<td>院系</td>
<td>专业</td>
<td>住址</td>
<td>邮箱</td>
</tr>
<%
dbconn.getConnection();
String sql="select * from userInfo";
ResultSet rs=dbconn.executeQuery(sql);
while(rs.next()){
%>
我写个给你
你在外面调用我的，
package common;
import java.sql.*;
public class DBManager {
private String myDriver=null;
private String myConnStr=null;
private Connection myConn=null;
private Statement myStmt=null;
private ResultSet myResults=null;
public DBManager(){ //加载sql驱动
myDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
myConnStr="jdbc:microsoft:sqlserver://localhost:1433;"+"DatabaseName=sport_ntu;User=sa;PAssword=123456";
//myDriver="sun.jdbc.odbc.JdbcOdbcDriver";
//myConnStr="jdbc:odbc:sport_ntu"+""+"";
try{
Class.forName(myDriver);
}catch(ClassNotFoundException e){
System.out.println("加载sql驱动"+e.getMessage());
}
}
public bool