navigating to database using java

josy

hai
i like to get code for making adding deleting navigating to database using javaide

DrRakha

Code:

import java.sql.*;

public Connection openConnection() {
  Properties properties = new Properties();
  properties.put("user", ...);
  properties.put("password", ...);
  properties.put("characterEncoding", "ISO-8859-1");
  properties.put("useUnicode", "true");
  String url = "jdbc:mysql://hostname/database";

  Class.forName("com.mysql.jdbc.Driver").newInstance();
  Connection c = DriverManager.getConnection(url, properties);
  return c;
}
 

To create connection and statement :

Code:

Connection c = createConnection();
Statement st = c.createStatement();

To run SQL

Code:

int id = 1; //Any value
String sql = "SELECT Name FROM students WHERE Id = " + id;
ResultSet rs = st.executeQuery(sql);
 

to show results

Code:

ResultSet rs = st.getResultSet();
try {
  while (rs.next()) {
    int id = rs.getInt(1);
    String userName = rs.getString(2);
    String firstName = rs.getString(3);
    String surname = rs.getString(4);
    Timestamp timeReg = rs.getTimestamp(5);
     
  }
} finally {
  rs.close();
}

for net-beans

Code:

http://netbeans.org/kb/docs/ide/java-db.html

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka

navigating to database using java