为了节约空间上面就不说了 PreparedStatement jfitemps = DB
.prepareStatement("SELECT * FROM player_items WHERE itemName='" + itemName + "'");
if(jfitemps==null){
PacketSendUtility.sendMessage(admin, "语法:在积分商城里找不到关于["+itemName+"]的相关数据.");
return;
}
else
{
try
{
ResultSet jfitemrs = jfitemps.executeQuery();
if(jfitemrs.next())
{
this.itemId = jfitemrs.getInt("itemId");
this.price = jfitemrs.getInt("Price");
this.num = jfitemrs.getInt("Num");
item(admin, itemId, price, itemCount, num);
}
}
catch(SQLException e)
{
PacketSendUtility.sendMessage(admin, "语法:在积分商城里找不到关于["+itemName+"]的相关数据.");
return;
}
finally
{
DB.close(jfitemps);
}
}
} public void item(Player player, final int itemId, int Price, final int itemCount, final int num)
{
int oldjf = player.getCommonData().getPlayerjf();
if(oldjf - (Math.floor((Price * itemCount)*(3/2/2))) >0&& num - itemCount > 0)
{ int count = itemService.addItem(player, itemId, itemCount); if(count==0)
{
DB.insertUpdate("UPDATE player_items SET Num=? WHERE itemId=?", new IUStH(){
@Override
public void handleInsertUpdate(PreparedStatement stmt) throws SQLException
{
stmt.setInt(1, num - itemCount);
stmt.setInt(2, itemId);
stmt.execute();
}
});
player.getCommonData().setPlayerjf(oldjf - (Math.floor((Price * itemCount)*(3/2/2)));
PacketSendUtility.sendMessage(player, "提示:购买" + itemCount + "个[" + itemName + "]成功.");
PacketSendUtility.sendMessage(player, "您的剩余积分:" + (oldjf - (Math.floor((Price * itemCount)*(3/2/2))) + "物品[" + itemName + "]的剩余数量:"
+ (num - itemCount));
}
else
{
PacketSendUtility.sendMessage(player, "提示:物品[" + itemName + "]购买失败.");
return;
}
}
else
{
if(itemCount > num)
PacketSendUtility.sendMessage(player, "提示:物品[" + itemName + "]库存不足.");
else if(num-itemCount<0)
PacketSendUtility.sendMessage(player, "提示:物品[" + itemName + "]没有库存了.");
else
PacketSendUtility.sendMessage(player, "提示:您的积分为"+ oldjf+",不足以购买" + itemCount + "个[" + itemName + "].");
PacketSendUtility.sendMessage(player, "所需积分:" + Price * itemCount + "物品剩余数量:" + num);
return;
}
}
}只需要把这个算法(Price * itemCount)*(3/2/2) 算出来的然后四舍五入成整数然后用oldjf去减他。
各位大鸟一定要帮帮我哦!