我在网上下载了一个SQLServer2000的JDBC驱动程序,但是我不知道怎样在代码中实现数据库连接.我写了一个DatabaseBean,如下:package com.hy.bean;import java.sql.*;public class DatabaseBean {
public DatabaseBean() {
try{
Class.forName(driver).newInstance();
conn=DriverManager.getConnection(url);
}
catch (Exception e) {
System.out.println("DatabaseBean()->"+e);
}
}
public ResultSet doSelect(String sql) {
try {
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
if (rs.next())
return rs;
else
return null;
}
catch (SQLException e) {
System.out.println("doSelect()->"+e.getMessage());
return null;
}
finally {
try {
if (rs!=null)
rs.close();
if (stmt!=null)
stmt.close();
if (conn!=null)
conn.close();
}
catch (SQLException e) {
System.out.println("doSelect()->"+e.getMessage());
return null;
}
}
} public int doUpdate(String sql) {
int row=0;
try {
stmt=conn.createStatement();
row=stmt.executeUpdate(sql);
if (row!=0) return row;
else return 0;
}
catch (SQLException e) {
System.out.println("doUpdate()->"+e);
return 0;
}
finally {
try {
if (rs!=null)
rs.close();
if (stmt!=null)
stmt.close();
if (conn!=null)
conn.close();
}
catch (SQLException e) {
System.out.println("doSelect()->"+e.getMessage());
return 0;
}
}
}
public int doInsert(String sql) {
return doUpdate(sql);
}
public int doDelete(String sql) {
return doUpdate(sql);
}
private static final String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=公寓;user=sa;password="; private Connection conn=null;
private Statement stmt=null;
private ResultSet rs=null;
public static void main(String[] args) {
DatabaseBean db=new DatabaseBean();
String sql="select * from user";
ResultSet rs=db.doSelect(sql);
try{
while (rs.next()) {
//System.out.println("------------------------------");
System.out.println("id="+rs.getString("id"));
System.out.println("username="+rs.getString("username"));
System.out.println("password="+rs.getString("password"));
System.out.println("------------------------------");
}
}
catch (SQLException e) {
System.out.println("main()->"+e);
}
}
}编译无误,但是执行时总是出现:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver请问高手们,我现在该怎么办?
public DatabaseBean() {
try{
Class.forName(driver).newInstance();
conn=DriverManager.getConnection(url);
}
catch (Exception e) {
System.out.println("DatabaseBean()->"+e);
}
}
public ResultSet doSelect(String sql) {
try {
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
if (rs.next())
return rs;
else
return null;
}
catch (SQLException e) {
System.out.println("doSelect()->"+e.getMessage());
return null;
}
finally {
try {
if (rs!=null)
rs.close();
if (stmt!=null)
stmt.close();
if (conn!=null)
conn.close();
}
catch (SQLException e) {
System.out.println("doSelect()->"+e.getMessage());
return null;
}
}
} public int doUpdate(String sql) {
int row=0;
try {
stmt=conn.createStatement();
row=stmt.executeUpdate(sql);
if (row!=0) return row;
else return 0;
}
catch (SQLException e) {
System.out.println("doUpdate()->"+e);
return 0;
}
finally {
try {
if (rs!=null)
rs.close();
if (stmt!=null)
stmt.close();
if (conn!=null)
conn.close();
}
catch (SQLException e) {
System.out.println("doSelect()->"+e.getMessage());
return 0;
}
}
}
public int doInsert(String sql) {
return doUpdate(sql);
}
public int doDelete(String sql) {
return doUpdate(sql);
}
private static final String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=公寓;user=sa;password="; private Connection conn=null;
private Statement stmt=null;
private ResultSet rs=null;
public static void main(String[] args) {
DatabaseBean db=new DatabaseBean();
String sql="select * from user";
ResultSet rs=db.doSelect(sql);
try{
while (rs.next()) {
//System.out.println("------------------------------");
System.out.println("id="+rs.getString("id"));
System.out.println("username="+rs.getString("username"));
System.out.println("password="+rs.getString("password"));
System.out.println("------------------------------");
}
}
catch (SQLException e) {
System.out.println("main()->"+e);
}
}
}编译无误,但是执行时总是出现:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver请问高手们,我现在该怎么办?
解决方案 »
- 请各位大侠帮忙,包含取值为0的字节数组如何转成字符串
- 请教个JinternalFrame的问题
- 帮我注释下这个小程序,关于Vector.
- 一个比较弱的问题。大家来帮忙哦。
- 一个java小程序的不理解?????请教高手
- 谁给个帮助文档,要能查函数的,我下了个1.6的,输入函数名字查不到,郁闷。
- 一个数组的问题
- 请教怎样在canvas上面画图啊?我怎么画出来的一闪而过
- 一个有关顺序输入流SequenceInputStream的问题(有分!~)
- 请大家谈谈怎样把UTF-8的XML文件读成流,再改变后输出?
- 怎样用SQLServer2000JDBC驱动程序连接数据库?
- 关于throw、throws的用法疑惑
如果是在IDE中编译,配置所需lib即可。
http://www.blogjava.net/rickhunter/category/3664.html