magic_money.jsp

论坛软件系统亦称电子公告板(BBS)系统

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<jsp:directive.page import="cn.jsprun.utils.DataParse"/>
<%@page import="cn.jsprun.utils.BeanFactory"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<%@ page import="cn.jsprun.domain.Members" %>
<%@ page import="org.hibernate.SessionFactory" %>
<%@ page import="cn.jsprun.utils.HibernateUtil" %>
<%@ page import="org.hibernate.Session" %>
<%@ page import="org.hibernate.Transaction" %>
<%! private final String tablePrefix = "jrun_"; %>
<%
boolean noException = false;
Integer targetuid = null;
Integer expiration = 0; 
boolean extra = false;
Members currentMember = (Members)session.getAttribute("user");
String magicid = request.getParameter("magicid");
Integer userid = (Integer)session.getAttribute("jsprun_uid");
targetuid = userid;
Integer pid = (Integer)request.getAttribute("targetPid");
Integer tid = (Integer)request.getAttribute("targetTid");
String targetUsername = (String)request.getAttribute("targetUsername");
SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
Session hibernateSession = sessionFactory.getCurrentSession();
Transaction transaction = hibernateSession.beginTransaction();	
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
try{
	connection = hibernateSession.connection();
	connection.setAutoCommit(false);
	statement = connection.createStatement();
	
	Integer nowtime = (Integer)request.getAttribute("timestamp");
	
	rs = statement.executeQuery("SELECT price FROM "+tablePrefix+"magics WHERE magicid="+magicid);
	if(!rs.next()){
		request.setAttribute("messageFromOperationMagic","道具不存在");
		return;
	}
	Integer magicsPrice = rs.getInt("price");
	Random random = new Random();
	int result = 1;
	if(magicsPrice>0){
		result = random.nextInt((int)(magicsPrice*1.5));
		if(result==0){
			result = 1;
		}
	}
	
	Map<String,String> settingMap = (Map<String,String>)request.getAttribute("settings");
	String extcreditsNum = settingMap.get("creditstrans");
	String creditsformula = settingMap.get("creditsformula");
	if(extcreditsNum==null||extcreditsNum.equals("")){
		request.setAttribute("messageFromOperationMagic","未定义的操作");
		return;
	}
	
	StringBuffer sqlBuffer = new StringBuffer("UPDATE "+tablePrefix+"members SET extcredits"+extcreditsNum+"=extcredits"+extcreditsNum+"+"+result);
	if(creditsformula.indexOf("extcredits"+extcreditsNum)>=0){
		sqlBuffer.append(",credits="+creditsformula);
	}
	sqlBuffer.append(" WHERE uid="+userid);
	statement.executeUpdate(sqlBuffer.toString());
	
	String tempString = settingMap.get("extcredits");;
	Map map_level2 = ((DataParse)BeanFactory.getBean("dataParse")).characterParse(tempString,false);
	Map map_level3 = ((Map)map_level2.get(Integer.valueOf(extcreditsNum)));
	String extcreditString = (String)map_level3.get("title");
	request.setAttribute("messageFromOperationMagic","恭喜您，获得 "+result+" "+extcreditString+" 请返回");
%>
<%@ include file="/include/magics/mLogAndmm.jsp" %>
<%
	connection.commit();
	noException = true;
}catch(Exception exception){
	connection.rollback();
	exception.printStackTrace();
	throw exception;
}finally{
	try{
		if(!noException&&connection!=null){
			connection.rollback();
		}
		if(rs!=null){
			rs.close();
			rs = null;
		}
		if(statement!=null){
			statement.close();
			statement = null;
		}
		if(connection != null){
			connection.close();
			connection = null;
		}
	}catch(Exception exception2){
		exception2.printStackTrace();
	}
}
%>