|
|
| udn / 追星網 / 娛樂專題 |
<%
// 上方的 tag 是檢查是否有登入
String RootUrl = StarUtil.getPropertiesInfo("StarSite");
String ImageUrl = StarUtil.getPropertiesInfo("StarSite")+"/images";
Connection conn=ConnPool.getConn();
PreparedStatement pstmt=null;
ResultSet rs=null;
PreparedStatement pstmt_d=null;
ResultSet rs_d=null;
//要改的參數區>>>
String gift_id = "2003040301"; //
int start_date= 20030510; // 活動開始日期
int end_date = 20030602; // 活動結束日期
String action_url = "gift2003040301.jsp"; // 活動資料輸入結果處理的式程式 , 通常是本程式
String rediret_url = "/udnstars/index.html"; // 如果資料正確無誤時要導到的網頁位置
//end of 要改的參數區<<<
Calendar calendar;
calendar = Calendar.getInstance();
// 加 100 是為了 補 0
String cDay = String.valueOf(calendar.get(Calendar.DAY_OF_MONTH)+100).substring(1,3);
String cMonth = String.valueOf(calendar.get(Calendar.MONTH)+1+100).substring(1,3);
String cYear = String.valueOf(calendar.get(Calendar.YEAR));
int Err = -1;
String ErrDesc ="";
int to_Day = Integer.parseInt(cYear+cMonth+cDay);
int nFanIndex = 0;
if ( request.getParameter("hidFanIndex") != null && !request.getParameter("hidFanIndex").equals("") ){
nFanIndex = Integer.parseInt(request.getParameter("hidFanIndex"));
}
int AUTHORITY=0;
if (nFanIndex == 1)
{
String userid=null;
String twn_id=null;
String address=null;
if ( request.getParameter("name") != null && !request.getParameter("name").equals("")){
String strUserId = request.getParameter("name");
String strUserPwd = request.getParameter("pwd");
userid = strUserId;
pstmt=conn.prepareStatement("select authority,twn_id,address from stars_member where user_id='"+strUserId+"' and password='"+strUserPwd+"'");
rs=pstmt.executeQuery();
if ( rs.next() ){
AUTHORITY = Integer.parseInt(rs.getString("authority"));
twn_id = rs.getString("twn_id");
address = rs.getString("address");
if (AUTHORITY == 2 && to_Day >= start_date && to_Day <= end_date ) {
String qSQL = "select user_id from stars_gift_user where user_id ='"+userid+"' and gift_id='"+gift_id+"'";
String iSQL = "insert into stars_gift_user values('"+gift_id+"','" + userid + "','"+to_Day+ "')";
String uSQL = "update stars_gift_user set q_date='"+to_Day+ "' where user_id = '"+userid+"'and gift_id='"+gift_id+"'";
pstmt=conn.prepareStatement(qSQL);
rs=pstmt.executeQuery();
if (rs.next()) { // 表示有資料了
pstmt_d=conn.prepareStatement(uSQL);
rs_d=pstmt_d.executeQuery();
} else {
pstmt_d=conn.prepareStatement(iSQL);
rs_d=pstmt_d.executeQuery();
}
Err = 0;
// 還未填寫身份證字號或地址
if (twn_id == null || twn_id.equals("")){
ErrDesc = "身份證字號";
Err = 2;
}
if (address == null || address.equals("")){
ErrDesc = ErrDesc+"地址";
Err = 2;
}
}else{
// 還未認証
ErrDesc = "會員身份還未認證";
Err = 3;
}
} else{
Err = 1;
ErrDesc = "尚未加入會員";
}
} // end of if request.getParameter("name") == null
} //結束作業 end of if if (nFanIndex == 1)
StarUtil.closeConnect(conn,pstmt,rs);
conn=null;
pstmt=null;
rs=null;
StarUtil.closeConnect(null,pstmt_d,rs_d);
pstmt_d=null;
rs_d=null;
%>
|
|
|
|
|
|
|
