Set Float and Double in PreparedStatement

From Java Example Source Code

Jump to: navigation, search

Contents

[edit] Overview - Set Float and Double in PreparedStatement

This Java example program how to set Float and Double in PreparedStatement.

[edit] Java Source Code

  • Package: example.jdbc.preparedstatement
  • File: DemoPreparedStatementSetFloatAndDouble.java 
package example.jdbc.preparedstatement;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
 
public class DemoPreparedStatementSetFloatAndDouble {
    public static Connection getConnection() throws Exception {
	String driver = "org.gjt.mm.mysql.Driver";
	String url = "jdbc:mysql://localhost/databaseName";
	String username = "root";
	String password = "root";
	Class.forName(driver);
	Connection conn = DriverManager.getConnection(url, username, password);
	return conn;
    }
 
    public static void main(String[] args) throws Exception {
	String id = "0001";
	float floatValue = 0001f;
	double doubleValue = 1.0001d;
	Connection conn = null;
	PreparedStatement pstmt = null;
	try {
	    conn = getConnection();
	    String query = "insert into double_table(id, float_column, double_column) values(?, ?, ?)";
	    pstmt = conn.prepareStatement(query);
	    pstmt.setString(1, id);
	    pstmt.setFloat(2, floatValue);
	    pstmt.setDouble(3, doubleValue);
	    // execute query, and return number of rows created
	    int rowCount = pstmt.executeUpdate();
	    System.out.println("rowCount=" + rowCount);
	} finally {
	    pstmt.close();
	    conn.close();
	}
    }
}

[edit] What Result You Can Get

Coming soon...

[edit] Required External Libraries and/or Files for this Java Example

In order to run this Java example, one of the following libraries may be required: In order to run this example program, one of the following libraries may be required:


[edit] How to Run this Java Example Program

We recommend running this Java example program with Eclipse.

For assistance in working with Eclipse, please see How to Run Java Program with Eclipse.

It's fairly easy.



[edit] Question & Answer

Any question?

Click edit and post your question or answer here.

Retrieved from "http://java.exampleshow.com/sourcecode/Set_Float_and_Double_in_PreparedStatement"
Personal tools