Jdbc Jdbc Mysql InsertValues

Sir can we know the exact code of
Inserting a record on Employees Table?

Thank you

Posted by rey on Wednesday, 12.19.07 @ 13:31pm | #42940

This is my script exactly how you done it but i've got one error:"The statement SQL isn't executed General error";WHY?
import java.sql.*;
class JDBCex
{

public static void main(String[] args)
{
System.out.println("Inserting values in MS Access database table!");

Connection conn = null;


String url = "jdbc:odbc:formular";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";

try
{
Class.forName(driver);
conn = DriverManager.getConnection(url,"","");

try
{
Statement stmt = conn.createStatement();
int val = stmt.executeUpdate("INSERT INTO angajati VALUES("+13+","+"'ion'"+","+"'ion'"+","+"'ion'"+" )");
System.out.println("1 row affected");
}

catch(SQLException e)
{
System.out.println("SQL Statement isn't executed " + e.getMessage());
}
}
catch(Exception e)
{
e.printStackTrace();
}



}
}

Posted by ion on Tuesday, 07.31.07 @ 15:19pm | #22302

Hi
In this example some mistake is there in sql command

Insert into tablename values() but it is Insert tablename values()..
so please correct it.

with regrds,
pavan kumar chelluri

Posted by pavan kumar chelluri on Sunday, 07.8.07 @ 10:52am | #20907