private static void getListFromMysql(List<String> weiboList,List<String> emotionList) {
		basecon = new _baseCon();
		con = basecon.connSQL();
		
		try {
			String getWeiboFenciString = "SELECT * FROM `sentence` WHERE `class` in ('无','无 无')  order by`id` limit 0,2000";
			PreparedStatement statement = con.prepareStatement(getWeiboFenciString);
			statement.executeQuery();

			ResultSet rs = statement.getResultSet();
			while (rs.next()) {
				//System.out.println(rs.getString("segment"));
				weiboList.add(rs.getString("segment"));
				emotionList.add("none");
				//System.out.println(weiboList.size());
			}
			
			getWeiboFenciString = "SELECT * FROM `sentence` WHERE `class` like '幸福类%'  order by`id` limit 0,2000";
			statement = con.prepareStatement(getWeiboFenciString);
			statement.executeQuery();

			rs = statement.getResultSet();
			while (rs.next()) {
				//System.out.println(rs.getString("segment"));
				weiboList.add(rs.getString("segment"));
				emotionList.add("happiness");
				//System.out.println(weiboList.size());
			}
			
			getWeiboFenciString = "SELECT * FROM `sentence` WHERE `class` like '喜爱类%'  order by`id` limit 0,2000";
			statement = con.prepareStatement(getWeiboFenciString);
			statement.executeQuery();

			rs = statement.getResultSet();
			while (rs.next()) {
				//System.out.println(rs.getString("segment"));
				weiboList.add(rs.getString("segment"));
				emotionList.add("like");
				//System.out.println(weiboList.size());
			}
			
			getWeiboFenciString = "SELECT * FROM `sentence` WHERE `class` like '愤怒类%'  order by`id` limit 0,2000";
			statement = con.prepareStatement(getWeiboFenciString);
			statement.executeQuery();

			rs = statement.getResultSet();
			while (rs.next()) {
				//System.out.println(rs.getString("segment"));
				weiboList.add(rs.getString("segment"));
				emotionList.add("anger");
				//System.out.println(weiboList.size());
			}
			
			getWeiboFenciString = "SELECT * FROM `sentence` WHERE `class` like '悲伤类%'  order by`id` limit 0,2000";
			statement = con.prepareStatement(getWeiboFenciString);
			statement.executeQuery();

			rs = statement.getResultSet();
			while (rs.next()) {
				//System.out.println(rs.getString("segment"));
				weiboList.add(rs.getString("segment"));
				emotionList.add("sadness");
				//System.out.println(weiboList.size());
			}
			
			getWeiboFenciString = "SELECT * FROM `sentence` WHERE `class` like '害怕类%'  order by`id` limit 0,2000";
			statement = con.prepareStatement(getWeiboFenciString);
			statement.executeQuery();

			rs = statement.getResultSet();
			while (rs.next()) {
				//System.out.println(rs.getString("segment"));
				weiboList.add(rs.getString("segment"));
				emotionList.add("fear");
				//System.out.println(weiboList.size());
			}
			
			getWeiboFenciString = "SELECT * FROM `sentence` WHERE `class` like '讨厌类%'  order by`id` limit 0,2000";
			statement = con.prepareStatement(getWeiboFenciString);
			statement.executeQuery();

			rs = statement.getResultSet();
			while (rs.next()) {
				//System.out.println(rs.getString("segment"));
				weiboList.add(rs.getString("segment"));
				emotionList.add("disgust");
				//System.out.println(weiboList.size());
			}
			
			getWeiboFenciString = "SELECT * FROM `sentence` WHERE `class` like '惊讶类%'  order by`id` limit 0,2000";
			statement = con.prepareStatement(getWeiboFenciString);
			statement.executeQuery();

			rs = statement.getResultSet();
			while (rs.next()) {
				//System.out.println(rs.getString("segment"));
				weiboList.add(rs.getString("segment"));
				emotionList.add("surprise");
				//System.out.println(weiboList.size());
			}
//			String getWeiboQingxu = "SELECT `class` FROM `sentence` WHERE `source`=1";
//			PreparedStatement statement2 = con.prepareStatement(getWeiboQingxu);
//			statement2.executeQuery();
//
//			ResultSet rs2 = statement2.getResultSet();
//	
//			while (rs2.next()) {
//				//System.out.println(rs2.getString("class"));
//				//emotionList.add(rs2.getString("class"));
//
//				if(rs2.getString("class").startsWith("幸福类"))
//					emotionList.add("happiness");
//				else if(rs2.getString("class").startsWith("喜爱类"))
//					emotionList.add("like");
//				else if(rs2.getString("class").startsWith("愤怒类"))
//					emotionList.add("anger");
//				else if(rs2.getString("class").startsWith("悲伤类"))
//					emotionList.add("sadness");
//				else if(rs2.getString("class").startsWith("害怕类"))
//					emotionList.add("fear");
//				else if(rs2.getString("class").startsWith("讨厌类"))
//					emotionList.add("disgust");
//				else if(rs2.getString("class").startsWith("惊讶类"))
//					emotionList.add("surprise");
//				else
//					emotionList.add("none");
//			}
			//System.out.println(emotionList);
			con.close();

			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}