我的数据库连接（一）_public void close() { if (conn!=null) { try { conn-优快云博客

该博客展示了Java代码实现数据库连接及操作的过程。通过读取配置文件获取数据库驱动、URL、用户名和密码等信息，使用JDBC连接SQL Server数据库，实现了查询、更新等操作，还包含关闭连接等方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package db;
import java.io.*;
import java.sql.*;
import java.util.*;

public class DbConnection {
  Connection conn;
  Statement stmt;
  ResultSet rset;
  private String password;
  private String url;
  private String user ;
  private String jdbc;
public DbConnection() {

   }

public  boolean openConnection() throws SQLException{
System.out.println("ksjfsa");
   InputStream is = getClass().getResourceAsStream("db.txt");//取自配置文件
  Properties prop = new Properties();
  try {
    prop.load(is);
    System.out.println("prop");
  }
  catch (IOException ex) {

  }
  if (is != null) {
    try {
      is.close();
         }
    catch (IOException ex1) {
  }}
    jdbc = prop.getProperty("driver");
    url = prop.getProperty("url");
    user= prop.getProperty("user");
    password = prop.getProperty("password");
      try {
        Class.forName(jdbc);
            }
      catch (ClassNotFoundException ex2) {
        ex2.printStackTrace();
      }
      conn = DriverManager.getConnection(url, user, password);
           stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
       return true;
}

  public ResultSet exceuteQuery(String query) throws SQLException{
       return stmt.executeQuery(query);
}

  public void executeUpdate(String query)  throws SQLException{
         stmt.executeUpdate(query);
  }

  public void close(){
  try {
    if (conn != null) {
      conn.close();
    }
    if (stmt != null) {
      stmt.close();
    }
    if (rset != null) {
      rset.close();
    }
  }
  catch (SQLException ex) {
  }
  }

  public void finalize(){
  this.close();}
  public void closeRst(){
      stmt =null;
      rset=null;

      }
  }

配置文件
//fileName db.txt
driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://192.168.0.122:1433;DatabaseName=c
user=sa
passwor=