http://notepad-plus-plus.org/
設定中文
設定自動完成
SELECT * FROM user OFFSET 30 ROWS FETCH NEXT 10 ROWS ONLY;之前的版本:
SELECT TOP 10 id,name FROM user WHERE id not in (SELECT TOP 30 id FROM user ODER BY id ASC)
ODER BY id ASC
// 取得目前日期 Date date = new Date(); DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss"); String currentDatetime = dateFormat.format(date); // 日期-1 Calendar day = Calendar.getInstance(); day.add(Calendar.DATE,-1); SimpleDateFormat sdf = new SimpleDateFormat( "yyyy-MM-dd "); System.out.println("yesterday =" + sdf.format(day.getTime())); // String 轉日期 String currentDate = "2012-12-13"; Date date = sdf.parse(currentDate); // 解析 Calendar calendar = Calendar.getInstance(); // 呼叫Calendar calendar.setTime(date); // 設定指定時間 int year=calendar.get(Calendar.YEAR); // 取得年月日 int month=calendar.get(Calendar.MONTH); int day=calendar.get(Calendar.DAY_OF_MONTH); String _year = Integer.toString(year); // 轉字串 String _month = Integer.toString(monthOfYear + 1); String _day = Integer.toString(dayOfMonth); String date = _year + "-" + _month + "-" + _day;
void dateView(){ SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); try { //設定日期格式 Date date = sdf.parse(currentDate); Calendar calendar = Calendar.getInstance();//取得目前時間 calendar.setTime(date);//或是設定指定時間 int year=calendar.get(Calendar.YEAR); int month=calendar.get(Calendar.MONTH); int day=calendar.get(Calendar.DAY_OF_MONTH); new DatePickerDialog(this, new DatePickerDialog.OnDateSetListener() { @Override public void onDateSet(DatePicker view, int year,int monthOfYear, int dayOfMonth) { // 設置日曆 String _year = Integer.toString(year); String _month = Integer.toString(monthOfYear + 1); String _day = Integer.toString(dayOfMonth); String date = _year + "-" + _month + "-" + _day; currentDate = date; editDate.setText(date); } }, year, month, day).show(); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); } }
/* 是否有網路 { */ ConnectivityManager conManager = (ConnectivityManager) getSystemService(CONNECTIVITY_SERVICE);//先取得此service NetworkInfo networInfo = conManager.getActiveNetworkInfo(); //在取得相關資訊 if (networInfo == null || !networInfo.isAvailable()){ //判斷是否有網路 Toast.makeText(this, "未偵測到網路連線", Toast.LENGTH_LONG).show(); new Thread(new Runnable() { public void run() { Intent it = new Intent(); it.setClass(Vegetable.this, Home.class); startActivity(it); } }).start(); } /* 是否有網路 } */