如下代码:
BEAN
package bean2;
import java.sql.*;public class testDB
{
private Connection con; public testDB()
{
try
{
String str = "jdbc:mysql://127.0.0.1:3306/test?user=root&password=123456789";
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(str);
}
catch(Exception e)
{
System.out.println("连接数据库失败!");
}
} public void outdb()
{
try
{
String str2 = "select * from t;";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(str2);
while(rs.next())
{
System.out.println(rs.getInt("id"));
}
rs.close();
}
catch(Exception e)
{
System.out.println("读取数据失败!");
}
}
}JSP
<%@ page language="java" contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="t" scope="page" class="bean1.testDB">
<jsp:setProperty name="t" property="*" />
</jsp:useBean>
<html>
<head>
</head>
<body>
<%
t.outdb();
%>
</body>
</html>然后什么都木有显示,帮看看哪出错了,谢谢!
BEAN
package bean2;
import java.sql.*;public class testDB
{
private Connection con; public testDB()
{
try
{
String str = "jdbc:mysql://127.0.0.1:3306/test?user=root&password=123456789";
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(str);
}
catch(Exception e)
{
System.out.println("连接数据库失败!");
}
} public void outdb()
{
try
{
String str2 = "select * from t;";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(str2);
while(rs.next())
{
System.out.println(rs.getInt("id"));
}
rs.close();
}
catch(Exception e)
{
System.out.println("读取数据失败!");
}
}
}JSP
<%@ page language="java" contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="t" scope="page" class="bean1.testDB">
<jsp:setProperty name="t" property="*" />
</jsp:useBean>
<html>
<head>
</head>
<body>
<%
t.outdb();
%>
</body>
</html>然后什么都木有显示,帮看看哪出错了,谢谢!
解决方案 »
- flex4中用DataGrid显示查询出来的数组怎么弄?
- dwr返回值问题!
- 高手帮我讲解一下这段JQuery代码 谢谢
- 高分求解一个在JSP页面图形处理的问题
- 请教JBuilderX中Project,User Home,JBuilder有什么不同?
- 悄悄的问一下,这种页子怎么做的!在线等!
- 一个关于 Connection timed out: connect 的问题,求大神指点
- 你们的JSP应用服务器都用什么?weblogic?
- 在tomcat4.1.24+apache2.0.45+mod_jk2-2.0.43.dll+windows 2000 server运行*.jsp的bbs和留言本就出现下载的页面???高手帮忙啊!!!!
- 学习JSP需要什么样的环境配置?
- Number Format的问题
- spring如何用类似PreparedStatement的功能
改成<jsp:useBean id="t" scope="page" class="bean2.testDB">
应为这个是package bean2;