Guest User

Untitled

a guest
Mar 13th, 2018
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. CREATE DEFINER=`root`@`localhost` PROCEDURE `instert_student`(IN rollno int(12), IN stdname varchar(45), IN age int(2))
  2. BEGIN
  3. insert into student values(rollno,stdname,age);
  4. END
  5.  
  6. package Call_Ststement;
  7. import java.sql.*;
  8. public class Callable {
  9. public static void main(String[] args) throws Exception{
  10. Class.forName("com.mysql.jdbc.Driver");
  11. Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/Milan","root","naruto");
  12. CallableStatement stmt=con.prepareCall("{insert_student(?,?,?)}");
  13. stmt.setInt(1,6);
  14. stmt.setString(2,"Milan");
  15. stmt.setInt(3,19);
  16. stmt.execute();
  17. System.out.println("data base updated");
  18. }
  19. }
  20.  
  21. Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{insert_student(6,'kanji',19)}' at line 1
  22. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  23. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  24. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  25. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  26. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  27. at com.mysql.jdbc.Util.getInstance(Util.java:408)
  28. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
  29. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  30. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  31. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  32. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  33. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
  34. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
  35. at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)
  36. at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:837)
  37. at Call_Ststement.Callable.main(Callable.java:11)
Add Comment
Please, Sign In to add comment