Answer Posted / rajshri

import java.sql.*;

class columncount
{
public static void main(String[]args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection
("jdbc:odbc:mydsnname");
Statement st=con.createStatement();
String sql="select * from table_name";

ResultSet rs=st.executeQuery(sql);
ResultSetMetaData rd=rs.getMetaData();
int k=rd.getColumnCount();
System.out.println("no of count is " +k);
}
catch(SQLException e1)
{
System.out.println("not working");
}

Which Java and java.sql data types map to my specific database types?

1120

---

What are 4 drivers available in JDBC? At what situation are four of the drivers used?

1008

---

What is type 4 jdbc driver?

899

---

What is a merge field?

989

---

any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.

2354

---

Name different methods for getting streams.

1029

---

Differentiate between stored procedure and functions?

1105

---

How does jdbc work?

925

---

Why do we use jdbc statements?

1006

---

Why do we use jdbc in java?

1121

---

Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?

1170

---

What is the difference between executing, executequery, executeupdate in jdbc?

1055

---

Why do we need jdbc driver?

939

---

How to connect html page to database using jdbc?

928

---

What is the advantage of namedparameterjdbctemplate?

1006

---