Coding That Works

  To Display Database Values into Java Text Field   Using My SQL Database(backend) and Java Swing(Front end JFrame)... First make a Database Connection (JFrame to MYSQL ) using Following Code: public static Connection getConnection() throws Exception{ try { String driver="com.mysql.cj.jdbc.Driver"; String url="jdbc:mysql://127.0.0.1:3306/sch_db"; String username="root"; String password="Grace@908"; Class.forName(driver); Connection conn=DriverManager.getConnection(url,username,password); System.out.println("Connected"); return conn; } catch(Exception e) {System.out.println(e);} return null; }; sch_db is Database schema,  download mysql database connector Driver from Net,   when user enters Admission No of student , and press Enter we took it as Event of Action  performed(Right Click on Admission No field) following is the Code AdmNo = new JTextField(); AdmNo.setBackground(Color.LIGHT_GRAY);...

Database Concepts -Part II(Brief Introduction)   Primary Key & Foreign Key Constraints When Primary key of any table is included in any other table then this column is referred to as Foreign key.Let us see this through an example. In our student table , Admission No is Primary key so as to identify each and every student. Let us make another table "Monthly_Fee" in which we store monthly fee paid by each student in every month, to accomodate this we make following table as Monthly_Fee Fee_Month, Fee_Date,(Primary Key) Admission_No (Foreign Key) Receipt_No(Primay Key) Fee_amount & so on  Two or more column can be combined to defined as Composite Primary Key Here we define Receipt_No + Fee_Date column as Composite Primary Key. Most Commonly used SQL Command : To access column(s) from database table, one can use SELECT command ,Syntax of Select command as follows: Select Column(s) from Table where condition(Column name) one can select multiple Column name separated by com...

Database Concepts -Part I(Brief Introduction)   To gather/collect information of same entity/things in systematic way in the form of rows and columns and extract the information from the rows on the basis of columns. For example to store the details of  students of particular school/collage we arrange the information in the form of columns(user defined) then store rows of data of different students. Let us further expand that to define attributes of students such as Admission No,, Name ,Gender, Date of Birth, Class/Grade, Section, Religion, address, city, State, Country , Father's Name, Mother's Name, occupation etc. These are Columns and each & every students must have all or some information to store that makes rows. One thing is important is that for each and every student Admission No.is must and is unique & can not be blank(null) so as to identify the one particular student. So we make Admission No. Primary key . This arrangement of rows and columns is called TABL...

 Connection of MySql database to Java Swing JFrame(Forms designed in Window Builder in eclipse) Following is the code: public static Connection getConnection() throws Exception{ try { String driver="com.mysql.cj.jdbc.Driver"; String url="jdbc:mysql://127.0.0.1:3306/sch_db"; String username="root"; String password="Grace@908"; Class.forName(driver); Connection conn=DriverManager.getConnection(url,username,password); System.out.println("connected"); return conn; } catch(Exception e) {System.out.println(e);} return null; } getConnection() Function is written, driver is needed for connection that is mysql jdbc driver  declared in String variable driver.(driver is downloaded from internet) Variable url decalred name of mysql jdbc driver, mysql uses default IP address and Port when installing mysql.sch_db is database name which is created in mysql.Remaining is Username(default) and password(user def...

 Let me introduce myself I am Software Developer having 27 years of experience of Software Development including not just coding but from User's needs/requirements ,feasibility study ,Design of Databases(Backend) & Frontend( Forms & Reports) apart from that I extend technical support to my team as well as to clients. My Technical Background ranges from PG..Diploma to Best Certification from India and around the world(online courses) to name a few just have a look Computer Society Of India(Unix & C- 1989),Sql Star International(Oracle India Franchisee-Oracle ,PLSql/ D2k 1996), IBM Hadoop Certification(2016),Data Analytics from IIT Madras(NPTEL Exam 2017) Statistics and Business Analytics(Stanford Online & IIT Roorkee), Data Science from John Hopkins University(online Coursera), Java & JSP, Javascript , many more ... Developed many Software ranging from Networked based Software to ERP to School Administration Software to Online Quiz  and online Exam Managemen...