Connect to database Microsoft access within jsp servlet

jeevan

how to insert date in ms-access using jsp/servlet ?

DrRakha

java/need-help-in-jdbc-with-mysql-t3193.html

you deal with it such as any JDBC connection . Create a Bean such as the following and call it in your JSP page.

Code:

 

package FilmSearch;
 
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.http.HttpServletResponse;


/*
 * FilmSearch.java
 *
 * Created on February 1, 2007, 1:05 AM
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

/**
 *
 * @author Mohamed Eldib
 */
public class FilmSearch {
    
    /** Creates a new instance of FilmSearch */
    String Filmname;
 
    private final int limit=25;

    public String getFilmname() {
        return Filmname;
    }
     

    public void setFilmname(String Filmname) {
        this.Filmname = Filmname;
    }
    public String DoFilmSearch(String page) throws IOException
    {
         
      String returnTable = "";
      
     if(page==null)page="1";
      int mypage=Integer.parseInt(page);
      int myBase=(limit*mypage)-limit;
      int myLimit=(limit);        
        boolean flag=false;
         try{
            try {
                Class.forName("org.gjt.mm.mysql.Driver");
            } catch (ClassNotFoundException ex) {
                ex.printStackTrace();
            }
         Connection connection =
                    DriverManager.getConnection("jdbc:mysql://localhost/subarabia?user=root&password=11991199");
                          
                    Statement statement = connection.createStatement();
                    
                    String sql="Select Films.FILM_ID,FILM_NAME As 'Film name' ,COUNT(TRGMA_ID)As 'Subtitles' ,FILM_YEAR" +
                            "  from Films Left join Trgma on(Films.FILM_ID=Trgma.FILM_ID) where FILM_NAME like('%"+Filmname+"%')" +
                            " group by FILM_NAME,FILM_YEAR order by 'Film name' ,Subtitles limit "+myBase+","+myLimit+ ";";
                    ResultSet myresult= (ResultSet) statement.executeQuery(sql);
                 
                    ResultSetMetaData myMetaData =(ResultSetMetaData) myresult.getMetaData();
                    int size=myMetaData.getColumnCount();   

                     
                    returnTable= "<table   >";
                   returnTable+="<tr >";
                    for(int i=2;i<=size-1;i++)
                    {
                    returnTable+="<th>"+myMetaData.getColumnName(i)+"</th>";   
                    }
                    returnTable+="</tr>";
                    
                while(myresult.next())
                {
                   returnTable+="<tr>";
                     
                     flag=true;
                       returnTable+="<td><a href=FilmTrgma.jsp?FILM_ID="+myresult.getString(1)+">"+myresult.getString(2)+"</a> ("+myresult.getString(4)+")"+"</td>";
                       returnTable+="<td>"+myresult.getString(3)+"</td>";
                     
                
                   returnTable+="</tr>";
                }
                   if(!flag)
                       returnTable+="<tr><td colspan=2> No results found </td></tr>";
                        
                        sql="Select COUNT(FILM_ID) from Films  where FILM_NAME like('%"+Filmname+"%')";
                        myresult= (ResultSet) statement.executeQuery(sql);
                        myresult.next();
                        returnTable+="<tr><td colspan=2>Page: "; 
                        int count=myresult.getInt(1);
                        int i=0;
                        while(count>0)
                        {
                            i++;
                            if(i!=Integer.parseInt(page))
                            returnTable+="<a href=FilmSearchResult.jsp?page="+i+"&&Filmname="+Filmname+">"+i+"</a>|";
                            else 
                            returnTable+="<u>"+i+"</u>|";    
                            count-=limit;
                        }
                    returnTable+="</table> ";     
                   connection.close();
                   statement.close();
         
              } 
        
       catch (SQLException ex) {
            ex.printStackTrace();
        }
  
     return returnTable;
 
            
    }
}

 

For Microsoft access :

Code:

    public static Connection connect() {

        Connection con;
        try {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=mydatabase.mdb;";
            con = DriverManager.getConnection(database, "username", "password");

        } catch (Exception ex) {
            return null;
        }
        return con;
    }
 

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka

Connect to database Microsoft access within jsp servlet