java操作mysql

这里列出最基本的增删改查操作:

import Conn.Conn; //连接类我已经写好了,直接导入 见：http://blog.csdn.net/wangzhuo0978/article/details/53019688  
import java.sql.Connection;  
import java.sql.PreparedStatement;  
import java.sql.ResultSet;  
  
public class Operation {  
    private Connection conn;  
    private PreparedStatement pstm = null;  //预编译结果;  
    // 增删改查;  
    public void ConnectSQL(){  
        try{  
            conn = Conn.getConnection();  
        }catch(Exception e){  
            System.out.println("连接失败");  
        }  
    }  
    public boolean insertSQL(String sql, String... ob){   // sql为传入的基本sql语句, pstm.setObject(), 动态修改参数;    
        try{    
            pstm = conn.prepareStatement(sql);    
            for(int i = 0; i < ob.length; ++i){  
				pstm.setObject(i+1, ob[i]);  
            }  
            int num = pstm.executeUpdate();    
            System.out.println("插入数据成功, 成功插入" + num + "数据");    
            return true;    
        }catch (Exception e){    
            System.out.println("插入数据时出错");    
        }    
        return false;    
    public boolean deleteSQL(String sql){  
        try{  
            pstm = conn.prepareStatement(sql);  
            int num = pstm.executeUpdate();  
            System.out.println("删除数据成功, 成功删除" + num + "数据");  
            return true;  
        }catch(Exception e){  
            System.out.println("删除数据时出错");  
        }  
        return false;  
    }  
    public boolean updateSQL(String sql){  
        try{  
            pstm = conn.prepareStatement(sql);  
            int num = pstm.executeUpdate();  
            System.out.println("修改数据成功, 成功修改" + num + "数据");  
            return true;  
        }catch(Exception e){  
            System.out.println("修改数据时出错");  
        }  
        return false;  
    }  
    public ResultSet selectSQL(String sql){  
        ResultSet rs = null;  
        try{  
            pstm = conn.prepareStatement(sql);  
            rs = pstm.executeQuery();  
        }catch(Exception e){  
            System.out.println("查询数据时出错");  
        }  
        return rs;  
    }  
}