`
文章列表

日期格式化

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <link rel="stylesheet" type="text/css" href="./jqu ...
http://blog.csdn.net/chszs/article/details/45922299 八个最佳Python IDE 作者:chszs,转载需注明。博客主页:http://blog.csdn.net/chszs Python是一种功能强大、语言简洁的编程语言。本文向大家推荐8个适合Python开发的IDE。 1. Eclipse with PyDev http: ...
 解决方法: 进入dos下,进行如下操作    如果点击启动,还报错,则下载版本低的virtualbos.  
selectad_org.name,t001.waers,glt0.bukrs,glt0.ryear,ad_quarter.quarter,text('8314.1 借款费用 Interest Expenses')  name1,   text('8314.1 借款费用 Interest Expenses')  name1  

sql字段合并

mysql> select concat('11','22','33'); +------------------------+ | concat('11','22','33') | +------------------------+ | 112233 | +------------------------+ row in set (0.00 sec)

ue删除空行

ue删除空行   删除含有某个字符的一行    
postgresql数据库   把数字类型与字符类型比较 进行转换 cast(classify.ad_org_id as char(4)) glt0.bukrs=cast(classify.ad_org_id as char(4))

devsap_new.sql

USE [DEVSAP_NEW]GO/****** Object:  Table [dbo].[ZT001]    Script Date: 05/09/2014 15:08:11 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[ZT001]( [BUKRS] [nvarchar](4) NOT NULL, [BUTXT] [nvarchar](25) NOT NULL, [ORT01] [nvarchar](25) NOT NULL, [KTOPL] [nvarchar](4) NOT NULL,  ...
scp命令: [root@node1 mppdata]# scp test.csv 192.168.80.249:/mppdata root@192.168.80.249's password:  

gbase查看建表语句

  show create table dw_kdrz_speed;    

gbase建表模板

 
建表模板 CREATE TABLE "off_net" ( "TIME_DAY" datetime DEFAULT NULL, "CALLING_DN" varchar(50) DEFAULT NULL, "CALLED_DN" varchar(50) DEFAULT NULL, "CONN_TIME" float DEFAULT NULL, "CALL_ALL_NUM" bigint(20) DEFAULT NULL, "NO ...
读取属性文件 String propertyFileName = "DB.properties";   Properties prop = new Properties(); prop.load(PropertyFilesUtil.class.getClassLoader().getResourceAsStream(propertyFileName));  

File.separator

    博客分类:
  • Java
 
文件分隔符 System.out.println("File.separator = "+File.separator);  结果 File.separator = \  

oracle自定义函数

oracle自定义函数,用来查看当前的用户名 1.自定义函数 create or replace function funone return varchar2 is name varchar2(50); begin select username into name from user_users; return name; end; /  2.执行函数 SQL> var username varchar2(50) SQL> exec :username:=funone; 结果如下: PL/SQL procedure su ...
The parent project must have a packaging type of POM 解决办法是将pom.xml 中的   <packaging>jar</packaging> 改成  <packaging>pom</packaging>  
Global site tag (gtag.js) - Google Analytics