package cn.com.lzt.common.util.calendar;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.ParsePosition;
import java.text.SimpleDateFormat;
import java.util.Date;

/**
 * 执行增删改查
 * @author zbw
 * 2017-10-23
 */
public class SelectTest extends JdbcConnection{

//	public static JdbcConnection jdbcConnection;
	protected static ResultSet rs=null;
	
	public static void main(String[] args) {
		
		System.out.println(getUpdate());
		//System.out.println(getQuery());
		
		rs=getQuery();
		try {
			if(rs.next()){
				String id=rs.getString("id");
				String name=rs.getString("year");
				String age=rs.getString("month");
				String day=rs.getString("day");
				System.out.println("id:"+id+",name:"+name+",age:"+age+",day:"+day);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			close();
		}
		
	}
	
	public static ResultSet getQuery(){
		StringBuffer stringBuffer=new StringBuffer();
		stringBuffer.append("select * from t_bus_calendar ");
		//stringBuffer.append("where id = ?");
//		return JdbcConnection.executeQuery(stringBuffer.toString(),new Object[]{1});
		return JdbcConnection.executeQuery(stringBuffer.toString());
	}
	
	public static int getUpdate(){
		String sql="insert into t_bus_calendar (id,year,month,day) values('1','2017','10','23')";
		return JdbcConnection.executeUpdate(sql,new Object[]{});
	}
	
	

	

}