不要配classpath,不知你的系统是什么?
我(Windows 2000 Server pack4)装tomcat从来没有配过classpath,把MS的JDBC Driver考到你的%tomcate_home%webapps/ROOT/WEB-INF/lib下。
把下面的类编译后放在%tomcate_home%webapps/ROOT/WEB-INF/classes下,
再写个jsp调用这个类......
import java.sql.*;public class DBUtil
{
private Connection conn = null;
private Statement stmt = null;
private ResultSet rs = null;
private String DBURL = "jdbc:microsoft:sqlserver://localhost:1433;User=aaa;Password=aaa";//SQl Server中要配置该用户的默认登录数据库 public DBUtil()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch(ClassNotFoundException e)
{
System.out.println("驱动程序加载错误");
}
catch(Exception e)
{
System.out.println("初始化错误!");
}
try
{
conn = DriverManager.getConnection(DBURL);
}
catch(SQLException e)
{
System.out.println("连接错误!");
}
} public ResultSet executeQuery(String sqlCmd)
{
try
{
stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sqlCmd);
return rs;
}
catch(SQLException e)
{
System.out.println("conn.createStatement错误!");
return null;
}
} public void close()
{
if(rs != null)
{
try
{
rs.close();
}
catch(Exception e)
{ }
}
if(stmt != null)
{
try
{
stmt.close();
}
catch(Exception e)
{ }
}
if(conn != null)
{
try
{
conn.close();
}
catch(Exception e)
{ }
}
}
}
我(Windows 2000 Server pack4)装tomcat从来没有配过classpath,把MS的JDBC Driver考到你的%tomcate_home%webapps/ROOT/WEB-INF/lib下。
把下面的类编译后放在%tomcate_home%webapps/ROOT/WEB-INF/classes下,
再写个jsp调用这个类......
import java.sql.*;public class DBUtil
{
private Connection conn = null;
private Statement stmt = null;
private ResultSet rs = null;
private String DBURL = "jdbc:microsoft:sqlserver://localhost:1433;User=aaa;Password=aaa";//SQl Server中要配置该用户的默认登录数据库 public DBUtil()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch(ClassNotFoundException e)
{
System.out.println("驱动程序加载错误");
}
catch(Exception e)
{
System.out.println("初始化错误!");
}
try
{
conn = DriverManager.getConnection(DBURL);
}
catch(SQLException e)
{
System.out.println("连接错误!");
}
} public ResultSet executeQuery(String sqlCmd)
{
try
{
stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sqlCmd);
return rs;
}
catch(SQLException e)
{
System.out.println("conn.createStatement错误!");
return null;
}
} public void close()
{
if(rs != null)
{
try
{
rs.close();
}
catch(Exception e)
{ }
}
if(stmt != null)
{
try
{
stmt.close();
}
catch(Exception e)
{ }
}
if(conn != null)
{
try
{
conn.close();
}
catch(Exception e)
{ }
}
}
}
package hangkong;import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;public class Jdbc { String driver = "org.gjt.mm.mysql.Driver";
String url = "jdbc:mysql://192.168.1.222:3306/hangkong";
Connection connect = null;
ResultSet rs = null; public Jdbc() {
try {
Class.forName(driver);
}
catch (Exception e)
{
System.out.println("不能加载驱动程序");
}
} public ResultSet executeQuery(String sql) {
rs = null;
try {
connect = DriverManager.getConnection(url, "root", "");
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql); }
catch (SQLException ex) {
System.out.println("数据库连接失败");
}
return rs;
}
}
你试试在程序里调用.
jsdk/jre/lib/ext /下
试一下,这样就差不多了