How to populate Drop Down From Database Table in Java

-
Before create project you have to understand from a JSP file you have to create JDBC Connection with default port 3306  and call HTML Code inside JSP page :--

 ==========================index.jsp====================================


<%@ page import="java.sql.*" %>
<%ResultSet resultset =null;%>

 <HTML>
<HEAD>
    <TITLE>Welcome in Java by Anand,Bangalore</TITLE>
</HEAD>

 <BODY BGCOLOR=#66CCFF>

 <%
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/Anand";
con = DriverManager.getConnection(url, "root", "pass@123");
    Statement statement = con.createStatement() ;
    resultset =statement.executeQuery("select * from blore") ;
%>

       <center>
    <h1> Welcome in Java by Anand,Bangalore</h1>
        <select>
        <%  while(resultset.next()){ %>
            <option><%= resultset.getString(2)%></option>
        <% } %>
        </select>
     </center>

 <%

         }
        catch(Exception e)
        {
             out.println("wrong entry"+e);
        }
%>

 </BODY>
</HTML>

 ======================Create Table Form DB=========================

 > Create Database Anand;
> use Anand;
> Create table blore(id int(4), city varchar(30));;
>  insert into blore values('1',"Rewa");
insert into blore values('2',"Pune");
insert into blore values('3',"Bangalore");
insert into blore values('4',"Satna");

Comments

Post a Comment

Popular posts from this blog

Converting JSONArray into CSV file in java

-
package com.loginController; import java.io.File; import org.apache.commons.io.FileUtils; import org.json.CDL; import org.json.JSONArray; import org.json.JSONObject; /**  *  * @author anand  *  */ public class ConvertArray {     public static void main(String myHelpers[]){         String jsonArrayString = "{\"fileName\": [{\"name\": \"Anand\",\"last\": \"Dwivedi\",\"place\": \"Bangalore\"}]}";         JSONObject output;         try {             output = new JSONObject(jsonArrayString);             JSONArray docs = output.getJSONArray("fileName");             File file=new File("JSONSEPERATOR.csv");             String csv = CDL.toString(docs);             FileUtils.writeStringToFile(file, csv);         ...
Read more

Java Design pattern

-
 Singleton Design pattern :-  it's Creational Design Pattern as we need to have only one instance of our class for Ex:- Logger,DBConnector. SingleObject class have its constructor as private and have a static instance of itself. Code:-  public class Singleton { private static Singleton object; private Singleton() { } public static synchronized Singleton getInstance() { if (object == null) object = new Singleton(); return object; } } Eager Initialization :-  public class Singleton { private static Singleton object = new Singleton(); private Singleton() { } public static Singleton getInstance() { return object; } } Double checked Locking :-  public class Singleton { private static volatile Singleton obj = null; private Singleton() { } public static Singleton getInstance() { if (obj == null) { synchronized (Singleton.class) { if (obj == null) obj = new Singleton(); } } ...
Read more

Map class field to map

-
 import java.lang.reflect.Field; import java.util.HashMap; import java.util.Map; public class AutogeneratedClassMapper {     public static Map<String, Object> mapFieldsToMap(Object obj) throws IllegalAccessException {         Map<String, Object> fieldMap = new HashMap<>();         Class<?> clazz = obj.getClass();         Field[] fields = clazz.getDeclaredFields();         for (Field field : fields) {             field.setAccessible(true);             Object value = field.get(obj);             fieldMap.put(field.getName(), value);         }         return fieldMap;     }     // Example usage     public static void main(String[] args) throws IllegalAccessException {         AutogeneratedClass au...
Read more