dboperation.java

来自「简单的日志分析工具」· Java 代码 · 共 70 行

package db;


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



public class Dboperation {
	public ResultSet rs=null;    
	public ResultSet search(String sql){
    	   Db d=new Db(); 
    	   
    	   Statement stmt;
    	   
    	   try {
    		    stmt = d.con.createStatement();
    		    rs =stmt.executeQuery(sql);
    	       	
    	       	
    	   } catch (SQLException e) {
    		   System.err.println("DBManager().executeSearch : " + e.getMessage());
    	   }
    	  
           return rs;
       }
	   //insert操作
       public void insert(String sql){
    	   Db d=new Db();
    	   Statement stmt;
    	   try {
    		   stmt = d.con.createStatement();
    	       stmt.executeUpdate(sql);
    	        
    	   } catch (SQLException e) {
    		   System.err.println("DBManager().executeInsert : " + e.getMessage());
    	   }
       }
       //update操作
       public void update(String sql){
    	   Db d=new Db();
    	   Statement stmt;
    	   try {
    		   stmt = d.con.createStatement();
    	       stmt.executeUpdate(sql);
    	        
    	   } catch (SQLException e) {
    		   System.err.println("DBManager().executeUpdate : " + e.getMessage());
    	   }
       }
       //delete操作
       public void delete(String sql){
    	   Db d=new Db();
    	   Statement stmt;
    	   
    	   try {
    		   stmt = d.con.createStatement();
    	       stmt.executeUpdate(sql);
    	        
    	   } catch (SQLException e) {
    		   System.err.println("DBManager().executeDelete : " + e.getMessage());
    	   }
       }
    
      
}