Total members 11895 |It is currently Thu Dec 12, 2024 3:15 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





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




Author:

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 pagethrows 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= (ResultSetstatement.executeQuery(sql);
                 
                    
ResultSetMetaData myMetaData =(ResultSetMetaDatamyresult.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= (ResultSetstatement.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;
    }
 


_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 2 posts ] 

  Related Posts  to : Connect to database Microsoft access within jsp servlet
 Simple Movie Database in C# using Microsoft Access     -  
 servlet connectivity with ms access     -  
 HOW CONNECT WEB DEVELOPER 2008 TO MS ACCESS     -  
 How to connect database with Applets     -  
 Unable to connect to JavaDB Database     -  
 How do I connect my form tomy database     -  
 How do I connect my form tomy database     -  
 How to connect two computers and connect them with Internet?     -  
 101 Example From Microsoft     -  
 jsp and servlet     -  



cron





Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com