java to oracle database connection

[ludablay]

Hello everyone, i'm new here and i'm having some problem with connecting my tables in oracle and editing (update/delete) them in a java app i'm building. a short example would also help. i am using oracle 10g.
thanks.

[rahana]

import java.sql.*;

public class Stmt
{
public static void main(String args[])throws Exception
{

try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin: @localhost:1521:xe","scott","tiger");
Statement stmt=con.createStatement();
String vsql="create table testtable(cone number,ctwo number)";
stmt.executeUpdate(vsql);
System.out.println("...Success....");
con.close();
}
catch(ClassNotFoundException e)
{
System.out.println(e);
System.out.println("hello");
}

}
}
--------------------------------------------------------------------------------------------------------------------
ur url might change depending up on ur username,password.data source name etc.

u can use various statement like
String vsql=insert into Student values("+vstudno+",' "+vstudname+" ');

executeUpdate must be used for executing non select statements.
executeQuery must be used for executing select statements.
example:
Statement stmt=con.CreateStatement();
String vsql="select * from Student";
ResultSet rs=stmt.executeQuery(vsql);
while(rs.next())
{
System.out.println("current row--->"+rs.getRow())
}
con.close();
}
}

[JosAH]

@Rahana: so you managed to make a database connection? What did you change?
I can't find any difference between your non-working version and this one.

kind regards,

Jos