Tech-Today

How to connect MSAccess Database from Java using JDBC Driver

The method is almost similar to my previous code, and like that it's better to explain it by code:

private static Connection getConnection() {
 String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
    String url = "jdbc:odbc:anime"; //anime is the database
    String username = "ipieluser"; //leave blank if none
    String password = "ipielpassword"; //leave blank if none
    try {
  Class.forName(driver);
 } catch (ClassNotFoundException e) {
  e.printStackTrace();
 }
    try {
  return DriverManager.getConnection(url, username, password);
 } catch (SQLException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
 }
 return null;
}

How to call:

public static void main(String args[]) {
 try {
  Connection conn = getConnection();
     Statement st = conn.createStatement();
     st = conn.createStatement();
     ResultSet rs = st.executeQuery("SELECT * FROM localTable");     
     
  //get and displays the number of columns
     ResultSetMetaData rsMetaData = rs.getMetaData();
  int numberOfColumns = rsMetaData.getColumnCount();
     System.out.println("resultSet MetaData column Count=" + numberOfColumns);
 
     st.close();
     conn.close();
 } catch(Exception e) {
  System.out.println(e.getMessage());
 }
}

- How To Send And Receive Stomp Message In Jboss 7.2
The following code is an example of how we can send and receive a stomp message with JBoss 7.2. package org.meveo.util; import java.io.InputStream; import java.io.OutputStream; import java.net.Socket; import java.util.Properties; import javax.naming.InitialContext;...

- Connect To Oracle Database In Java Language
This code connects to an oracle database using java programming language. This to remember: 1.) You must add ojdbc14.jar to the project's build path. 2.) Oracle's driver name: oracle.jdbc.driver.OracleDriver 3.) Connection string: jdbc:oracle:client:@server:port:database...

- How To Get Started With Hibernate In Java. Create A Simple Class And Database Schema For Demostration.
Since, I've always been using different database sometimes I get confused how to implement the others. Like hibernate, where the configuration must be properly set. *This help assumes that you have already created a java project in eclipse that has...

- How To Create And Call A Database Routine (stored Procedure/function) Using A Jdbc Driver In Java
How to create and call a database routine (stored procedure/function) using a jdbc driver in java Stored procedure/function is a routine that is defined and executed in the database itself. Minimizing the time of execution, since the code is already residing/compiled...

- Sqlce Get Last Insert Id, Convert Sqldecimal To Int32
Platform: Windows Mobile, SqlCE2.0 Problem: You want to get the id of the last query you insert. Solution: Using the @@identity you have to execute your queries like this: SqlCeConnection conn = null; try { conn = new SqlCeConnection(GetConnection());...

Tech-Today