updateforyear.java

来自「JAVA对DB2数据库的详细操作·！ JAVA对DB2数据库的详细操作·！」· Java 代码 · 共 74 行

package com.topsoft.updateForYear;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Date;
import java.util.Calendar;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import com.topsoft.updateForYear.DBConnection;


public class UpdateForYear {
	
	private static Connection db2Conn = DBConnection.getDB2Connection();
	private static Log log = LogFactory.getLog(UpdateForYear.class);
	
	public static void main(String[] args) 
	{
		try
		{
			System.out.println("开始显示查询结果!");
			String selectId = "select mc,zch from dj_zt where zt='06' and mc like '%安徽美丹物业管理有限公司%'";
			
			Statement selectStmt = db2Conn.createStatement();
			ResultSet ztRs = selectStmt.executeQuery(selectId);

			while(ztRs.next())
			{
				System.out.println(ztRs.getString("mc")+"     "+ztRs.getString("zch"));
				System.out.println(ztRs.getLong(2));			//显示结果集第二个字段
				
				Calendar d = Calendar.getInstance();
				System.out.println(d.getFirstDayOfWeek());   
				System.out.println(d.getTime());
				System.out.println(d.getTimeZone());

				
/*				if(ztRs.next())
				{
					System.out.println("还有");
				}
				else
				{
					System.out.println("终于没有啦！");
				}*/                      //有问题
			}

			ztRs.close();
			selectStmt.close();
			db2Conn.close();
			System.out.println("修复完毕!");
		}
		
		catch(Exception f)
		{
			log.error("主程序错误：", f);
			throw new RuntimeException(f);
			
		}
	}
}






/*System.out.println(ztRs.getRow());

System.out.println(ztRs.getCharacterStream("mc"));

System.out.println(ztRs.getCursorName());*/