您所在位置：主题：关于封装数据库操作，哪出错了？
明月天山
[专家分：0] 发布于 2006-04-03 11:45:00
bean是：
package zzjpackage;
import java.sql.*;
public class OpenDB
{
public Connection con;
public Statement sta;
public ResultSet rs;
public String driver;
public String url;
public String user;
public String pwd;
public String open()
{
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyWebDB";
user= "z";
pwd = "";
try{
Class.forName(driver);
con = DriverManager.getConnection(url,user,pwd);
sta = con.createStatement();
rs = sta.executeQuery("select * from tb1");
return "Bean is ok";
}
catch(Exception e){e.printStackTrace();return "Bean is Wrong";}
}
}
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" />
</head>
<body>
<%--创建javabean并设置属性--%>
<jsp:useBean id="z1" class="zzjpackage.OpenDB" scope="request">
</jsp:useBean>
<%out.print(z1.open()); %>
</body>
</html>
总是打不开这个jsp页面，是哪的问题？
package zzjpackage;
import java.sql.*;
public class OpenDB
{
public Connection con;
public Statement sta;
public ResultSet rs;
public String driver;
public String url;
public String user;
public String pwd;
public String open()
{
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyWebDB";
user= "z";
pwd = "";
try{
Class.forName(driver);
con = DriverManager.getConnection(url,user,pwd);
sta = con.createStatement();
rs = sta.executeQuery("select * from tb1");
return "Bean is ok";
}
catch(Exception e){e.printStackTrace();return "Bean is Wrong";}
}
}
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" />
</head>
<body>
<%--创建javabean并设置属性--%>
<jsp:useBean id="z1" class="zzjpackage.OpenDB" scope="request">
</jsp:useBean>
<%out.print(z1.open()); %>
</body>
</html>
总是打不开这个jsp页面，是哪的问题？