Statement, PrepareStatement and Callable all these are
interfaces. Thought it is a interface how come we are
creating objects and calling methods("preparestatement()")
in it. In which class this method is defined.
Please let me know. Thanks in advance.
example:
PreparedStatement pre = con.prepareStatement(
"UPDATE COFFEES SET SALES = ? WHERE COF_NAME LIKE ?");
dear friends
I have made connection with SQLSERVER where the following
code is compiling properly but giving error at the runtime .
I think error in this line where i am sending the value
through string
Connection connection = DriverManager.getConnection
( "jdbc:microsoft:sqlserver://localhost:1433","sa","");
import java.sql.*;
//import mssqlserver.*;
public class TestSQLCON
{
public TestSQLCON() throws Exception
{
// Get connection
DriverManager.registerDriver(new
com.microsoft.jdbc.sqlserver.SQLServerDriver());
System.out.println();
System.out.println("Successfully connected one");
System.out.println();
Connection connection = DriverManager.getConnection
( "jdbc:microsoft:sqlserver://localhost:1433","sa","");
if (connection != null)
{
System.out.println();
System.out.println("Successfully connected");
System.out.println();
// Meta data
DatabaseMetaData meta = connection.getMetaData();
System.out.println("\nDriver Information");
System.out.println("Driver Name: " +
meta.getDriverName());
System.out.println("Driver Version: " +
meta.getDriverVersion());
System.out.println("\nDatabase Information ");
System.out.println("Database Name: " +
meta.getDatabaseProductName());
System.out.println("Database Version: "+
meta.getDatabaseProductVersion());
}
}
public static void main (String args[]) throws Exception
{
TestSQLCON test = new TestSQLCON();
}
}
so please help me
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
