resin下如何连接mssql数据库
sw47 2004-07-10 10:22:12 郁闷了2天了,总是配置不好,麻烦哪位高手耐心把步骤说一下
我的bean
package jspcon;
import java.io.PrintStream;
import java.sql.*;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
public class jdbc
{
Connection conn;
public jdbc()
{
conn=null;
}
public Connection getConn()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection( "jdbc:odbc:jspconn", "sa", "");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;databaseName=sxoa", "sa", "");
}
catch(Exception f)
{
f.getStackTrace();
System.out.print( " conn failed" );
}
return conn;
}
public ResultSet execSql(String sql)
{
ResultSet rs = null;
try
{
Connection con = getConn();
Statement stmt = con.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException e)
{
e.printStackTrace();
}
return rs;
}
}
装了jdbc for mssql了
提示的错误
500 Servlet Exception
java.lang.NullPointerException
at jspcon.jdbc.execSql(jdbc.java:46)
at _sxoa._checklogin__jsp._jspService(/sxoa/checklogin.jsp:24)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.pageservice(Page.java:555)
at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:155)
at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:190)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:177)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:221)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:262)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:315)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:353)
at com.caucho.util.ThreadPool.run(ThreadPool.java:302)
at java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------------------
Resin-3.0.6 (built Tue, 20 Jan 2004 09:46:57 PST)