应用于jsp开发中的javabean(jsp与sql2000的odbc连接)
package com;
import java.sql.*;
public class ODBC
{
private String DBDRIVER="sun.jdbc.odbc.JdbcOdbcDriver";//驱动
private String DBURL="jdbc:odbc:cdc";//url地址,cdc为库名
private String DBUSER="sa";//数据库用户名
private String DBPWD="";//数据库密码
private Connection conn=null;
private Statement stmt=null;
private ResultSet rs=null;
public ODBC()
{
try
{
Class.forName(DBDRIVER);//加载驱动
}
catch (ClassNotFoundException e)
{
System.out.println("加载驱动出错");
}
}
public ResultSet execute(String sql)//查询操作
{
try
{
conn=DriverManager.getConnection(DBURL,DBUSER,DBPWD);
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
return rs;
}
catch (SQLException e)
{
System.out.println("sql出错");
return null;
}
}
public int Update(String sql)//更新操作
{
try
{
conn=DriverManager.getConnection(DBURL,DBUSER,DBPWD);
stmt=conn.createStatement();
return stmt.executeUpdate(sql);
}
catch (SQLException e)
{
System.out.println("sql出错");
return 0;
}
}
public void close()//数据库关闭
{
try
{
if(conn!=null)
{
conn.close();
}
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
当通过jdbc来连接sql2000:修改上述中的DBDRIVER,DBURL
DBDRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";
DBURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=cdc";