<%@ page import="java.sql.*,java.io.*"%> <% Connection con=null; Statement stmt=null; ResultSet rs1=null; ResultSet rs2=null; ResultSet rs3=null; ResultSet rs5=null; ResultSet rs6=null; String url = "jdbc:mysql://localhost/baburao_indiakisan"; String query1 = "select * from advisory_irrigation"; String query2 = "select * from advisory_districts"; String query3 = "select * from advisory_soils"; String query5 = "select * from advisory_months"; String query6 = "select * from advisory_season"; 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(query1); rs1 = stmt.executeQuery(query1); stmt = con.prepareStatement(query2); rs2 = stmt.executeQuery(query2); stmt = con.prepareStatement(query3); rs3 = stmt.executeQuery(query3); stmt = con.prepareStatement(query5); rs5 = stmt.executeQuery(query5); stmt = con.prepareStatement(query6); rs6 = stmt.executeQuery(query6); } catch(Exception ex) { ex.printStackTrace(); } %> ADVISORY SYSTEM

AN EXPERT ADVISORY SYSTEM FOR IRRIGATED CROP PLANNING

ADVISORY SYSTEM

SELECT ANY OF THE FOLLOWING DISTRICTS TO GET THE CROPS OF THE DISTRICT COMING UNDER NAGARJUNASAGAR PROJECT LEFT CANAL COMMAND AREA

Crop Planning

Dos and Don'ts
SELECT IRRIGATION    

Home

SELECT DISTRICT       

  SELECT SOIL               
SELECT SEASON        
SELECT MONTH         
 
A WEB BASED ADVICE ON IRRIGATED CROP PLANNING