connectivity in jsp

[kashyap upadhyay]

hi guys!!
i am new in the java
i had facing one problem
can you teach me a connectivity in database using java server pages technology
thanks :
can you give me connectivity code?
please..reply..

[Shinelin Samuel]

What is your Database, you have to use the JDBC driver for thr database you are using. Here is the code snippet for JDBC connection for MYSQL database,

Class.forName("com.mysql.jdbc.Driver").newInstance();
String url = "jdbc:mysql://localhost/coffeebreak";
conn = DriverManager.getConnection(url, "username", "password");
String query = "SELECT * FROM STUDENT";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
      while (rs.next())
      {
        String n = rs.getString("NAME");
        System.out.println("Name:   " + n);
      }
    }
    catch (SQLException ex)
    {
      Systemerr.println(ex.getMessage());
    }

conn.close();

Go google my friend

[Bear Bibeault]

Database access should have nothing to do with JSP and vice versa. DB access should occur in the Model layer of a properly structured MVC application.

Moved to the JDBC forum.

[Paul Sturrock]

Shinelin Samuel wrote:
What is your Database, you have to use the JDBC driver for thr database you are using. Here is the code snippet for JDBC connection for MYSQL database,

Class.forName("com.mysql.jdbc.Driver").newInstance();
String url = "jdbc:mysql://localhost/coffeebreak";
conn = DriverManager.getConnection(url, "username", "password");
String query = "SELECT * FROM STUDENT";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
      while (rs.next())
      {
        String n = rs.getString("NAME");
        System.out.println("Name:   " + n);
      }
    }
    catch (SQLException ex)
    {
      Systemerr.println(ex.getMessage());
    }

conn.close();

Go google my friend

... though if you are using a Servlet container (as you must be if you are using JSPs) you might prefer using a DataSource. (Not sure what that is? Have a read through this)

[him jain]

I am using windows and running Tomcat 6.0.24.
Is there any need to add any db etc in odbc?
I am trying to connect a servlet to database.
Please anyone tell me the configuration to be done..

[Peter Johnson]

Him, what database? You do not need to set up anything in ODBC. You should get the JDBC driver for your database and use that.