<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %> Live Cricket Score
<%@ page import="java.lang.*"%> <%@ page language="java" %> <%@ page import="java.sql.*"%> <% String team1=""; String team2=""; String comments=""; String matchdate=""; String venue=""; String toss=""; String extras=""; String teamname=""; String score=""; String teamname2=""; String batsman=""; String out1=""; String runs=""; String balls=""; String fours=""; String sixs=""; String batsman2=""; String out12=""; String runs2=""; String balls2=""; String fours2=""; String sixs2=""; String batsman3=""; String out13=""; String runs3=""; String balls3=""; String fours3=""; String sixs3=""; String batsman4=""; String out14=""; String runs4=""; String balls4=""; String fours4=""; String sixs4=""; String batsman5=""; String out15=""; String runs5=""; String balls5=""; String fours5=""; String sixs5=""; String batsman6=""; String out16=""; String runs6=""; String balls6=""; String fours6=""; String sixs6=""; String batsman7=""; String out17=""; String runs7=""; String balls7=""; String fours7=""; String sixs7=""; String batsman8=""; String out18=""; String runs8=""; String balls8=""; String fours8=""; String sixs8=""; String batsman9=""; String out19=""; String runs9=""; String balls9=""; String fours9=""; String sixs9=""; String batsman10=""; String out110=""; String runs10=""; String balls10=""; String fours10=""; String sixs10=""; String batsman11=""; String out111=""; String runs11=""; String balls11=""; String fours11=""; String sixs11=""; String bowler1=""; String over1=""; String m1=""; String r1=""; String w1=""; String nb1=""; String wd1=""; String bowler2=""; String over2=""; String m2=""; String r2=""; String w2=""; String nb2=""; String wd2=""; String bowler3=""; String over3=""; String m3=""; String r3=""; String w3=""; String nb3=""; String wd3=""; String bowler4=""; String over4=""; String m4=""; String r4=""; String w4=""; String nb4=""; String wd4=""; String bowler5=""; String over5=""; String m5=""; String r5=""; String w5=""; String nb5=""; String wd5=""; String bowler6=""; String over6=""; String m6=""; String r6=""; String w6=""; String nb6=""; String wd6=""; String bowler7=""; String over7=""; String m7=""; String r7=""; String w7=""; String nb7=""; String wd7=""; String bowler8=""; String over8=""; String m8=""; String r8=""; String w8=""; String nb8=""; String wd8=""; %>

India vs West Indies

5th One Day International


<% try{ //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //Connection conn=DriverManager.getConnection("jdbc:odbc:crick","root","viky"); Class.forName("org.gjt.mm.mysql.Driver").newInstance(); Connection conn=DriverManager.getConnection("jdbc:mysql://198.65.112.185/cricket", "cricket", "cricketpwd12"); Statement s1=conn.createStatement(); String c_query1="SELECT team1,team2,comments,matchdate,venue,toss,extras,teamname,score,teamname2 FROM firsttab"; ResultSet rs1 = s1.executeQuery(c_query1); while(rs1.next()) { team1=rs1.getString("team1"); team2=rs1.getString("team2"); comments=rs1.getString("comments"); matchdate=rs1.getString("matchdate"); venue=rs1.getString("venue"); toss=rs1.getString("toss"); extras=rs1.getString("extras"); teamname=rs1.getString("teamname"); score=rs1.getString("score"); teamname2=rs1.getString("teamname2"); } Statement s2=conn.createStatement(); String c_query2="SELECT batsman,out,runs,balls,fours,sixs FROM secondtab where batsmanno='1'"; ResultSet rs2 = s2.executeQuery(c_query2); while(rs2.next()) { batsman=rs2.getString("batsman"); out1=rs2.getString("out"); runs=rs2.getString("runs"); balls=rs2.getString("balls"); fours=rs2.getString("fours"); sixs=rs2.getString("sixs"); } Statement s3=conn.createStatement(); String c_query3="SELECT batsman,out,runs,balls,fours,sixs FROM secondtab where batsmanno='2'"; ResultSet rs3 = s3.executeQuery(c_query3); while(rs3.next()) { batsman2=rs3.getString("batsman"); out12=rs3.getString("out"); runs2=rs3.getString("runs"); balls2=rs3.getString("balls"); fours2=rs3.getString("fours"); sixs2=rs3.getString("sixs"); } Statement s4=conn.createStatement(); String c_query4="SELECT batsman,out,runs,balls,fours,sixs FROM secondtab where batsmanno='3'"; ResultSet rs4 = s4.executeQuery(c_query4); while(rs4.next()) { batsman3=rs4.getString("batsman"); out13=rs4.getString("out"); runs3=rs4.getString("runs"); balls3=rs4.getString("balls"); fours3=rs4.getString("fours"); sixs3=rs4.getString("sixs"); } Statement s5=conn.createStatement(); String c_query5="SELECT batsman,out,runs,balls,fours,sixs FROM secondtab where batsmanno='4'"; ResultSet rs5 = s5.executeQuery(c_query5); while(rs5.next()) { batsman4=rs5.getString("batsman"); out14=rs5.getString("out"); runs4=rs5.getString("runs"); balls4=rs5.getString("balls"); fours4=rs5.getString("fours"); sixs4=rs5.getString("sixs"); } Statement s6=conn.createStatement(); String c_query6="SELECT batsman,out,runs,balls,fours,sixs FROM secondtab where batsmanno='5'"; ResultSet rs6 = s6.executeQuery(c_query6); while(rs6.next()) { batsman5=rs6.getString("batsman"); out15=rs6.getString("out"); runs5=rs6.getString("runs"); balls5=rs6.getString("balls"); fours5=rs6.getString("fours"); sixs5=rs6.getString("sixs"); } Statement s7=conn.createStatement(); String c_query7="SELECT batsman,out,runs,balls,fours,sixs FROM secondtab where batsmanno='6'"; ResultSet rs7 = s7.executeQuery(c_query7); while(rs7.next()) { batsman6=rs7.getString("batsman"); out16=rs7.getString("out"); runs6=rs7.getString("runs"); balls6=rs7.getString("balls"); fours6=rs7.getString("fours"); sixs6=rs7.getString("sixs"); } Statement s8=conn.createStatement(); String c_query8="SELECT batsman,out,runs,balls,fours,sixs FROM secondtab where batsmanno='7'"; ResultSet rs8 = s8.executeQuery(c_query8); while(rs8.next()) { batsman7=rs8.getString("batsman"); out17=rs8.getString("out"); runs7=rs8.getString("runs"); balls7=rs8.getString("balls"); fours7=rs8.getString("fours"); sixs7=rs8.getString("sixs"); } Statement s9=conn.createStatement(); String c_query9="SELECT batsman,out,runs,balls,fours,sixs FROM secondtab where batsmanno='8'"; ResultSet rs9 = s9.executeQuery(c_query9); while(rs9.next()) { batsman8=rs9.getString("batsman"); out18=rs9.getString("out"); runs8=rs9.getString("runs"); balls8=rs9.getString("balls"); fours8=rs9.getString("fours"); sixs8=rs9.getString("sixs"); } Statement s10=conn.createStatement(); String c_query10="SELECT batsman,out,runs,balls,fours,sixs FROM secondtab where batsmanno='9'"; ResultSet rs10 = s10.executeQuery(c_query10); while(rs10.next()) { batsman9=rs10.getString("batsman"); out19=rs10.getString("out"); runs9=rs10.getString("runs"); balls9=rs10.getString("balls"); fours9=rs10.getString("fours"); sixs9=rs10.getString("sixs"); } Statement s11=conn.createStatement(); String c_query11="SELECT batsman,out,runs,balls,fours,sixs FROM secondtab where batsmanno='10'"; ResultSet rs11 = s11.executeQuery(c_query11); while(rs11.next()) { batsman10=rs11.getString("batsman"); out110=rs11.getString("out"); runs10=rs11.getString("runs"); balls10=rs11.getString("balls"); fours10=rs11.getString("fours"); sixs10=rs11.getString("sixs"); } Statement s12=conn.createStatement(); String c_query12="SELECT batsman,out,runs,balls,fours,sixs FROM secondtab where batsmanno='11'"; ResultSet rs12 = s12.executeQuery(c_query12); while(rs12.next()) { batsman11=rs12.getString("batsman"); out111=rs12.getString("out"); runs11=rs12.getString("runs"); balls11=rs12.getString("balls"); fours11=rs12.getString("fours"); sixs11=rs12.getString("sixs"); } Statement s13=conn.createStatement(); String c_query13="SELECT bowler,over,m,r,w,nb,wd FROM thirdtab where bowlerno='1'"; ResultSet rs13 = s13.executeQuery(c_query13); while(rs13.next()) { bowler1=rs13.getString("bowler"); over1=rs13.getString("over"); m1=rs13.getString("m"); r1=rs13.getString("r"); w1=rs13.getString("w"); nb1=rs13.getString("nb"); wd1=rs13.getString("wd"); } Statement s14=conn.createStatement(); String c_query14="SELECT bowler,over,m,r,w,nb,wd FROM thirdtab where bowlerno='2'"; ResultSet rs14 = s14.executeQuery(c_query14); while(rs14.next()) { bowler2=rs14.getString("bowler"); over2=rs14.getString("over"); m2=rs14.getString("m"); r2=rs14.getString("r"); w2=rs14.getString("w"); nb2=rs14.getString("nb"); wd2=rs14.getString("wd"); } Statement s15=conn.createStatement(); String c_query15="SELECT bowler,over,m,r,w,nb,wd FROM thirdtab where bowlerno='3'"; ResultSet rs15 = s15.executeQuery(c_query15); while(rs15.next()) { bowler3=rs15.getString("bowler"); over3=rs15.getString("over"); m3=rs15.getString("m"); r3=rs15.getString("r"); w3=rs15.getString("w"); nb3=rs15.getString("nb"); wd3=rs15.getString("wd"); } Statement s16=conn.createStatement(); String c_query16="SELECT bowler,over,m,r,w,nb,wd FROM thirdtab where bowlerno='4'"; ResultSet rs16 = s16.executeQuery(c_query16); while(rs16.next()) { bowler4=rs16.getString("bowler"); over4=rs16.getString("over"); m4=rs16.getString("m"); r4=rs16.getString("r"); w4=rs16.getString("w"); nb4=rs16.getString("nb"); wd4=rs16.getString("wd"); } Statement s17=conn.createStatement(); String c_query17="SELECT bowler,over,m,r,w,nb,wd FROM thirdtab where bowlerno='5'"; ResultSet rs17 = s17.executeQuery(c_query17); while(rs17.next()) { bowler5=rs17.getString("bowler"); over5=rs17.getString("over"); m5=rs17.getString("m"); r5=rs17.getString("r"); w5=rs17.getString("w"); nb5=rs17.getString("nb"); wd5=rs17.getString("wd"); } Statement s18=conn.createStatement(); String c_query18="SELECT bowler,over,m,r,w,nb,wd FROM thirdtab where bowlerno='6'"; ResultSet rs18 = s18.executeQuery(c_query18); while(rs18.next()) { bowler6=rs18.getString("bowler"); over6=rs18.getString("over"); m6=rs18.getString("m"); r6=rs18.getString("r"); w6=rs18.getString("w"); nb6=rs18.getString("nb"); wd6=rs18.getString("wd"); } Statement s19=conn.createStatement(); String c_query19="SELECT bowler,over,m,r,w,nb,wd FROM thirdtab where bowlerno='7'"; ResultSet rs19 = s19.executeQuery(c_query19); while(rs19.next()) { bowler7=rs19.getString("bowler"); over7=rs19.getString("over"); m7=rs19.getString("m"); r7=rs19.getString("r"); w7=rs19.getString("w"); nb7=rs19.getString("nb"); wd7=rs19.getString("wd"); } Statement s20=conn.createStatement(); String c_query20="SELECT bowler,over,m,r,w,nb,wd FROM thirdtab where bowlerno='8'"; ResultSet rs20 = s20.executeQuery(c_query20); while(rs20.next()) { bowler8=rs20.getString("bowler"); over8=rs20.getString("over"); m8=rs20.getString("m"); r8=rs20.getString("r"); w8=rs20.getString("w"); nb8=rs20.getString("nb"); wd8=rs20.getString("wd"); } %>
<%=comments%>
<%=team1%> vs <%=team2%>
Date    : <%=matchdate%>

Venue  : <%=venue%>

Toss    : <%=toss%>

<%=teamname%> <%=score%> RUNS BALLS 4s 6s
<%=batsman%> <%=out1%> <%=runs%> <%=balls%> <%=fours%> <%=sixs%>
<%=batsman2%> <%=out12%> <%=runs2%> <%=balls2%> <%=fours2%> <%=sixs2%>
<%=batsman3%> <%=out13%> <%=runs3%> <%=balls3%> <%=fours3%> <%=sixs3%>
<%=batsman4%> <%=out14%> <%=runs4%> <%=balls4%> <%=fours4%> <%=sixs4%>
<%=batsman5%> <%=out15%> <%=runs5%> <%=balls5%> <%=fours5%> <%=sixs5%>
<%=batsman6%> <%=out16%> <%=runs6%> <%=balls6%> <%=fours6%> <%=sixs6%>
<%=batsman7%> <%=out17%> <%=runs7%> <%=balls7%> <%=fours7%> <%=sixs7%>
<%=batsman8%> <%=out18%> <%=runs8%> <%=balls8%> <%=fours8%> <%=sixs8%>
<%=batsman9%> <%=out19%> <%=runs9%> <%=balls9%> <%=fours9%> <%=sixs9%>
<%=batsman10%> <%=out110%> <%=runs10%> <%=balls10%> <%=fours10%> <%=sixs10%>
<%=batsman11%> <%=out111%> <%=runs11%> <%=balls11%> <%=fours11%> <%=sixs11%>

EXTRAS : <%=extras%>

<%=teamname2%> OVERS M R W Nb Wd
<%=bowler1%> <%=over1%> <%=m1%> <%=r1%> <%=w1%> <%=nb1%> <%=wd1%>
<%=bowler2%> <%=over2%> <%=m2%> <%=r2%> <%=w2%> <%=nb2%> <%=wd2%>
<%=bowler3%> <%=over3%> <%=m3%> <%=r3%> <%=w3%> <%=nb3%> <%=wd3%>
<%=bowler4%> <%=over4%> <%=m4%> <%=r4%> <%=w4%> <%=nb4%> <%=wd4%>
<%=bowler5%> <%=over5%> <%=m5%> <%=r5%> <%=w5%> <%=nb5%> <%=wd5%>
<%=bowler6%> <%=over6%> <%=m6%> <%=r6%> <%=w6%> <%=nb6%> <%=wd6%>
<%=bowler7%> <%=over7%> <%=m7%> <%=r7%> <%=w7%> <%=nb7%> <%=wd7%>
<%=bowler8%> <%=over8%> <%=m8%> <%=r8%> <%=w8%> <%=nb8%> <%=wd8%>
<% rs1.close(); rs2.close(); rs3.close(); rs4.close(); rs5.close(); rs6.close(); rs7.close(); rs8.close(); rs9.close(); rs10.close(); rs11.close(); rs12.close(); rs13.close(); rs14.close(); rs15.close(); rs16.close(); rs17.close(); rs18.close(); rs19.close(); rs20.close(); s1.close(); s2.close(); s3.close(); s4.close(); s5.close(); s6.close(); s7.close(); s8.close(); s9.close(); s10.close(); s11.close(); s12.close(); s13.close(); s14.close(); s15.close(); s16.close(); s17.close(); s18.close(); s19.close(); s20.close(); conn.close(); } catch (Exception e) { out.println(e); } %>
Website Development Company: Compare Infobase Pvt. Ltd