<%@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(); %> ONCO: Database for cancer sites

Home