package com.netease.backend.db.test.sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

import com.netease.backend.db.DBConnection;

public class MyTest {
	
	private Connection conn;
	
	private void initConn() throws Exception{
			Class.forName("com.mysql.jdbc.Driver");
			//conn = DriverManager.getConnection("jdbc:mysql://172.19.0.65:4444/test?user=being&password=test");
			conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1/test?user=root");
	}
	
	private void initData(int num) throws SQLException{
	
		System.out.println("Begin initialize data ...");
		long start = System.currentTimeMillis();
		Statement stmt = conn.createStatement();
		String sql = "insert into test1 values ";
		for(int i=0;i<num;i++){
			if(i!=0)
				sql += ",";
			sql += "("+i+")";
		}
		stmt.execute(sql);
		System.out.println("End of initializing data in "+(System.currentTimeMillis()-start)+" ms");
	}
	
	
	private void testSql(int condNum) throws SQLException{
		System.out.println("Begin test sql ...");
		long start = System.currentTimeMillis();
		Statement stmt = conn.createStatement();
		String sql = "select * from test1 where ";
		for(int i=0;i<condNum;i++){
			if(i!=0)
				sql += " and ";
			sql += "id<>"+i;
		}
		stmt.execute(sql);
		System.out.println("End of testing sql in "+(System.currentTimeMillis()-start)+" ms");
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		
		MyTest test = new MyTest();
		try{
			test.initConn();
			test.initData(10000);
			test.testSql(10000);
		}catch(Exception e){
			e.printStackTrace();
		}

	}

}