Calling a stored procedure in Java : Java « Procedure Function « SQL / MySQL

SQL / MySQL
1. Backup Load
2. Command MySQL
3. Cursor
4. Data Type
5. Database
6. Date Time
7. Flow Control
8. Function
9. Insert Delete Update
10. Join
11. Key
12. Math
13. Procedure Function
14. Select Clause
15. String
16. Table Index
17. Transaction
18. Trigger
19. User Permission
20. View
21. Where Clause
Microsoft Office Word 2007 Tutorial
Java
Java Tutorial
Java Source Code / Java Documentation
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
C# / C Sharp
C# / CSharp Tutorial
ASP.Net
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
PHP
Python
SQL Server / T-SQL
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
SQL / MySQL » Procedure Function » Java 
Calling a stored procedure in Java
 
try {
   Class.forName("com.mysql.jdbc.Driver").newInstance();

   String ConnectionString="jdbc:mysql://" + hostname + "/" + database + "?user=" +
          username + "&password=" + password;
   System.out.println(ConnectionString);
   Connection conn = DriverManager.getConnection(ConnectionString);
   Statement stmt=conn.createStatement();
   stmt.execute("call error_test_proc(1)");
}
catch(SQLException SQLEx) {
   System.out.println("MySQL error: "+SQLEx.getErrorCode()+
          " SQLSTATE:" +SQLEx.getSQLState());
   System.out.println(SQLEx.getMessage());
}

        
Related examples in the same category
1. Call stored procedure in Java and get the result set
w___w_w__.__j__a_v_a___2__s_._c_om___ | Contact Us
Copyright 2003 - 08 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.