<%@ page import="java.sql.*,java.io.*"%> <% Connection con=null; Statement stmt=null; ResultSet rs=null; String url = "jdbc:mysql://localhost/baburao_indiakisan"; String query = "select * from advisory_districts"; try { Class.forName("com.mysql.jdbc.Driver"); } catch(java.lang.ClassNotFoundException e) { System.err.print("ClassNotFoundException: "); System.err.println(e.getMessage()); } try { con = DriverManager.getConnection(url,"baburao_india","ind123"); stmt = con.prepareStatement(query); rs = stmt.executeQuery(query); } catch(Exception ex) { ex.printStackTrace(); } rs.next(); String one=rs.getString(3); rs.next(); String two=rs.getString(3); rs.next(); String three=rs.getString(3); %> INFORMATION SYSTEM

AN EXPERT ADVISORY SYSTEM FOR IRRIGATED CROP PLANNING

INFORMATION SYSTEM

THE FOLLOWING ARE THE LIST OF DISTRICTS COMING UNDER NAGARJUNASAGAR PROJECT LEFT CANAL COMMAND AREA

Districts

Area S. No DISTRICT NAME  

Soils 1 <%=one%>

Crops 2 <%=two%>

Home 3 <%=three%>
   
A WEB BASED ADVICE ON IRRIGATED CROP PLANNING