%@page import="java.util.*,java.net.*,java.text.*,java.util.zip.*,java.io.*,java.lang.*, java.sql.*;"%>
<%
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
String jdbcURL="jdbc:mysql://10.209.96.4:3306/test";
conn = DriverManager.getConnection(jdbcURL,"drugaddict", "");
PreparedStatement psSelectRecord=null;
ResultSet rsSelectRecord=null;
String sqlSelectRecord=null;
// sqlSelectRecord ="SELECT Userid, title,firstname, surname, lcase(address1)as address1,lcase(city)as city,lcase(state)as state, deg,lcase(edu)as edu, email, phone FROM Training_fac order by userid ";
// sqlSelectRecord ="SELECT * from genedetail order by GeneName ";
sqlSelectRecord ="SELECT * from Breast_Cancer_Genes_analysed where GeneName != 'PLAUR'AND GeneName !='THRA'";
psSelectRecord=conn.prepareStatement(sqlSelectRecord);
rsSelectRecord=psSelectRecord.executeQuery();
%>
Home
Breast Cancer Genes
S.no. |
GeneName |
TranscriptionFactor |
Chromosome |
Starting Position |
Binding Sequence |
Length |
Unique Sequence | Length Sequence | Occurrence in Genome | <%
int cnt=1;
while(rsSelectRecord.next())
{
%>
---|
<%int s=cnt;%>
<%String s1=rsSelectRecord.getString("GeneName");%>
<%String s2=rsSelectRecord.getString("TranscriptionFactor");%>
<%String s3=rsSelectRecord.getString("chromosome");%>
<%String s4=rsSelectRecord.getString("StartingPosition");%>
<%String s5=rsSelectRecord.getString("Bindingposition");%>
<%String s6=rsSelectRecord.getString("BindingSequence");%>
<%String s7=rsSelectRecord.getString("Length");%>
<%String s8=rsSelectRecord.getString("UniqueSequence");%>
<%String s9=rsSelectRecord.getString("Lengthofsequence");%>
<%
cnt++; /// increment of counter
%><%
out.println(""+s+" | ");
out.println(""+s1+" | ");
// out.println(""+s1+" | ");
out.println(""+s2+" | ");
// out.println(""+s1+" | ");
out.println(""+s3+" | ");
out.println(""+s4+" | ");
out.println(""+s5+" | ");
out.println(""+s6+" | ");
out.println(""+s7+" | ");
out.println(""+s8+" | ");
out.println(""+s9+" | ");
// out.println(""+s4+" | ");
//out.println(""+s5+" | ");
// out.println(""+s6+" | ");
//out.println(""+s6+" | ");
} /// End of while loop
%>
<%
try{
if(psSelectRecord!=null)
{
psSelectRecord.close();
}
if(rsSelectRecord!=null)
{
rsSelectRecord.close();
}
if(conn!=null)
{
conn.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
%>