数据库连接类这个方法正规的-优快云博客

本文提供了一个使用 Java 进行 SQL Server 数据库连接及基本操作的示例代码，包括连接数据库、执行更新语句、执行查询语句及关闭连接等关键步骤。

import java.sql.*;

/** *//**
* Title: sqsb
* Description: sqsb
* Copyright: Copyright (c) 2005
* Company: Nanjing jinshui
* @author zhangjian
* @version 1.0
*/

public class CookieDB ...{
String databaseName = "sqsb";
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=" + databaseName;
String user = "sa";
String pwd = "";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
boolean isConnected = false;
public CookieDB() ...{
    try ...{
      Class.forName(driverName);
      conn = DriverManager.getConnection(url, user, pwd);
      isConnected = true;
    }
    catch (ClassNotFoundException cnfe) ...{
      cnfe.printStackTrace();
      System.out.println(" 没有找到对应的驱动程序...");
      isConnected = false;
    }
    catch (SQLException sqle) ...{
      sqle.printStackTrace();
      System.out.println(" 数据库连接失败...");
      isConnected = false;
    }
}

public Connection getConn() ...{
    if (isConnected) ...{
      return conn;
    }
    else ...{
      return null;
    }
}

public boolean isConnected() ...{
return isConnected;
}

public void executeUpdate(String sql) ...{
    try ...{
      stmt = conn.createStatement();
      stmt.executeUpdate(sql);
    }
    catch (SQLException sqle) ...{
      sqle.printStackTrace();
      System.out.println("数据更新失败...");
    }
}

public ResultSet executeQuery(String sql) ...{
    try ...{
      stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                  ResultSet.CONCUR_READ_ONLY);
      rs = stmt.executeQuery(sql);
      return rs;
    }
    catch (SQLException sqle) ...{
      sqle.printStackTrace();
      System.out.println("数据库查询失败...");
      return null;
    }
}

//关闭数据库连接
public void closeSql() ...{
    try ...{
      stmt.close();
      conn.close();
    }
    catch (SQLException sqle) ...{
      sqle.printStackTrace();
    }
}
}