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);             System.out.println("Data has been Sucessfully Writeen to "+file);         } catch (Exception e) {             e.printStackTrace();         }    
Read more

Online Book Store Website Using Java

-
Image
=============================================== Login.html:- ================================================ <html>     <title>|| Login Page ||</title>     <body class="bod">         <form action='login.action'  method="post">             <table align='center'>                 <tr><td colspan='2' align='center'>                         <br></br>                         <h2 style="color: black; font-size: 30px; padding-top: 1%;" class="Head">User Login</h2></td></tr>                 <tr>                     <td><h2>UserName</h2></td>                     <td><input type='text' name='UserName' placeholder="UserName" autocomplete="off" required=""/></td></tr>                 <tr>                     <td><h
Read more

How to read CSV File in Java

-
Here we can learn how to read CSV file comma seprated in java below is the code --> Use apache API to read CSV or use BufferReader --> here i have used Buffer Reader import java.io.BufferedReader; import java.io.FileNotFoundException; import java.io.FileReader; import java.io.IOException; /**  *  * @author anand  *  */ public class ReadCSVFile {     public static void main(String[] args) {               BufferedReader br = null;         String line = "";         String cvsSplitBy = ","; //Comma seprated         try {             br = new BufferedReader(new FileReader("Your_CSV_FILE_NAME"));             while ((line = br.readLine()) != null) {                 System.out.println("Content \t"+line);             }         } catch (Exception e) {             e.printStackTrace();         } finally {             if (br != null) {                 try {                     br.close();                 } catch (I
Read more