package com.db;

import java.sql.*;
public class Jdo {
	Connection conn=null;
	Statement stmt=null;
	
	public Jdo()
	{
	
			try
			{
//				java.sql.DriverManager.registerDriver(new org.gjt.mm.mysql.Driver());
				Class.forName(Config.driver);
				conn=DriverManager.getConnection(Config.url,Config.user,Config.password);
				stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
			} 
			catch (Exception e) 
			{
				System.out.println("class not find or sqlexception");
				e.printStackTrace();
			}
		
	}

	public void executeUpdate(String sql)
	{
		try {
			
			
			stmt.executeUpdate(sql);
		} 
		catch (SQLException e) 
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	public  ResultSet executeQuery(String sql) 
	{
		ResultSet rs=null;
		
		try {
		
			
			rs= stmt.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
		return rs;
	}
	public void destroy()
	{
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public String executeQueryString(String sql)
	{
		
		ResultSet rs=null;
		
		try {
		
			
			rs= stmt.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
		try {
			rs.next();
			return rs.getString(1);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	public int executeQueryInt(String sql)
	{
		
		ResultSet rs=null;
		
		try {
		
			
			rs= stmt.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
		try {
			rs.next();
			return rs.getInt(1);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return 1;
	}
	public int rowCount(String sql)
	{
		ResultSet rs=null;
		
		try {
		
			
			rs= stmt.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
		int i=0;
		try {
			rs.next();
			i= rs.getInt(1);
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return i;
	}
	
	public static void main(String args[]) throws SQLException
	{
		Jdo jdo=new Jdo();
		jdo.executeUpdate("insert into `order`(`ordernumber`) values ( '1123')");
		//jdo.executeUpdate("insert into order(ordernumber) values ( '1123')");
		jdo.destroy();
		System.out.println((int)Math.ceil((double)8/(double)3));
		System.out.println( (int)Math.ceil((double)8)/((double)3));
			//System.out.println(count);
		
	}

}