游戏的收藏功能

先查询是否已经收藏了：
//从数据中查看是否为喜欢的游戏
    public void getlikegameWeb(){
        params.clearParams();
        params.addQueryStringParameter("flag","getlike");
        params.addQueryStringParameter("user_id",user_id+"");
        Log.e("zjn", "getlikegameWeb: "+user_id);
        params.addQueryStringParameter("game_id",game.getGame_id()+"");
        x.http().get(params, new Callback.CommonCallback<String>() {
            @Override
            public void onSuccess(String result) {
                if (result.equals("ok")) {
                    like.setChecked(true);
                }


            }
服务端：
imp：
//查看是否为喜欢的游戏
public MyLikeGame getlike(int user_id,int game_id){
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
MyLikeGame likegame=null;
conn=JdbcUtils.getConnection();
try {
ps=conn.prepareStatement("select * from mylikegame where user_id=? and game_id=?");
ps.setInt(1, user_id);
ps.setInt(2, game_id);
rs=ps.executeQuery();
while (rs.next()){
likegame=new MyLikeGame(rs.getInt("user_id"),rs.getInt("game_id"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return likegame;
}
servlet：
case "getlike":
int user_id=Integer.parseInt(request.getParameter("user_id"));
int game_id2=Integer.parseInt(request.getParameter("game_id"));
MyLikeGame likegame=null;
likegame=new Game_tetail_dao().getlike(user_id, game_id2);

if(likegame!=null){
printWriter.write("ok");
}else{

}
printWriter.close();
break;
再判断按下的时候是收藏还是取消：
 like.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                if (like.isChecked()){
                   addlike_game();
                }else {
                    outlike_game();
                }
            }
        });
//收藏游戏
   public void addlike_game(){
        params.clearParams();
       params.addQueryStringParameter("flag","addlike");
       params.addQueryStringParameter("user_id",user_id+"");
       params.addQueryStringParameter("game_id",game.getGame_id()+"");
       x.http().get(params, new Callback.CommonCallback<String>() {
           @Override
           public void onSuccess(String result) {
               if (result.equals("success")){
                   like.setChecked(true);
                   Toast.makeText(detailActivity.this,"收藏成功",Toast.LENGTH_SHORT).show();
               }else if (result.equals("failure")){
                   like.setChecked(false);
                   Toast.makeText(detailActivity.this,"收藏失败",Toast.LENGTH_SHORT).show();
               }else {
                   Toast.makeText(detailActivity.this,"未知错误",Toast.LENGTH_SHORT).show();
               }
           }
//取消收藏
    public void outlike_game(){
        params.clearParams();
        params.addQueryStringParameter("flag","outlike");
        params.addQueryStringParameter("user_id",user_id+"");
        params.addQueryStringParameter("game_id",game.getGame_id()+"");
        x.http().get(params, new Callback.CommonCallback<String>() {
            @Override
            public void onSuccess(String result) {
                if (result.equals("success")){
                    like.setChecked(false);
                    Toast.makeText(detailActivity.this,"取消收藏成功",Toast.LENGTH_SHORT).show();
                }else if (result.equals("failure")){
                    like.setChecked(true);
                    Toast.makeText(detailActivity.this,"取消收藏失败",Toast.LENGTH_SHORT).show();
                }else {
                    Toast.makeText(detailActivity.this,"未知错误",Toast.LENGTH_SHORT).show();
                }
            }
服务端：
imp：
//添加收藏
public int addlike(int user_id,int game_id){
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
int like=0;
conn=JdbcUtils.getConnection();
try {
ps=conn.prepareStatement("insert into mylikegame (user_id,game_id) values (?,?)");
ps.setInt(1, user_id);
ps.setInt(2, game_id);
like=ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return like;
}
//取消收藏
public int outlike(int user_id,int game_id){
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
int out=0;
conn=JdbcUtils.getConnection();
try {
ps=conn.prepareStatement("delete from mylikegame where user_id=? and game_id=?");
ps.setInt(1, user_id);
ps.setInt(2, game_id);
out=ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return out;
}
Servlet：
case "addlike":
int user_id1=Integer.parseInt(request.getParameter("user_id"));
int game_id21=Integer.parseInt(request.getParameter("game_id"));
int add=0;
add=new Game_tetail_dao().addlike(user_id1, game_id21);
if(add==1){
printWriter.write("success");
}else{
printWriter.write("failure");
}

printWriter.close();
System.out.println("addlike"+add);
break;
case "outlike":
int user_id2=Integer.parseInt(request.getParameter("user_id"));
int game_id22=Integer.parseInt(request.getParameter("game_id"));
int out=0;
out=new Game_tetail_dao().outlike(user_id2, game_id22);
if(out==1){
printWriter.write("success");
}else{
printWriter.write("failure");
}
System.out.println("outlike.doGet()"+out);
printWriter.close();
break;
default:
break;
}

}