Interested to Buy Any Domain ? << Click Here >> for more details...
How the information about db(database) can be retrieved?
- 3 Answers
- 5689 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / indrani
using databasemetadata,we can get the data related to
database
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sushant
Database=MySQLdb.connect(db = Database, user =
DatabaseUser, passwd =
DatabasePassword, host = localhost)
DatabaseCursor = Database.cursor()
DatabaseCursor.execute("SELECT * FROM table1 ORDER BY
field1")
RecordData = DatabaseCursor.fetchone()
| Is This Answer Correct ? | 0 Yes | 0 No |
Without using of Class.forName(? ?), how do you connect to db?
What is odbc and jdbc in dbms?
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
What is the purpose of jdbc resultset interface?
What is execute(), executeUpdate() and executeQuery() methods?
Why we use jdbc instead of odbc?
What are the steps to connect to the database in java?
Why are we using blob datatypes in jdbc?
How many locking systems are there in jdbc?
Which type of JDBC driver is the fastest one?
When does the result for an sql statement return null?
What is executequery in java?
Core Java 
