Create a connection to MS Access database

import java.sql.Connection;
import java.sql.DriverManager;

public class Main {
  // private static final String URL = "jdbc:odbc:TestDB";

  private static final String USERNAME = "admin";

  private static final String PASSWORD = "welcome";

  private static final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";

  private static final String URL
 = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Database\\testdb.mdb;}";

  public static void main(String[] args) throws Exception {

    Class.forName(DRIVER);
    Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);

    connection.close();
  }
}

By: Unknown On 4:40 AM

Continue Reading

Missing Media in Blogger - Boo!

When someone leaves the University of York, their account is suspended which has the knock on effect that in Blogger your blog posts are written by "Unknown".  You can still see the blog posts.

Worse than that, all the media uploaded by that person also disappears. See this post here.

I'm looking into the Blogger API to see if I can at least find a user's posts and re-create them as someone else as an awful workaround.

I've added an Issue to the Blogger forum.... tumbleweed ... and nobody is interested.

This all comes about because Blogger isn't a "Core App" of Google Apps but it's rubbish. Boo Google!  At least let us be able to transfer ownership of blog posts or something. People regularly come and go at a University and hobbling their blog posts seems ridiculous. This may force us to have to think about using Wordpress ... which will be a shame.

By: Unknown On 6:24 AM

Continue Reading

Code used in video "Java prog#45.Take value from JTable and set it to jDatechooser in Netbeans Java and Sqlite (mysql)"

Here I am providing the downloadable code link of  the Java code I have used in the video

 "Java prog#45.Take value from JTable and set it to jDatechooser in Netbeans Java and Sqlite (mysql)"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below

Date add3=rs.getDate("Update_date");
    cmd_date.setDate(add3);

Or if the above code don't work the use the below code 

String add12=rs.getString("Date_Of_Birth");
    ((JTextField)txt_dob.getDateEditor().getUiComponent()).setText(add12);

-------------------------------------------------------------

Java prog#45.Take value from JTable and set it to jDatechooser in Netbeans Java and Sqlite (mysql)

How can I make a JTable cell do different things on single-click
netbeans java tutorial
Values to be displayed in JTextfield when Clicked on JTable Cells.
Click on JTable Model Updates JTextfield
how can i get value from JTable and set it to textfield.
Show data from JTable in Jtextfield

By: Unknown On 8:19 AM

Continue Reading