To see the story click here.

Index

Keyword search
Keyword search
Word search
Give your feedback
Journey through site

 
Back Next
<%@ page import="java.sql.*"%> <% String connectionURL="jdbc:mysql://localhost/jenkins_dbproject"; Connection connection=null; Statement statement=null; ResultSet rs=null; Class.forName("com.mysql.jdbc.Driver").newInstance(); connection=DriverManager.getConnection(connectionURL,"jenkins_anirban","anirban"); statement=connection.createStatement(); rs=statement.executeQuery("SELECT DISTINCT WordCategory FROM dictionary ORDER BY WordCategory"); String keyword; keyword=request.getParameter("word_cat"); %>
Choose Category:
<% if (keyword !="") rs=statement.executeQuery("SELECT * FROM dictionary WHERE WordCategory='"+keyword+"'"); %> <% while(rs.next()) { out.println(""); out.println(""); out.println(""); out.println(""); } %>
English Word Portuguese Word
"); out.println(rs.getString("EngWord")); out.println(""); out.println(rs.getString("PortuWord")); out.println("
Back Next