JAVABEAN连接数据哭的问题
这是JAVABEAN里面连接数据的代码
package com.aa;
import java.sql.*;
import com.microsoft.jdbc.sqlserver.*;
---------------
public class DBean {
public DBean(){}
private Connection cnn = null;
private Statement stmt = null;
private ResultSet rs = null;
public void condb(){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user="sa";
String password="sa";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
java.sql.DriverManager.registerDriver(new SQLServerDriver());
cnn=DriverManager.getConnection(url,user,password);
}
catch(Exception ex){
System.out.println(ex.getMessage());
}
}
public ResultSet executeQuery(String strSql){
try{
stmt=cnn.createStatement();
rs=stmt.executeQuery(strSql);
}
catch(Exception ex){
System.out.println(ex.getMessage());
}
return rs;
}
public void closeCon(){
try{
if(rs!=null){
rs.close();
}
if(stmt!=null){
stmt.close();
}
if(cnn!=null){
cnn.close();}
}
catch(Exception ex){
System.out.println(ex.getMessage());
}
}
}
-----------------------------------------------------------------
着是HTML里的代码
<%@ page language="java" import="java.lang.*,java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.microsoft.jdbc.sqlserver.*" %>
<body>
This is my JSP page. <br>
<jsp:useBean id="DBean" scope="page" class="com.aa" />
<table>
<tr>
<%
String strSql="select * from jobs where job_id='1' ";
ResultSet rs=DBean.executeQuery(strSql);
//rs.last();
while(rs.next())
{
//out.println("<tr><td>" + rs.getString(1) + "</td><td>" + rs.getString(2) + "</td></tr>");
out.println(rs.getString("job_desc"));
}
rs.close();
DBean.closeCon();
%>
问题点数：0、回复次数：1Top
1 楼lizheng197953（胖老虎）回复于 2004-08-01 14:37:58 得分 0
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.NullPointerException
org.apache.jsp.a_jsp._jspService(a_jsp.java:98)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.27 logs.
老出现错误？？为什么，大家指点一下我Top
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
