hibernate执行sql语句 查询 删除

15,344 阅读1分钟

//执行删除sql语句

@Override

    public void deleteById(String id) {
        // TODO Auto-generated method stub
        int a=this.getCurrentSession().createSQLQuery("delete from players where id='"+id+"'").executeUpdate();
        System.out.println(a+id);

    }

//执行查询sql语句:返回单个值

    @Override
    public String getSingle(String sql) {
        // TODO Auto-generated method stub
        System.out.println("getSTINGNNNNNNNNNNNNNNNNNNNNNNNNNN");
        String back=this.getCurrentSession().createSQLQuery(sql).uniqueResult().toString();
        System.out.println(back);
        return back;
    }