Database Important Point

-
Database basically Used to store the data in tabular format . but this is only possible because of RDBMS Technology.
> RDBMS(Relational Database Management System ) :-used to store data in tabular format .
_________________________________________________________________________________
.
Basic Command used in Command console 
> create Database Anand;
> show databases;
> use Anand;
> show tables;
> CREATE TABLE STUDENTS(SID INT,SNAME VARCHAR(15),EMAIL VARCHAR(30),PHONE LONG,FEE FLOAT);
> INSERT INTO STUDENTS VALUES(101,'Anand',"anand@blore.COM",8985558,9979.99);
INSERT INTO STUDENTS VALUES(102,'Antrish',"antrish@blore.COM",8944589,9949.99);
INSERT INTO STUDENTS VALUES(103,'Ajeet',"ajeet@blore.COM",8983389,9299.99);
> drop database Anand;
> Select * from Students 


 ============Better see attached image ==================

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