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");
}

What does jdbc do?

968

---

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

1046

---

Can I use JDBC to execute non-standard features that my DBMS provides?

943

---

What is @entity in java?

909

---

Which database is used for java?

914

---

Where is mysql jdbc driver located?

977

---

What is jdbc resultsetmetadata interface?

920

---

How to make updates to updatable result sets in jdbc?

857

---

Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?

920

---

Explain the two tier and three tier architecture of jdbc.

854

---

What is the difference between jdbc and odbc?

943

---

How do I know which jdbc driver to use?

964

---

How do I receive a ResultSet from a stored procedure?

930

---

What is jdbc url for mysql?

991

---

What do you mean by odbc?

966

---