皮皮网

1.求把sql语句转成tinkPHP 的形式怎么写
2.java.lang.NullPointerException
3.eval(function(p,a,c,k,e,r) 解密

求把sql语句转成tinkPHP 的形式怎么写

       建议建立一个 modelView 

public $viewFields = array(

        'sr_jxc_inventory_log' => array('_as'=>'L''goods_id','warehouse_id','sum'=>array(

            'actual_number'=>'js'

            ),

            'sum' => array(

                 'case' => array(

                            'when' => 'actual_number> 0',

                            'then' => 'actual_number',

                            'else' => '0'

                         ),

                         '_as' => 'sr'

             ),

             'sum' => array(

                 'case' => array(

                     'when' => 'actual_number <0',

                     'then' => 'actual_number',

                     'else' => '0'

                 ),

                 '_as' => 'zc'

             ),

            ),'pid'),

        'sr_goods' => array('_as'=>'G','model','factory','barcode','_on' => 'style.id=color.pid'),

        'sr_jxc_ware' => array('_as'=>'W','name','_on' => 'style.id=color.pid'),

       );

       其实也自己瞎搞的，这样的天仙道游戏源码还真没搞过，实在不行直接运行源码就好了，涨停确认源码如果可以的源码基础修改话，请务必告知一声。魔兽源码丢失

java.lang.NullPointerException

       å¾ˆå¤šå¯èƒ½ä¸ºnull的情况你都没处理，当然会出NullPointerException 错误

       æ¯”如：

       String username=request.getParameter("username");

       String password=request.getParameter("password");

       String str="select * from tb_user where"+"username="+username+"and password="+password;

       åº”该改成：

       String username=request.getParameter("username");

       String password=request.getParameter("password");

       if(username != null && password != null){

       String str="select * from tb_user where"+"username="+username+"and password="+password;

       â€¦â€¦â€¦â€¦â€¦â€¦

       â€¦â€¦â€¦â€¦â€¦â€¦

       }

       ä¸‹é¢çš„代码自己再检查检查，类似的情况都要先判断

eval(function(p,精读圣经源码a,c,k,e,r) 解密

       直接使用在线解密工具，已测试可以解密此文件

njxz8On2TpsdQCgfCQD7cCfEXQiXuJxKjIS7ZPRT9+zkmP6YEBWLjEqZ4asu3toXAO/B3Gc1k9eFq+2wc9aHduzr9ps8QJivXLx0PsljOtWugOZZlwqC+ZwA0AyTwHQs6x0eKOCxKzkCqRDDMDkXXmssV2pNyTbU6HwqoBeE0usGhgGh9FBnWhRLySC+UD5xKy+dKiIDtgCeNsXdEE0/S8AGClx0OlmAlmC6FTVRwOIpEgHBC2gtqyFNlH4iR8P5MQF6PTycERpsa+2uFmhFW6mAPJIrER0HzZZoTbqWmKwWuwLyaCkPOpNhCa5IOWxzYangXUAiraeoc2VPqL6AbPLMZIEe5ae6Vm4kwCFiJ4GlQ/8dT4Qds2VYmdUL8Gn5IogQLiJJ4ZjYAVyWIGUQhmhQBdLnhAXaz/mscohoSoZcoSDcgeU+TS1BF/POBjYBeNxx/vOsqL1aBEdtu5afIQhq5nw7qov4RlDtKKNuD2pHMzPFjgxzm1hxyikTMKvOZtABAoVbN7b4tfryN7g7QqmbCH6+EuDOCbTBfqevEnGqOrERFN8xoy3ppaQkJ9SKMzWd1CqDltzSqcjKvdVywRHCn4KUmM8IRwUf5RGzBqmlZWKS2UKXavygY5M8HOpy7Q2faQ1sasVA4iGfYsEXMkSYtggu7OZnpAwcub5C+qfPEPOu/eDaOC6T9ensvfwmOQTu8qVgy5+1qPLIdFjj+kKkZOdS9yeE6+HzMdrfCb/ec7B4EYGvQWsT5OxBJYWdSo7OMctlMRolp3DqLa/P0iABQeucxErROtnnkv7qtaqNZwKzad+z2aHAvEDJ8Z+d2z0GPG6icSce3Dwb1Icf4UC7foXYFwA5Qw+OeIkuSYHtZoMqSduAQAwPkS5ePp5+zzyxtk7L9XF5hRbJaNymoP7wMQOzFvvNTR7daesG7EuhzbKNWW0GFECKk++IJ9uwxwMQHfYpMcYzsszWrTLw9UScTBfqViHhxiUrmarsrt5h/BD5RWHsTu9fdr0FW7GrPGxqyh2x1TF7/t3zbFGmp3+FMOa0pH7Or2LQVOuqErKRGWLeP8tn4YPWCq0VRP2D+MpVXIoChKil3pHvXAjxTWLCeXdVvWs7tcvjip6YXWebRIlu9WfNCoPaRv4ULuy+eLe+7kelk0ijzo7G3R0M/BNnaVo0lbOjy5MzdMp0T9gbtVCkgUMaLC+ye6PZLQo7RKiTf8KrceEQQ6EKYIO3XcULPJNyj/qr9jvsTBtFtZfNqYY+i+hdwITBWSr/lXV1pLcC8rgjp0LCsBJ0z6tSuyiTRiQcbDAs3YH5TjQdNO6ZVJIT7YMhVS/lwY9m0dPRdY4h2ZncDk6UPE8qsKrUEql9YFdSv2trbsXRfuyfdMtexDBdZpTAL4G0kdNacW7YJRcn+B0X9/onqzvGqgAAAABJRU5ErkJggg==" />