Online Hibernate Training just in Rs. 1000

One week online training in Hibernate ORM framework. Learn Hibernate Framework and enhance your skills. Best Online Hibernate training at 90% discount. Join Now!! Offer is valid Only for limited Period!!! Online Training Big Data and Hadoop Training Java Training  
 

mysq and java

Ads

 
 

Share on Google+Share on Google+

Vikram
mysq and java
1 Answer(s)      7 years ago
Posted in : JDBC
Ads
View Answers

September 22, 2009 at 3:57 PM


Hi Friend,

We have created a procedure 'procedures' in the database.

import java.sql.*;

public class Main {
public static void main(String[] args) {
try{
Connection conn = getMySqlConnection();
int i=4;
int j=7;
CallableStatement proc = conn.prepareCall("{ call procedures(?, ?) }");
proc.setInt(1, i);
proc.setInt(2, j);
proc.execute();
}
catch(Exception e){
System.out.println(e);
}
}
public static Connection getMySqlConnection() throws Exception {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/register";;
String username = "root";
String password = "root";

Connection conn = DriverManager.getConnection(url, username, password);
return conn;
}
}

Hope that it will be helpful for you.
Thanks

Ads









Related Tutorials/Questions & Answers:
mysq and java - JDBC
mysq and java  Hello Sir/Madam i want to catch message in java (from JDBC)which is generated in mysql- stored procedure. how is it possible????  Hi Friend, We have created a procedure 'procedures' in the database
Video Tutorial: How to update data in the MySQ?
How to update data in the MySQ? It is necessary to keep a real-time data... in MySQL from a java program Update: Name Deepak If you have a simple... java project, name it and click finish Right click the new java project
Advertisements
java
java  diff bt core java and java
java
java  what is java
java
java  explain technologies are used in java now days and structure java
java
java  different between java & core java
JAVA
JAVA  how the name came for java language as "JAVA
java
java   why iterator in java if we for loop
Java
Java   Whether Java is pure object oriented Language
java
java  is java open source
java
java  what is java reflection
java
java   in java does not pointers concept but what is nullpointers in java?   nullpointer is a runtime Exception
java
what is the size of array in java ?  what is the size of array in java ? what is the mean of finalize in java
java
java   What is ?static? keyword
java
java  RARP implementation using java socket
java
java  sample code for RARP using java
java
java  Does java allows multiline comments
Java
Java  how to do java in command prompt
java
java  give a simple example for inheritance in java
java
java  give a simple example for inheritance in java
java
java  why to set classpath in java
java
java  why to set classpath in java
java
java  why to set classpath in java
java
java  why to set classpath in java
java
java  Write a java code to print "ABABBABCABABBA
java
java  write a program in java to acess the email
java
java  send me java interview questions
java
java  how use java method
java
java  what are JAVA applications development tools
Java
Java   Whether Java is Programming Language or it is SOftware
java
java  is java purely object oriented language