kobewang

f1g1ns1.dnspod.net
f1g1ns2.dnspod.net

<?php
/** 
* 写文件 
* @param string $file 文件路径 
* @param string $str 写入内容 
* @param char $mode 写入模式 
*/ 
function logwrite($filename,$str,$mode='a') 	
{ 
	$file=DT_ROOT.'\\log\\'.$filename.'.txt';
 
	$oldmask = @umask(0); 
	$fp = @fopen($file,$mode); 
	@flock($fp, 3); 
	if(!$fp) 
	{ 
		Return false; 
	} 
	else 
	{ 
		@fwrite($fp,$str."\r\n"); 
		@fclose($fp); 
		@umask($oldmask); 
		Return true; 
	} 
} 
?>

public class MyWhois extends Activity {
	private TextView vResult;
	private EditText eKeyWord;
	/** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
 
        Button sButton1 = (Button)findViewById(R.id.Submit); 
        vResult = (TextView)findViewById(R.id.ResultView);
    	eKeyWord = (EditText)findViewById(R.id.KeyWord); 
 
        //注册点击事件监听者  
        sButton1.setOnClickListener(new OnClickListener()
        {
            public void onClick(View aView) { 
            	TextView vResult = (TextView)findViewById(R.id.ResultView);
            	vResult.setText("正在查询中，请稍等！");
 
            	//新建查询线程，否则UI界面会假死
            	Thread mThread = new Thread(new Runnable() {
            		public void run() {  
            			String whoisMes="";
                    	  try {
                    		  try
                 		     {
                 			   String domain=eKeyWord.getText().toString();
                 			   String IP="whois.cnnic.cn";
                 			   if(domain.contains(".com")||domain.contains(".com")){
                 				   IP="whois.internic.net";
                 			   }				   
                 		       Socket socket = new Socket(IP, 43);
                 		       InputStream Is = socket.getInputStream();
                 		       OutputStream Os = socket.getOutputStream();
                 		       DataInputStream DIS = new DataInputStream(Is);
                 		       PrintStream PS = new PrintStream(Os);
                 		       DataInputStream in = new DataInputStream(System.in);		      
                 		       PS.println(domain);
                 		       System.out.println("please wait whois's message...");
 
                 		       boolean TF = false;
 
                 		       while (DIS.read() > 0) {
                 		         String tempStr = DIS.readLine();
                 		        whoisMes = whoisMes + tempStr + "\r\n";
                 		       }
                 		       whoisMes=new String(whoisMes.getBytes("ISO-8859-1"),"utf-8");
                 		       System.out.println(whoisMes);
                 		       DIS.close();
                 		       PS.close();
                 		       Is.close();
                 		       Os.close();
                 		       socket.close();
                 		     } catch (Exception e) {
                 		       System.out.println("Error:" + e);
                 		     }
                    		  //返回的数据需要使用'\n'来换行！
                    		            Message mg = Message.obtain();  
                    		            mg.obj = whoisMes;  
                    		            mHandler.sendMessage(mg);  
 
                    		  } catch (Exception e) {
                    		   e.printStackTrace();
                    		  }
            		}
 
            	});
            	 mThread.start();  
            }
        }
 
        ); 
    }
 
    //定义一个Handler  
    private Handler mHandler = new Handler(){  
        public void handleMessage(Message msg){  
        	String m = (String) msg.obj;
        	if(m.length()<=0)
        	{
        		vResult.setText("查询结果为空.");
        	}
        	else
        	{
        		vResult.setText(m);
        	}
        }  
    };  
}

ALTER  PROCEDURE [dbo].[P_PAGE] (
@CurrentPage int,
@PageSize int,
@TableName varchar(1000),
@KeyField varchar(1000),
@Fields varchar(1000),
@Condition1 varchar(2000),
@Condition2 varchar(1000),
@PageCount int output,
@RecordCount int output,
@sql nvarchar(4000) output
)AS
declare @num numeric(8,2),@pz numeric(8,2),@rpz int
set @sql = 'select @RecordCount=count(id) from '+@TableName+' '+@Condition1
exec sp_executesql @sql,N'@RecordCount int output',@RecordCount output
set @pz = @PageSize
set @num = @RecordCount / @pz
set @rpz = @num
if @num > @rpz set @rpz = @rpz + 1
select @PageCount = @rpz
if @CurrentPage < 1
begin
	set @CurrentPage = 1
end
if @CurrentPage > @PageCount and @PageCount >0
begin
	set @CurrentPage = @PageCount
end
print @CurrentPage
if(@CurrentPage=1)
begin
	set @sql = 'select top '+convert(varchar,@PageSize)+' '+@Fields+' from '+@TableName+' '+@Condition1+' '+@Condition2
end
else
begin
set @sql='SELECT '+@Fields+' FROM (SELECT '+@Fields+', ROW_NUMBER() OVER(ORDER BY id asc) AS rownum FROM '+@TableName+' ) as Tbl
  WHERE rownum BETWEEN '+convert(varchar,(@CurrentPage-1)*@PageSize+1)+' AND '+convert(varchar,@CurrentPage*@PageSize)
end
exec sp_executesql @sql

另附2005 索引重聚proc
 
GO
/****** 对象:  StoredProcedure [dbo].[db2005_indexes]    脚本日期: 01/05/2012 09:32:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[db2005_indexes]
AS
SET NOCOUNT ON
DECLARE @tablename VARCHAR (128)
DECLARE @execstr VARCHAR (255)
DECLARE @objectid INT
DECLARE @objectowner VARCHAR(255)
DECLARE @indexid INT
DECLARE @frag DECIMAL
DECLARE @indexname CHAR(255)
DECLARE @dbname sysname
DECLARE @tableid INT
DECLARE @tableidchar VARCHAR(255)
 
SELECT @dbname = db_name()
IF @dbname IN ('master', 'msdb', 'model', 'tempdb')
BEGIN
PRINT '不能运行系统数据库'
RETURN
END
 
DECLARE tables CURSOR FOR
SELECT convert(varchar,so.id)
FROM sysobjects so
JOIN sysindexes si
ON so.id = si.id
WHERE so.type ='U'
AND si.indid < 10 AND si.rows > 0 
 
CREATE TABLE #templist (
ObjectName CHAR (255),
ObjectId INT,
IndexName CHAR (255),
IndexId INT,
Lvl INT,
CountPages INT,
CountRows INT,
MinRecSize INT,
MaxRecSize INT,
AvgRecSize INT,
ForRecCount INT,
Extents INT,
ExtentSwitches INT,
AvgFreeBytes INT,
AvgPageDensity INT,
ScanDensity DECIMAL,
BestCount INT,
ActualCount INT,
LogicalFrag DECIMAL,
ExtentFrag DECIMAL)
 
OPEN tables
 
FETCH NEXT
FROM tables
INTO @tableidchar
 
WHILE @@FETCH_STATUS = 0
BEGIN
 
INSERT INTO #templist
EXEC ('DBCC SHOWCONTIG (' + @tableidchar + ') WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS')
FETCH NEXT
FROM tables
INTO @tableidchar
END
 
CLOSE tables
DEALLOCATE tables
 
SELECT * FROM #templist w--here indexname like '%destine%'

DECLARE indexes CURSOR FOR
SELECT ObjectName, ObjectOwner = user_name(so.uid), ObjectId, IndexName, ScanDensity
FROM #templist f
JOIN sysobjects so ON f.ObjectId=so.id
WHERE INDEXPROPERTY (ObjectId, IndexName, 'IndexDepth') > 0
 
SELECT '开始重新生成或者重组索引 ' + CONVERT(VARCHAR,GETDATE())
 
OPEN indexes
 
FETCH NEXT
FROM indexes
INTO @tablename, @objectowner, @objectid, @indexname, @frag
 
WHILE @@FETCH_STATUS = 0
BEGIN
SET QUOTED_IDENTIFIER ON
 
if(@frag>30)
begin
SELECT @execstr = 'DBCC DBREINDEX (' + '''' +RTRIM(@objectowner) + '.' + RTRIM(@tablename) + '''' +
', ' + RTRIM(@indexname) + ') WITH NO_INFOMSGS'
SELECT '正在执行: '
--SELECT(@execstr)
print @execstr
EXEC (@execstr)
 
end
else if (@frag<30)
begin
SELECT @execstr = 'DBCC INDEXDEFRAG ('+db_name()+','+ '''' +RTRIM(@objectowner) + '.' + RTRIM(@tablename) +  '''' +
', ' + RTRIM(@indexname) + ') WITH NO_INFOMSGS'
SELECT '正在执行: '
--SELECT(@execstr)
print @execstr
EXEC (@execstr)
end 
 
SET QUOTED_IDENTIFIER OFF
 
FETCH NEXT
FROM indexes
INTO @tablename, @objectowner, @objectid, @indexname, @frag
END
 
CLOSE indexes
DEALLOCATE indexes
 
SELECT '完成结束索引' + CONVERT(VARCHAR,GETDATE())
 
DROP TABLE #templist

APP_NAME="SocketServer"
APP_LONG_NAME="SocketServer Application Server"
WRAPPER_CMD="./wrapper"
WRAPPER_CONF="../conf/wrapper.conf"
赋予执行权限
chmod 775 /opt/testapp/bin/symydns
chmod 775 /opt/testapp/bin/wrapper
 
3、修改/opt/testapp/conf/wrapper.conf文件
wrapper.java.command=/opt/jdk1.6.0_02/bin/java
使用WrapperStartStopApp，这样可以通过命令带start/stop来启动/停止程序，这个千万不要改，改了后会启动多个JVM。
wrapper.java.mainclass=org.tanukisoftware.wrapper.WrapperStartStopApp
#这里添加你用到的jar包文件，从1..n你自己全写上吧，不过wrapper是必须的
wrapper.java.classpath.1=../lib/wrapper.jar
wrapper.java.classpath.2=../lib/test.jar
wrapper.java.classpath.3=/opt/jdk1.6.0_02/lib/dt.jar
wrapper.java.classpath.4=/opt/jdk1.6.0_02/lib/tools.jar
wrapper.java.library.path.1=../lib
#这个就是你自己可执行程序的主类(MainClass)，一般来说，就是包含public static void main的那个类
wrapper.app.parameter.1=mydns.testjsvc
wrapper.app.parameter.2=1
wrapper.app.parameter.3=true
wrapper.app.parameter.4=cn.com.ppnote.SocketServer
wrapper.app.parameter.5=true
wrapper.app.parameter.6=1
wrapper.app.parameter.7=stop
上面的配置里使用了WrapperStartStopApp，这样可以通过命令带start/stop来启动/停止程序。
 
4、让SocketServer开机自动运行
ln -s /opt/testapp/bin/SocketServer /etc/init.d/SocketServer
ln -s /opt/testapp/bin/SocketServer /etc/rc0.d/SocketServer
ln -s /opt/testapp/bin/SocketServer /etc/rc1.d/SocketServer
ln -s /opt/testapp/bin/SocketServer /etc/rc2.d/SocketServer
ln -s /opt/testapp/bin/SocketServer /etc/rc3.d/SocketServer
ln -s /opt/testapp/bin/SocketServer /etc/rc4.d/SocketServer
ln -s /opt/testapp/bin/SocketServer /etc/rc5.d/SocketServer
ln -s /opt/testapp/bin/SocketServer /etc/rc6.d/SocketServer
 
5、测试 执行命令：service symydns start|stop|restart|status