Search This Blog

Friday, 2 March 2012

connection to mysql database by using type4 driver

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.io.*;
import java.util.*;


public class DB{
  public static void main(String[] args)throws Exception {
System.out.println("before connection");
    //Class.forName("org.gjt.mm.mysql.Driver");
    Class.forName("com.mysql.jdbc.Driver()");
  
   Connection con= DriverManager.getConnection("jdbc:mysql://localhost:portnumber/databasename", "root", "root");
Statement st =con.createStatement();

System.out.println("after connection");
st.close();
con.close();
  }
}

No comments:

Post a Comment