Hi,

You not mention ur requirement properly mean insert or update or select or what?

I gave a sample program you have to modify as per ur field.

package rajanikant.code.oct_2008;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class MySqlTest {

private Connection con = null;
private Statement stmt;
private PreparedStatement pst;

private ResultSet rs ;

public void getConnection(){
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/databasename";, "root", "");
} catch (ClassNotFoundException e) {
System.out.println("Driver Class Not Found");
} catch (SQLException e) {
System.out.println("Connection Error");
}
}

public void myStuff(){
getConnection();

try {
stmt = con.createStatement();
rs = stmt.executeQuery(" Your Query");

pst = con.prepareStatement("Insert Into your-tablename values(?,?,?,?)" );
//depend upon "?" we have to write the following line
pst.setString(1, "value1");
pst.setString(2, "value2");
pst.setString(3, "value3");
pst.setInt(4, 6);
rs = pst.executeQuery();
} catch (SQLException e) {

}
}

public static void main(String s[]){
new MySqlTest().myStuff();
}
}


Rajanikant

Hi,


I am sending a link. This link will help you.

Please visit for more information.

http://www.roseindia.net/jdbc/


Thanks.

Amardeep