JDBC CONNECTIVITY

Home Answers Viewqa JDBC JDBC CONNECTIVITY

parveen

JDBC CONNECTIVITY
1 Answer(s) 3 years and a month ago
Posted in : JDBC

String jclass="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(jclass);
String dsn= "Jdbc:Odbc:Employee";
Connection con= DriverManager.getConnection(dsn);
PreparedStatement p = con.prepareStatement("insert into detail values(?,?,?,?)");

I am a bigner in Jdbc so please tell me in brief each line code
and also tell me please that what is the method of the naming convention??
means where is character is in capital letter and where small..

What is :--
1 dsn
2 forName
3 sun.jdbc.odbc.JdbcOdbcDriver
4 DriverManager
5 getConnection(dsn)

thanks :)
Parveen Thakur

View Answers

May 26, 2010 at 11:31 AM

Hi Friend,

DriverManager-It is a class of java.sql package that controls a set of JDBC drivers. Each driver has to be register with this class.

getConnection()-This method establishes a connection to specified database url. This method takes a string containing a URL.

Class.forName()-This method is static. It attempts to load the class and returns class instance and takes string type value (driver) after that matches class with given string.

DSN-It represents an ODBC connection to a particular database server.

sun.jdbc.odbc.JdbcOdbcDriver- This is the class where Type 1 Driver is implemented.

For more information, visit the following link:

http://www.roseindia.net/jdbc/

Thanks

JDBC CONNECTIVITY
file in environment variable. Java Mysql connectivity Other JDBC...JDBC CONNECTIVITY How do i connect my database to java. I have the connector file and i place it in lib of jdk folder and installed the jdbc driver

JDBC CONNECTIVITY
connectivity Other JDBC Tutorials...JDBC CONNECTIVITY import java.sql.Connection; import..."); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/abhi

connectivity - JDBC
connectivity How can we connect sql server using Java Hi Friend, By using JDBC drivers, you can connect SQL server with java. Please visit the following link: http://www.roseindia.net/jdbc/jdbc.shtml

jdbc connectivity
jdbc connectivity import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; public class NewJFramefin extends...=e.getActionCommand(); String check; String str="jdbc:odbc:dsn1

connectivity - JDBC
driver for JDBC and set in the Tomcat/lib folder and if any more problem give full..., Please check the jar file for Connection driver for JDBC and set in the Tomcat

JDBC CONNECTIVITY - JDBC
JDBC CONNECTIVITY String jclass="sun.jdbc.odbc.JdbcOdbcDriver"; Class.forName(jclass); String dsn= "Jdbc:Odbc:Employee"; Connection con... = con.prepareStatement("insert into detail values(?,?,?,?)"); I am a bigner in Jdbc so please tell

JDBC Connectivity - JDBC
JDBC Connectivity my question is how to connect a Java program with MS-Access database? Hello Use this code import java.sql.... String filename = "d:/java/mdbTEST.mdb"; String database = "jdbc

jdbc connectivity to mysql tutorial
jdbc connectivity to mysql tutorial here is complete jdbc connectivity to mysql tutorial for newbies. Person who don't even know how to install mysql and don't know about which driver to use can do with ease

jdbc oracle connectivity problem
jdbc oracle connectivity problem Hi All, I am trying to connect my swing application to oracle DB . but class.forname is giving error. Please suggest me if there is some different way to connect swing application to oracle

Connectivity with sql in detail - JDBC
Connectivity with sql in detail Sir/Madam, I am unable to connect the sql with Java. Please tell me in detail that how to connect. Thankyou

database connectivity - JDBC
connectivity programs with MSacces Hi Friend, If you havn't create your.... For programs,visit the following links: http://www.roseindia.net/jdbc/Jdbc-odbc-connection.shtml http://www.roseindia.net/jdbc/Jdbc-odbc-connectivity.shtml Thanks

Eclipse Connectivity - JDBC
Eclipse Connectivity Hello Friends.. I want to do connectivity... connectivity..and which plugins are required for it. i have try to do connectivity but i got given below error. "Error Occured Error

Connectivity with sql in detail - JDBC
Connectivity with sql in detail Sir/Madam, I am...; String url = "jdbc:mysql://localhost:3306/"; String dbName... the following link: http://www.roseindia.net/jdbc/jdbc-mysql

mysql jdbc connectivity
mysql jdbc connectivity i want to connect retrieve data from mysql using jdbc

jdbc connectivity through jsp
jdbc connectivity through jsp my code: <%@ page language="java... = ""; String url = "jdbc:mysql://localhost/interviewer... at line 20 17: String url = "jdbc:mysql://localhost/interviewer"; 18

database connectivity - JDBC
."); Connection conn = null; String url = "jdbc:mysql://localhost:3306...(); } } } For more information on JDBC in java visit to : http://www.roseindia.net/jdbc

database connectivity in java - JDBC
database connectivity in java import java.io.*; import java.awt.*; import javax.swing.*; import java.awt.event.*; import java.sql.*; class... con1; con1=DriverManager.getConnection("jdbc:odbc:Mycon

MySQL connectivity - JDBC

code to establish jdbc database connectivity in jsp
code to establish jdbc database connectivity in jsp Dear sir, i'm in need of code and procedure to establish jdbc connectivity in jsp

regarding connectivity program only - JDBC
regarding connectivity program only can u give me code regarding..., i am sending simple code of connectivity import java.sql.*; public... = "jdbc:mysql://192.168.10.211:3306/"; String db = "amar"; String driver

Jdbc connectivity by type 4 driver
Jdbc connectivity by type 4 driver I have done a code with database connectivity with driver 4,it copiles,but while running it is showing...=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521","system","123

connectivity problem
connectivity problem i am facing error in Class.for name statement... connectivity still i am facing this error* ================================oracle connectivity program============================ import java.sql.*; import

audio files in jdbc connectivity with ms-access - JDBC
audio files in jdbc connectivity with ms-access i need to know how to retrieve audio files through jdbc connectivity with ms-access and how to play... static void main(String[] args) { try{ String url="jdbc:odbc:access"; File

regarding connectivity program only - JDBC
regarding connectivity program only can u give me code regarding .. that i had created student data base with his name and subject marks resp ... i use html in front end ...that there r options like 1.name---------- 2.sub1

JDBC-Odbc Connectivity
JDBC-ODBC Connectivity The code illustrates an example from JDBC-ODBC Connectivity. The code helps you in retrieve the name and size of the column

Java vs Oracle Connectivity - JDBC
) Load and Register the JDBC driver:*********** DriverManager.registerDriver... = DriverManager.getConnection("jdbc:oracle:oci8: @oracle.world", "root", "root"); where... = DriverManager.getConnection ("jdbc:oracle:thin:@localhost:3306:roseindia", "root", "root

connectivity step
connectivity step sir.pls give me step one by one for connect...*; import oracle.sql.*; 2) Load and Register the JDBC driver... = DriverManager.getConnection("jdbc:oracle:oci8: @oracle.world", "root", "root"); where

in connectivity - Hibernate
insertted Hi friend, This is connectivity and hibernate configuration code com.mysql.jdbc.Driver jdbc:mysql://localhost

jdbc
jdbc Hai , Give a steps for jdbc connectivity

oracle connectivity
oracle connectivity con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr"); i have error on above line when i tried...=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr

DataBase connectivity in java with Microsoft sql server2000 - JDBC
DataBase connectivity in java with Microsoft sql server2000 How i can achieve database connectivity with Microsoft sql server2000 in my java source code

database connectivity
"); con= DriverManager.getConnection("jdbc:odbc//localhost:3306/example","root... links: http://www.roseindia.net/jdbc/jdbcconnectivity.shtml http...("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql

JDBC Connectivity Code In Java
JDBC Connectivity Code In Java ... in understanding JDBC Connectivity Code in Java. In this program, the code...;url = "jdbc:mysql://localhost:3306/";

Jdbc
Jdbc A java program with jdbc connectivity with insert,delete,update options for name,regno,mark1,mark2,total

database connectivity problem
database connectivity problem what if client dont have database with them then what is other way to run successfully our programm Please visit the following link: http://www.roseindia.net/jdbc

The required JDBC drivers to establish connectivity to my database part of the JDK.
The required JDBC drivers to establish connectivity to my database part of the JDK. Are all the required JDBC drivers to establish connectivity to my database part of the JDK

JDBC - Java Database Connectivity Tutorial
JDBC - Java Database Connectivity Tutorials ...; New Features in JDBC 4.0 Java database connectivity (JDBC) is the Java... rows. JDBC Tutorials JDBC (Java Database Connectivity

Oracle Database connectivity probem
Oracle Database connectivity probem hi Below is the code of oracle database connectivity, when i compile it, it will show the error... also set the environment variable like that .;E:\oracle\ora81\jdbc\lib

JDBC, Java Database Connectivity
tutorials. Java Database Connectivity or JDBC for short is Java bases API... driver as per your application needs. About JDBC Java Database Connectivity... JDBC In this section you will find the list all the best JDBC tutorials we

Java to SQL Server Connectivity
("jdbc:odbc:BUS","",""); Statement stmt= conn.createStatement... with sql server connectivity at the background to save the data. Now, after... the connectivity wrong. Kindly help me resolve this issue ASAP. Thank you

database connectivity using mysql
database connectivity using mysql java file: eg1.java package eg; import java.sql.*; public class eg1 { public static void main(String arg[]) throws SQLException { try { String connectionURL = "jdbc:mysql

jdbc
connectivity in short Java MS Access database connectivity...("jdbc:odbc:student"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver

jdbc
that is used for database connectivity to hold the data returned by a select query... logical group of data with a number of columns. JDBC ResultSet Example Stored

Jdbc connectivity in java to oracle for retrieving data between two dates
Jdbc connectivity in java to oracle for retrieving data between two dates Dear Sir, I Need a program in which i want to retrieve the data b/w two dates from the database table. I am using combo box to get the date. Problem

Data base Connectivity
Data base Connectivity How to configure JDBC connection for Oracle data base.In configuring it is asking select Data server name and TNS.I typed Oracle for Data Server Name and IN TNS what to type? I pulled the list for TNS

JDBC
Connectivity (JDBC) API is the industry standard for database-independent... JDBC JDBC stands for Java Data Base Connectivity that defines how a client may access a database

JDBC Components
JDBC Components JDBC stands for Java Database Connectivity. For connectivity with the database we uses JDBC.... JDBC gives you the opportunity to communicate with standard database. JDBC

Java database connectivity
= DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root

Latest
Frameworks
Category