Set Data Types by using Prepared Statement
In this section we are going to learn the method for setting data
types (String, int, float and double) in the PreparedStatement
interface of java.sql package. We know that the data types of MySQL
and java programming language are not same but we need some mechanism for transferring
the data to each other Java and MySQL. Mapping between both java
and MySQL provides the facility for supporting each data
types like:
Java data type MySQL
data type
int
integer (INTEGER)
double
double, float (DOUBLE, FLOAT)
float
real (REAL)
Description of program:
Here, we are going to set some java data types by
using the PreparedStatement with the help of this program. The
program first of all establishes the connection with MySQL database
through the JDBC driver. After establishing a connection the prepareStatement takes SQL query statement and
then returns the PreparedStatement
object. Now, we will set all data types like String, int, double and float
by using some methods like: setString, setInt, setDouble
and setFloat method. These methods set the data in the database table (student)
individually according to it's nature that is supported by both java and MySQL.
Data is then added in the database table (student) that can be seen in a message
as "row(s) affected" otherwise a display phrase as "SQL statement is not executed!".
Here is the code of program:
import java.sql.*;
public class SetDataTypes{
public static void main(String[] args) {
System.out.println("Set string,ingeger,double
and float example by using the Prepared Statement!");
Connection con = null;
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql:
//localhost:3306/jdbctutorial","root","root");
try{
String sql = "INSERT student VALUES(?,?,?,?)";
PreparedStatement prest = con.prepareStatement(sql);
prest.setString(1,"deepak");
prest.setInt(2,95);
prest.setDouble(3,32.50);
prest.setFloat(4,41.52f);
int row = prest.executeUpdate();
System.out.println(row + " row(s) affected)");
}
catch (SQLException s){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}
|
Download this example.
Database Table: student
| Stu_name |
Stu_marks |
Stu_ave |
Stu_total |
| raju |
(NULL) |
(NULL) |
(NULL) |
| virendra |
86 |
35.255 |
56.05 |
| deepak |
95 |
32.5 |
41.52 |
Output of program:
C:\vinod\jdbc\jdbc\PreparedStatement>javac SetDataTypes.java
C:\vinod\jdbc\jdbc\PreparedStatement>java SetDataTypes
Set string,ingeger,double and float example by using the Prepared Statement!
1 row(s) affected) |
After executing the program:
Database Table: student
| Stu_name |
Stu_marks |
Stu_ave |
Stu_total |
| raju |
(NULL) |
(NULL) |
(NULL) |
| virendra |
86 |
35.255 |
56.05 |
| deepak |
95 |
32.5 |
41.52 |
| vinod |
86 |
47.52 |
65.025 |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
