通过JAVA工具类连接sqlserver 2008R2增删改差

MyEclipse或者eclipse

win7、win8、还有win10

第一步通过调用JAVA与sqlserver 2008R2的工具类实现查询操作：让其返回Arraylist的对象然后进行输出操作对应的JAVA代码是：   //查询ID信息  public ArrayList queryProbyID(int pID) {   Product pro;   ResultSet rs = null;   ArrayList list= new ArrayList();   //1.获得静态数据库连接类连接   Connection conn = DBUtil.getConn();   //2.定义sql语句   String sql = 'select * from product where pID=?';   //3.创建执行对象   PreparedStatement pstmt = null;   try {    pstmt = conn.prepareStatement(sql);    pstmt.setInt(1, pID);//给参数（?）赋值    rs = pstmt.executeQuery();//获取查询结果    while(rs.next()){     pro = new Product();     pro.setpID(rs.getInt('pID'));     pro.setpName(rs.getString('pName'));     pro.setStore(rs.getInt('store'));     pro.setPrice(rs.getInt('price'));     list.add(pro);      }   } catch (SQLException e) {    e.printStackTrace();   }finally{//关闭资源    DBUtil.closeResultSet(rs);    DBUtil.closeStatement(pstmt);    DBUtil.closeConn(conn);   }   return list;  }

第二步实现插入操作调用JAVA与sqlserver 2008R2的工具类实现插入操作：让其返回Arraylist的对象然后进行输出操作对应的JAVA代码是：

public ArrayList insertPro(Product pro) {   Connection conn = null;//连接对象   PreparedStatement pstmt = null;//参数化执行对象   ArrayList list= new ArrayList();       String sql = '  insert into product(pName,price,Store)values(?,?,?)';   try {    //1获得连接    conn = DBUtil.getConn();    //2创建执行对象    pstmt = conn.prepareStatement(sql);    //给参数赋值         pstmt.setString(1,pro.getpName());    pstmt.setInt(2,pro.getPrice());    pstmt.setInt(3,pro.getStore());    pstmt.executeUpdate();   } catch (Exception e) {    e.printStackTrace();   }finally{    //关闭资源    DBUtil.closeStatement(pstmt);    DBUtil.closeConn(conn);   }       list= Select(pro);   return list;  }  //查询刚插入的语句  public ArrayList Select(Product pro) {   ResultSet rs = null;   ArrayList list= new ArrayList();   //1.获得静态数据库连接类连接   Connection conn = DBUtil.getConn();   //2.定义sql语句   String sql = 'select * from product where pName=?';   //3.创建执行对象   PreparedStatement pstmt = null;   try {    pstmt = conn.prepareStatement(sql);    //给参数（?）赋值    pstmt.setString(1, pro.getpName());         //获取查询结果    rs = pstmt.executeQuery();    while(rs.next()){     pro = new Product();     pro.setpID(rs.getInt('pID'));     pro.setpName(rs.getString('pName'));     pro.setStore(rs.getInt('store'));     pro.setPrice(rs.getInt('price'));     list.add(pro);      }   } catch (SQLException e) {        e.printStackTrace();   }finally{    //关闭资源    DBUtil.closeResultSet(rs);    DBUtil.closeStatement(pstmt);    DBUtil.closeConn(conn);   }      return list;  }

在实现对JAVA工具类调用的时候需要完整的实现JAVA工具类

工具类里面需要导入jar包，不然会有错误的