package shujuku;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class basedao {

    Connection conn=null;

    PreparedStatement ps;

    ResultSet rs=null;

    int rs1;

    public void getConnection()

      {

        try{

            //class.name 加载驱动

            Class.forName("oracle.jdbc.driver.OracleDriver");

            //获取数据库链接

            conn=DriverManager.getConnection("jdbc:oracle:thin:@20.12.2.50:1521:ora11g","lzt02","1");

        }catch(ClassNotFoundException e){e.printStackTrace();}

        catch(Exception e){e.printStackTrace();

        }

        //if(conn!=null){System.out.println("数据库链接成功");}

      }

    //关闭链接

    public void closeall()

     {

        try{

            if(rs!=null)

               {

                rs.close();

               }

            if(ps!=null)

               {

                ps.close();

               }

            if(conn!=null)

                 {

                conn.close();

                 }

        }catch(Exception e ){}

     }

    //执行操作

    public ResultSet execute(String sql,Object[] params,int flag)

       {

        getConnection();

        try{

            ps=conn.prepareStatement(sql);

            if(params !=null)

              {

                for(int i=0;i<params.length;i++)

                  {

                    ps.setObject(i+1, params[i]);

                  }

              }

            if(flag==0){

                rs=ps.executeQuery();

            return rs;}

            else if(flag==1){

                rs1=ps.executeUpdate(sql);

                if(rs1==1){System.out.println("插入成功");}

            }

        }catch(SQLException e){e.printStackTrace();}

        return null;

       }

//    public static void main(String[] args) {

//        // TODO Auto-generated method stub

//        basedao bd=new basedao();

//        bd.getConnection();

//    }

}