|
|
|
|
|
|
|
|
|
<%@ page import="
import java.sql.*;
import weblogic.jdbc20.common.*;
import java.util.*;
import java.text.*;
import com.oreilly.servlet.*;"
%>
<%!
static String basedate="20001127";
static final int IC_ERROR=-1;
static final int IC_OK =0;
private String encode="ISO8859_1";
public String getCorrectString(String source,String enc)
{
try{
if(source==null) return null;
return (enc.length()>2)? (new String(source.getBytes(enc),"GBK")):source;
}
catch(Exception e)
{
e.printStackTrace(System.err);
return null;
}
}
public String getCorrectString(String ori) throws Exception
{
if(ori==null) return "";
return (encode.length()>2)? (new String(ori.getBytes(encode))):ori;
}
%>
<%
/*
用户对歌曲投票
*/
Connection conn=null;
Statement stmt=null;
Statement stmt2=null;//debug
ResultSet rs=null;
ResultSet rs2=null;
int connRc=IC_OK;
try
{
Properties props=new Properties();
props.put("connectionPoolID","oraclePool");
Driver mydriver=(Driver)Class.forName("weblogic.jdbc20.pool.Driver").newInstance();
conn=mydriver.connect("jdbc20:weblogic:pool",props);
conn.setAutoCommit(false);
}
catch(Exception e_conn)
{
e_conn.printStackTrace(System.err);
connRc=IC_ERROR;
}
if (connRc==IC_ERROR)
{
%>
与数据库连接失败,可能由于系统繁忙所致,请稍后再试。
<% return;
}
try
{
String sqlstr="";
String datestring="";
stmt=conn.createStatement();
stmt2=conn.createStatement();
/*
Select
T1.SONGID,
T1.SONGNM,
T1.VOTENUM,
T2.WRITENM,
T2.SONGSTER,
T2.COMPANY,
T2.SINGING
From CCTV.TAB_SONGORDER T1, CCTV.TAB_SONGS T2
Where
(T1.SONGID=T2.SONGSID) and
trunc((sysdate-to_date('20001127','yyyymmdd'))/7)
=trunc((to_date(opendate,'yyyymmdd')-to_date('20001127','yyyymmdd'))/7)
and upflg=1
order by votenum desc
*/
//****************************************************************************************
sqlstr=" Select "+
" T1.SONGID,"+
" T1.SONGNM,"+
" T1.VOTENUM,"+
" T2.WRITENM,"+
" T2.SONGSTER,"+
" t2.singing,"+
" T2.COMPANY,"+
" T2.SINGING"+
" From CCTV.TAB_SONGORDER T1, CCTV.TAB_SONGS T2 "+
" Where "+
" (T1.SONGID=T2.SONGSID) and"+
" trunc((sysdate-to_date('20001127','yyyymmdd'))/7) "+
" =trunc((to_date(opendate,'yyyymmdd')-to_date('20001127','yyyymmdd'))/7)"+
" and upflg=1 and ordercls=5 "+
" order by votenum desc";
//out.println(sqlstr+"**********");
rs=stmt.executeQuery(sqlstr);
// the next 表头
%>
<%
}//try
catch (SQLException ee)
{
try {
out.println("something is wrong!");
conn.rollback();
}
catch(Exception e0)
{
e0.printStackTrace(System.err);
}
ee.printStackTrace();
}
catch (Exception e23)
{
out.println(e23);
}
finally
{
try {conn.commit();} catch (Exception e){}
try {if (rs!=null)rs.close(); } catch (Exception e) {}
try {if (rs2!=null)rs2.close(); } catch (Exception e) {}
try {stmt.close(); } catch (Exception e) {}
try {stmt2.close();} catch (Exception e) {}
try {conn.close(); } catch (Exception e) {}
}
/* table tab_songorder 上榜歌曲
Name Null? Type
----------------------------------------------------- -------- ----------------
ORDERID NOT NULL NUMBER(38)
ORDERCLS NOT NULL NUMBER(38)
ORDERNM VARCHAR2(32)
SONGORD NUMBER(38)
ISSUE NUMBER(38)
SONGID NUMBER(38)
SONGNM VARCHAR2(64)
VOTENUM 投票数量 NUMBER(38)
OPENDATE 上榜日期 VARCHAR2(8)
RECDATE DATE
UPFLG 上榜标记 NUMBER(38)
table tab_songvote
Name Null? Type
----------------------------------------------------- -------- -------------------
USRID 用户id NOT NULL VARCHAR2(40)
VOTEDATE 投票日期 NOT NULL DATE
SONGID 歌曲id NOT NULL NUMBER(38)
table tab_songs;
Name Null? Type
----------------------------------------------------- -------- --------------------
SONGSID NOT NULL NUMBER(38)
SONGSNM VARCHAR2(64)
SONGCLS NUMBER(38)
WRITENM VARCHAR2(32)
SONGSTER VARCHAR2(32)
LYRIC VARCHAR2(1024)
COMPANY VARCHAR2(128)
BRIEF VARCHAR2(1024)
SONGPIC BLOB
PICNAME VARCHAR2(64)
RECBYID NUMBER(38)
RECBYNM VARCHAR2(32)
RECDATE NOT NULL DATE
WEBPATH VARCHAR2(256)
FILNAME VARCHAR2(64)
SINGING VARCHAR2(32)
SONGFNM VARCHAR2(64)
SONGTYP VARCHAR2(8)
SONGPATH NOT NULL BINARY FILE LOB
MEDIACLS NUMBER(38)
TRANSMITTED NOT NULL NUMBER(3)
COMPOSEFLG NUMBER(38)
SONGFLG NUMBER(38)
*/
//true jsp ended here
%>
|
|
|
|
投票细则: |
|
|
1、欢迎您成为“央视流行音乐榜”的注册会员。
2、注册后,您便拥有了为本榜投票的权限。
3、您每周只能为一首“候榜歌曲”投1票,每周可以投票10次。
4、当您成为“央视流行音乐榜”的注册会员后,便有机会参加我们组织的各类活动。
|
|
|
|
|
|
|
|