jdbconnection.java~2~

来自「jsp技术 基于struts框架的新闻发布系统」· JAVA~2~ 代码 · 共 94 行

package com.victor.tool;

import java.sql.SQLException;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Connection;

public class JDBConnection {
  //JDBC类
 String sd = "sun.jdbc.odbc.JdbcOdbcDriver";
 String sc = "jdbc:odbc:db_news";
 ResultSet rs = null;
 Connection conect = null;
 public JDBConnection() {
   try {
     Class.forName(sd);
   }
   catch (java.lang.ClassNotFoundException e) {
     System.err.println(e.getMessage());
   }
 }

 public ResultSet executeQuery(String sql) {
   try {
     conect = DriverManager.getConnection(sc);
     Statement stmt = conect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                             ResultSet.CONCUR_READ_ONLY);
     rs = stmt.executeQuery(sql);
   }
   catch (SQLException ex) {
     System.err.println(ex.getMessage());
   }
   return rs;
 }

 public int executeUpdate(String sql) {
   int result = 0;
   try {
     conect = DriverManager.getConnection(sc);
     Statement stmt = conect.createStatement();
     result = stmt.executeUpdate(sql);
   }
   catch (SQLException er) {
     System.err.println(er.getMessage());
   }
   return result;
 }

 public void close() {
   try {
     if (conect != null) {
       conect.close();
     }
   }
   catch (Exception e) {
     System.out.println(e);
   }
 }

 //事物的回滚
  public void rollback() {
    try {
      conect.rollback();
    }
    catch (SQLException ex) {
    }
  }

//将sql语句中的？号转为相应的参数，其中参数为字符串型的
  public String editSqlCode(String sql, String str) {

    //截取从0到第一个问好的字符串加参数str，然后在加上第一个问号以后的字符串
    sql = sql.substring(0, sql.indexOf("?")) + str +
        sql.substring(sql.indexOf("?") + 1);
    return sql;
  }

  public String editSqlCode(String sql, Integer str) {
    sql = sql.substring(0, sql.indexOf("?")) + str +
        sql.substring(sql.indexOf("?") + 1);
    return sql;
  }

  public String editSqlCode(String sql, Float str) {
    sql = sql.substring(0, sql.indexOf("?")) + str +
        sql.substring(sql.indexOf("?") + 1);
    return sql;
  }




}