How to get a system date and store it in a variable?

[Yuta Lolap]

Hey all,
I am new to using the Date Class. Please can you guys help me out!

How to get a system date and store it in a variable of type date because i need to pass this into a query later on? Since i have to use it to fill a column called DateOfPurchase of type Date.

[William P O'Sullivan]

import java.util.Calendar;
...
Calendar now = Calendar.getInstance();

now will contain exactly the system time, and allow you to do some cool things with it,
including converting to the older java.util.Date.

WP

[Yuta Lolap]

Thanks! I used the following code:

	java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());
	    System.out.println(sqlDate);

Now i have a column DOP right, so what if i wanna see all the items in month 'OCT'? How do i write the code for it?


Also, how do i do it in the above Calendar case with the object "now"?

[Campbell Ritchie]

Why are you using an SQL date rather than java.util.Date? Or better still, something from Yoda time or simliar?

[Yuta Lolap]

I used your code and converted it to Util Date i guess this is how it is:

Calendar now = Calendar.getInstance(); 
	
	Date date1=	now.getTime();
		System.out.println("utl date:"+date1);
	//    System.out.println(now.getTime());

Is this conversion right? If not please do let me know. Can you help me with the month code? I need to see all the data for the month of OCT.

[William P O'Sullivan]

That's better.

If you look up the Calendar API, you will see that it has a wealth of methods to help you out.

If all you want to show in your column are activities in October, this is very easy to do using Calendar.

WP

[Yuta Lolap]

Got it! Thanks!

[Yuta Lolap]

i want to say

 ptmt.setDate(6,date1);

Gives me an error says that i need to put it the following way

ptmt2.setDate(6,  (java.sql.Date) date1); 

//have to give an sql cast to date1 thats wat it says

[Yuta Lolap]

wheni want util Date why is it saying i shud use the sql Date?

[Campbell Ritchie]

Why is it saying you need an SQL Date? Are you inserting those values into a database? If so, you do need an SQL Date, but why didn’t you say so earlier?

[Yuta Lolap]

yes i am inserting into a db...
I am using the following code it works perfectly.

	java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());
    System.out.println(sqlDate);

Also i have another issue...
I am using a Jtable... I have a db table purchases as follows:

SQL> desc purchases;
Name Null? Type
----------------------------------------- -------- ----------------------------
CUSTOMER_ID VARCHAR2(10)
ITEMID VARCHAR2(10)
ITEMNAME VARCHAR2(20)
ITEMPRICE NUMBER(10)
ITEMQUAN NUMBER(10)
DATEOFPURCHASE DATE

While viewing in a frame in a Jtable object being called from the Jtable(vector data, vector columnnames) constructor i want to view only columns ITEMID,ITEMNAME,ITEMPRICE,ITEMQUAN,DATEOFPURCHASE. But my code is not allowing me to do. In my code my vector retrieves all column names and displays all. I dont want that to happen. I just want the above columns. How do i do that?

package com.frame;

import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.Vector;

import javax.naming.spi.DirStateFactory.Result;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;

import com.dao.SearchUserDAO;

public class AddItemsToAccount  extends JFrame implements ActionListener{

/**
	 * 
	 */
	PreparedStatement ptmt ;
	 JTextField itemcodetxt;
	 JButton additembtn ;
	 
	JLabel itemcodelbl ;
	JTable table;
	JPanel tablepanel;
	JScrollPane scrollpane;
	public static String customerid = SearchUserDAO.custid;
	
	
	private static final long serialVersionUID = 1L;

public AddItemsToAccount()
{

	
	// TODO Auto-generated method stub
	
	
setLayout(new FlowLayout());

	
	 itemcodelbl =new JLabel("Item Code:");
	add(itemcodelbl);

	itemcodetxt = new JTextField(10);
	add(itemcodetxt);
	
	 additembtn = new JButton("Add Item");
	add(additembtn);
	additembtn.addActionListener(this);
	
	table = new JTable();
	
	table.setPreferredScrollableViewportSize(new Dimension(500, 70));
	table.setFillsViewportHeight(true);

	
	// Create the scroll pane and add the table to it.
	scrollpane = new JScrollPane(table);

	tablepanel=new JPanel();
	
	// Add the scroll pane to this panel.
	tablepanel.add(scrollpane);

	add(tablepanel);
	
//	initComponents();
	
	System.out.println("inside add to account");
	System.out.println(SearchUserDAO.custid);
	
	//viewuseraccount();
	
}
/*private void viewuseraccount() {
	// TODO Auto-generated method stub
	String custid = SearchUserDAO.custid;
	try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection conn = DriverManager.getConnection("jdbc:odbc:XE",
			"system", "tiger");
	System.out.println("Connecion Successfull");
	System.out.println(conn); 
           
    String query = "Select * from purchases where custid= ?"+custid;
   PreparedStatement ptmt =
		   null;
   ptmt = conn.prepareStatement(query);
   ResultSet rs = ptmt.executeQuery();
	ResultSetMetaData rsmd=ptmt.getMetaData();
	
   Vector colnames = new Vector<>();
   for(int i=1 ;i<rsmd.getColumnCount();i++)
	   colnames.add(rsmd.getColumnName(i));
   
   System.out.println(colnames);
   System.out.println("Viewing Customer"+custid+"account:");
   Vector data =new Vector<>();
   while(rs.next())
   {
	   Vector row = new Vector<>();
	   row.addElement(rs.getString(1));
	   
   }
   
   
    
   
	}catch (Exception e) {
		// TODO: handle exception
		System.out.println(e);
	}
	
}*/
private void initComponents() {
	


}
@Override
public void actionPerformed(ActionEvent e) {
	// TODO Auto-generated method stub
	
	
	String itemcodepass = itemcodetxt.getText();
	String itemname = null;
	String itemcode = null;
	int itemprice=0 ;
	int itemquan = 0 ;
	try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection conn=DriverManager.getConnection("jdbc:odbc:XE","system","tiger");
	System.out.println("Connection Successful");
	System.out.println(conn);
	String query1 = "Select * from items where itemcode =" +itemcodepass;
	Statement stmt =conn.createStatement();
	
	ResultSet rs = stmt.executeQuery(query1);
	while(rs.next())
	{
		itemname = rs.getString("itemname");
		 itemcode = rs.getString("itemcode");
		 itemprice = rs.getInt("itemprice");
		 itemquan = rs.getInt("itemquan");
		
		
	}
	
	
	
	System.out.println("Items retrieved:\t"+itemname+"\t"+itemcode+"\t"+itemprice+"\t"+itemquan);
	PreparedStatement ptmt2 =null;
	String query2 = "insert into purchases(customer_id, itemid,itemname,itemprice,itemquan,dateofpurchase) values(?,?,?,?,?,?)";
	
	java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());
    System.out.println(sqlDate);


	ptmt2 = conn.prepareStatement(query2);
	ptmt2.setString(1, customerid);
	ptmt2.setString(2,itemcode);
	ptmt2.setString(3, itemname);
	ptmt2.setInt(4, itemprice);
	ptmt2.setInt(5,itemquan);
	ptmt2.setDate(6, sqlDate);
	
	
	ptmt2.executeUpdate();
	
	
	PreparedStatement ptmt3 = null;
	
	System.out.println("items inserted into purchases table");
	String q = "select itemid,itemname,itemprice,itemquan,dateofpurchase from purchases where customer_id"+customerid;
	

	ptmt3 = conn.prepareStatement(q);
	ResultSet rec = ptmt3.executeQuery();
ResultSetMetaData rsmd=ptmt3.getMetaData();

	// Statement stmt = conn.createStatement();

Object[] columnNames = { "Code", "Name", "Price",
		"Quantity", "Date Of Puchase"};

Object [][] data1={};

	Vector colnames=new Vector<>();
	for(int i=1;i<=rsmd.getColumnCount();i++)
		colnames.add(rsmd.getColumnName(i));
	
	System.out.println("Colnames: "+colnames);
	System.out.println("viewing items");
	Vector data=new Vector<>();
	while (rec.next()) {
		
	//	System.out.println(rec.getString(1) + "" + rec.getString(2));

		Vector row=new Vector<>();
		row.addElement(rec.getString("itemid"));
		row.addElement(rec.getString("itemname"));
		row.addElement(rec.getInt("itemprice"));
		row.addElement(rec.getInt("itemquan"));
	row.addElement(rec.getDate("dateofpurchase"));
		
		/*for(int i=1;i<=rsmd.getColumnCount();i++)
		{
			row.addElement(rec.getString(i));
			
			System.out.println("hello from obj"+rec.getObject(i));
		}*/
			
		data.add(row);
		System.out.println(row);
	}
	
	if(table!=null)
	{
		tablepanel.remove(scrollpane);
		
		scrollpane=null;
		validate();
		
	}
	

	table=new JTable(data, colnames);
	scrollpane=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
	tablepanel.add(scrollpane);
	validate();
	

	}
	catch (Exception e2) {
		// TODO: handle exception
		System.out.println(e2);
	}
	
}
public static void main(String[] args) {
 	
	
}



}