Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How can I put ResultSet with this existing code?

Posted on 2008-10-21
3
Medium Priority
?
195 Views
Last Modified: 2012-05-05
How can I enter ResultSets while loop so that all of the records will be given the Date value.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
 
public class DemoPreparedStatementSetDate {
  public static java.sql.Date getCurrentJavaSqlDate() {
    java.util.Date today = new java.util.Date();
    return new java.sql.Date(today.getTime());
  }
 
  public static Connection getConnection() throws Exception {
 
    String url = "jdbc:mysql://localhost/datedb";
    String username = "root";
    String password = "root";
    Connection conn = DriverManager.getConnection(url, username, password);
    return conn;
  }
 
  public static void main(String[] args) throws Exception {
    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
      conn = getConnection();
      String query = "insert into datetable(id, date_column) values(?, ?)";
      pstmt = conn.prepareStatement(query);
      pstmt.setString(1, "0001");
      java.sql.Date date = getCurrentJavaSqlDate();
      pstmt.setDate(2, date);
 
      // execute query, and return number of rows created
      int rowCount = pstmt.executeUpdate();
      System.out.println("rowCount=" + rowCount);
    } finally {
      pstmt.close();
      conn.close();
    }
  }
}

Open in new window

0
Comment
Question by:glynco
  • 2
3 Comments
 
LVL 20

Expert Comment

by:chaitu chaitu
ID: 22773085

 public static void main(String[] args) throws Exception {
    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
      conn = getConnection();
      String query = "select * from datetable";
      pstmt = conn.prepareStatement(query);
  
      ResultSet rs= pstmt.executeqQuery();
      while(rs.next()
{
 system.out.println(rs.getString(1));
 system.out.println(rs.getDate(2));
}
    } finally {
      pstmt.close();
      conn.close();
    }
  }

Open in new window

0
 

Author Comment

by:glynco
ID: 22773378
I need to update records with the date not just println
0
 
LVL 20

Accepted Solution

by:
chaitu chaitu earned 2000 total points
ID: 22773565

 String query = "update datetable set date_column=? where id =?";
      pstmt = conn.prepareStatement(query);
       java.sql.Date date = getCurrentJavaSqlDate();
 
      pstmt.setDate(1, date);
      pstmt.setString(2, "0001");
 
      // execute query, and return number of rows created
      int rowCount = pstmt.executeUpdate();

Open in new window

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This video teaches viewers about errors in exception handling.
Suggested Courses

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question