| |
| GROUP INFO |
|
Members:
19554
|
| Access Type: Anyone can join |
|
|
|
|
|
 |
|
|
| |
Connecting JSP With MS Access |
Author : sampad
Date Published : 04/9/2006
Rating : No Rating
Accessed : 10675
|
| sampad
|
|
|
|
|
<%@page import ="java.io.*"%>
<%@page import ="javax.servlet.*"%>
<%@page import ="javax.servlet.http.*"%>
<%@page import ="java.sql.*"%>
<%!
Connection conn=null;
Statement st;
ResultSet rs;
String login,password;
String pass,logg;
String sql;
String database = "e:\trashmagic\login.mdb";
String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + database + ";DriverID=22;READONLY=false";
public void jspInit()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url);
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
%>
|
|
|
|
|
| |
|
|
|
| |
| |
       
|
Click each image to add
this page to each site.
|
|
|
| |
|
|
| |
|
|
| |
| |
|
|
|
Connecting JSP with MS Access By : MaTreX_2009
31st Aug 2006 02:28 AM
This code Describe how to ConnectJSP with MS Access.
//***************************
public class DBConnection {
private Connection connection;
private Statement statement;
public DBConnection() throws Exception
{
String dataSourceName = "FACULTYDB";
String dbURL = "jdbc:odbc:" + dataSourceName;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection= DriverManager.getConnection(dbURL,"","");
statement = connection.createStatement();
}
//***************************
This code Describe how to ConnectJSP with MySql DataBase
//***************************
public class DBConnection {
private Connection connection;
private Statement statement;
public DBConnection() throws Exception{
//String dataSourceName = "DBName";
String dbURL = "jdbc:mysql://localhost:3306/DBName";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
connection= DriverManager.getConnection(dbURL,"Username","Password");
statement = connection.createStatement();
}
//***************************
|
|
|
| |
| |
|
|
|
|
|
|
| |
| |
|
|
Total Members
