Hi,

I am trying below database table insert example to MySql database.

import java.sql.Connection;
import java.sql.DriverManager;
//import java.sql.PreparedStatement;
import java.sql.SQLException;

//import com.mysql.PreparedStatement;

import com.mysql.jdbc.PreparedStatement;


public class DBConnect {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
try {
	Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/MySql","root","root");

String queryy="insert into xyz_table values(?,?,?)";
System.out.println("queryy is"+queryy);
	
	PreparedStatement psmt=(PreparedStatement) conn.prepareStatement(queryy);
	//psmt.setp
	psmt.setPersonid(1,111);
	psmt.setfirstname(2,"sss");
	psmt.setage(3,333);
	psmt.executeUpdate();
	
	
} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}
	}
	

}

Select allOpen in new window

I am able to ping database successflly and able to see created table results successfully. When I try to insert from java program getting errorss as below after commenting below lines
      psmt.setPersonid(1,111);
      psmt.setfirstname(2,"sss");
      psmt.setage(3,333);

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/MySql
      at java.sql.DriverManager.getConnection(Unknown Source)
      at java.sql.DriverManager.getConnection(Unknown Source)
      at DBConnect.main(DBConnect.java:19)

I do have mysql jdbc jar in the build path.

i also see when i comment below lines
      psmt.setPersonid(1,111);
      psmt.setfirstname(2,"sss");
      psmt.setage(3,333);

getting errors

The method setPersonid(int, int) is undefined for the type PreparedStatement

I also see messages like add cast to psmt etc.

I see two import options for PreparedStatement one from SQL other from SQL.jdbc package. what are the difference between those two.
I am getting error there like

Type mismatch: cannot convert from java.sql.PreparedStatement to com.mysql.jdbc.PreparedStatement


 Which one should i select.
Please advise. Any ideas, resources, sample code highly appreciated. thanks in advance

i modified the code as below

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
//import java.sql.PreparedStatement;
import java.sql.SQLException;

//import com.mysql.PreparedStatement;

//import com.sql.PreparedStatement;


public class DBConnect {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
try {
	Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/MySql","root","root");

String queryy="insert into xyz_table values(?,?,?)";
System.out.println("queryy is"+queryy);
	
	PreparedStatement psmt=conn.prepareStatement(queryy);
			//psmt.setp
	//psmt.setPersonid(1,111);
	psmt.setInt(1,111);
	psmt.setString(2,"sss");
	//psmt.setfirstname(2,"sss");
	psmt.setDouble(3,333);
	//psmt.setage(3,333);
	psmt.executeUpdate();
	
	System.out.println("connected");
	System.out.println("inserted well");
	
} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}
	}
	

}

Select allOpen in new window

i still get error as below
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/MySql
      at java.sql.DriverManager.getConnection(Unknown Source)
      at java.sql.DriverManager.getConnection(Unknown Source)
      at DBConnect.main(DBConnect.java:20)

please advise


when i tried below example
http://stackoverflow.com/questions/9353170/access-mysql-database-in-eclipse-using-java

it worked fine

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

import com.mysql.jdbc.Statement;

public class OrderData {
public static void main(String[] args)throws Exception{
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/MySql","root","root");
    Statement stmt = (Statement) con.createStatement();
//    String insert = "INSERT INTO customer(name,C_ID,address,email)      VALUES (a,5,b,c)";
    String insert = "INSERT INTO customer(name,C_ID,address,email) VALUES ('aaa',11,'bbb','ccc');";
    stmt.executeUpdate(insert);
    System.out.println("inseertd");
    
}
}

Select allOpen in new window

not sure what is the issue with earlier example i was trying which is using preparedstatement instead of statement.
strangely below example also worked fine
http://alvinalexander.com/java/java-mysql-insert-example-preparedstatement
Please advise
SELECCTTable.jpg
PING.jpg
PSMT.jpg
mysql-JAR.jpg
Undefined.jpg
Undefined2.jpg
Undefined3.jpg
psmtErorr.jpg
OrderDB.jpg
OrderDB2.jpg
users.jpg