Java Netbeans Database Connectivity

Hello Friends,
This Video is a tutorial which will assist you to connect Java Netbeans with MySQL and Access....for the database connectivity.......
To download MySQL /J Connector.tar.......
http://dev.mysql.com/downloads/connector/j/
Syntax:
.........................................
Coding at the top of Source window :-
import java.sql.*;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
Coding for the JButton :-
DefaultTableModel model=(DefaultTableModel)p1.getModel();
try{
Class.forName("java.sql.Driver");
Connection conn=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/menagerie","root","sql");
Statement st=conn.createStatement();
String query="Select * from dept;";
ResultSet rs=st.executeQuery(query);
while(rs.next()){
String d1=rs.getString("deptno");
String d2=rs.getString("dname");
String d3=rs.getString("loc");
model.addRow(new Object[]{d1,d2,d3});
}
rs.close();
st.close();
conn.close();
}
catch(Exception e){
JOptionPane.showMessageDialog(this,e.getMessage());

}
............
Enjoy Connectivity!
For Connection with MS ACCESS ,please refer : http://www.youtube.com/watch?v=KSNILN43UXc
For more information ,mail me at "[email protected]"
or you can visit "http://parmindersinghclub.tk/" ..........
Also join Netbeans community on Facebook
http://www.facebook.com/pages/Netbeans/157752054294728