Thursday, October 25, 2012

Code used in video "Java prog#2 . Connect Sqlite or MySQL database to Netbeans IDE"

Here I am providing the downloadable code link of  the java code I have used in the video
 "Java prog#2 . Connect Sqlite or MySQL database to Netbeans IDE"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK


import java.sql.*;
import javax.swing.*;
public class javaconnect {
     Connection conn= null;
    public static Connection ConnecrDb(){
 
    try{
    Class.forName("org.sqlite.JDBC");
     Connection conn =DriverManager.getConnection("jdbc:sqlite:project123.sqlite");
    //JOptionPane.showMessageDialog(null, "Connection Established");
    return conn;
       }catch (Exception e){
           JOptionPane.showMessageDialog(null, e);
       return null;
     
       }
 
    }
}

Java prog#1. Create netbeans project and download SQLite Manager from firefox (web browser)




SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source
code for SQLite is in the public domain


Java prog#2 . Database Connection (Sqlite or MySQL ) to Java 

.


java netbeans and MySQL or SQLite  connecting to database
Connecting to a MySQL Database in Java
connecting to a database with java code
Database Programming with JDBC and Java
Trying to connect to mysql database via JDBC
Connect to MySQL database from Java
What is Jdbc and how you connect Java with database

6 comments:

  1. As conn, pst is used in javaconnect class.... So, it is not showing correct in Saving JFrame.... So, can u tell me how to do that?

    ReplyDelete
  2. Really Nice Information,Thank You Very Much For Sharing.
    Web Designing Company

    ReplyDelete
  3. Hello,
    I have these errors.Please help me to fix those

    conn =javaconnect.ConnecrDb();


    pst=conn.preparestatement(sql);

    ReplyDelete
  4. Hey i'm Ajeb i appreciate all you video. It is very useful ......but i have question on how to rank students mark by using java code.

    ReplyDelete
  5. i want to create a jar file for mysql database and i see your videos that you work with sqlite but my application doesnt work in that way can you help me

    ReplyDelete