threejs多面体贴图加纹理,貌似只改变了颜色,求大神指点! 40C
  // 鼠标点击
    var outlineMesh;
    document.addEventListener("mousedown", onDocumentMouseDown, false);

    init();
    animate();

    function init() {
        scr();
       objects();
        lights();
        addfloor();
        others();
    }
 //   var scene = new THREE.Scene();

    // create a camera, which defines where we're looking at.
 //   var camera = new THREE.PerspectiveCamera(45, window.innerWidth / window.innerHeight, 0.1, 1000);

    function lights() {
        var ambientLight = new THREE.AmbientLight(0xffffff, 0.3);
        scene.add(ambientLight);


        var pointLight = new THREE.PointLight(0xffffff, 0.1);
      //  scene.add(pointLight);

     //   var camera = new THREE.PerspectiveCamera(45, window.innerWidth / window.innerHeight, 0.1, 1000);
        var pointLight = new THREE.PointLight(0xffffff, 1);
        // scene.add(pointLight);
        camera.add(pointLight);
    }



    function objects() {
    //  loadcontainer();
        addHospital()
    }

    function addHospital() {
        var hospital = createHospital()
     //   hospital.position.y = 20
        scene.add(hospital)
    }



    function createHospital() {
        var hospital = new THREE.Object3D()
        var frontMainCoords = [
           [0, -20],
           [-30, 0],

           [0, 20],
           [30, 0],

        ]
        var frontMainShape = utils.makeShape(frontMainCoords)
        var frontMainGeometry = utils.makeExtrudeGeometry(frontMainShape, 20)
        var frontMainMaterial = new THREE.MeshPhongMaterial({ map: textures.window() })
  //      var phongmaterial = new THREE.MeshPhongMaterial({color: 0x677784, transparent: true, opacity: 0.85});
  //      var phongmes = new THREE.Mesh(frontMainMaterial, phongmaterial);
        frontMainMaterial.map.repeat.set(0.1, 0.04)

        var alldate = []

        //楼层总列表
        for(var i=0;i<6;i++){

            /*  var frontMain = new THREE.Mesh(frontMainGeometry, frontMainMaterial)
              hospital.add(frontMain)
               renderScene()*/
            var obj = "sta"+i;
            alldate.push(obj)
        }

        var layerList1 = []
        var layerList2 = []

        for(var j=0;j<5;j++){
            var onedata = new THREE.Mesh(frontMainGeometry, frontMainMaterial);
        //  var onedata =createMesh(frontMainGeometry, "stone.jpg");

            hospital.add(onedata);
            layerList1.push(onedata)

        }
        for(var j=5;j<alldate.length;j++){
       //   var onedata =createMesh(frontMainGeometry, "stone.jpg");
            var onedata = new THREE.Mesh(frontMainGeometry, frontMainMaterial);
            hospital.add(onedata);
            layerList2.push(onedata)
        }

        function createMesh(geom, imageFile) {
            //  var texture = 


                var mat = new THREE.MeshPhongMaterial();
                mat.normalMap = new THREE.TextureLoader().load("/seismis/js/3djs/assets/textures/general/" + imageFile);
        //      mat.specular = new THREE.Color(0xffffff);
                mat.needsUpdate = true;
                mat.shininess = 10;
                var mesh = new THREE.Mesh(geom, mat);
                return mesh;
            }
            //中间立体图形
    //  var polyhedron1 = createMesh(cubeGeometry, "stone.jpg");



        renderScene();
        var step1 = 0;
        var step2 = 0;
        function renderScene() {
            step1 += 0.1;
            for(var i=0;i<layerList1.length;i++){
                var frontMain = layerList1[i];
                frontMain.position.x = 0 + ( (2+i) * (Math.cos(step1)));
                frontMain.position.y = 0+i*20 + ( 2 * Math.abs(Math.sin(step1)));
                frontMain.position.z = 0 + ( (2+i) * (Math.cos(step1)));

            }
            step2 += 0.1;
            for(var k=0;k<(layerList2.length);k++){
                var frontMain = layerList2[k];
                frontMain.position.x = 0 + ( (2+k+5) * (Math.cos(step2)));
                frontMain.position.y = 0+(k+5)*20 + ( 2 * Math.abs(Math.sin(step2)));
                frontMain.position.z = 0 + ( (2+k+5) * (Math.cos(step2)));

            }


          requestAnimationFrame(renderScene);
          renderer.render(scene, camera);
        }



        // call the render function
        var step = 0;

        initModel()
        function initModel() {
            //辅助工具
            var helper = new THREE.AxisHelper(10);
            scene.add(helper);
            var cubeGeometry = new THREE.Geometry();
            //创建立方体的顶点
            var vertices = [
                new THREE.Vector3(0, 0, 20), //v0
                new THREE.Vector3(30, 0, 0), //v1
                new THREE.Vector3(0, 0,-20), //v2
                new THREE.Vector3(-30, 0, 0), //v3
                new THREE.Vector3(-30,220,0), //v4
                new THREE.Vector3(-22,220,10), //v5
                new THREE.Vector3(22,220,10), //v6
                new THREE.Vector3(30,220,0), //v7
                new THREE.Vector3(22,220,-10), //v8
                new THREE.Vector3(-22,220,-10), //v9
            ];
            cubeGeometry.vertices = vertices;
            //创建立方的面
            var faces=[
                new THREE.Face3(0,1,2),
                new THREE.Face3(0,2,3),
                new THREE.Face3(3,0,5),
                new THREE.Face3(3,5,4),
                new THREE.Face3(3,4,9),
                new THREE.Face3(3,9,2),
                new THREE.Face3(2,9,8),
                new THREE.Face3(8,1,2),
                new THREE.Face3(8,7,1),
                new THREE.Face3(6,1,7),
                new THREE.Face3(6,0,1),
                new THREE.Face3(0,6,5),
                new THREE.Face3(5,6,7),
                new THREE.Face3(5,7,8),
                new THREE.Face3(5,8,9),
                new THREE.Face3(5,9,4),

            ];
            cubeGeometry.faces = faces;
            //生成法向量
            cubeGeometry.computeFaceNormals();




            function createMesh(geom, imageFile) {
            //  var texture = 
                var mat = new THREE.MeshPhongMaterial();
                mat.map = new THREE.TextureLoader().load("/seismis/js/3djs/assets/textures/general/" + imageFile);
        //      mat.specular = new THREE.Color(0xffffff);
                mat.needsUpdate = true;
                mat.shininess = 10;
                var mesh = new THREE.Mesh(geom, mat);
                return mesh;
            }



            //中间立体图形
        //  var polyhedron1 = createMesh(cubeGeometry, "stone.jpg");

        //  scene.add(polyhedron1);

        /*  var frontMainMaterial = new THREE.MeshPhongMaterial({ map: textures.window() })
             frontMainMaterial.map.repeat.set(0.01, 0.04)*/

            var polyhedron1 = createMesh(cubeGeometry, "bathroom-normal.jpg");
            polyhedron1.position.x = 0;
            polyhedron1.position.y = 120;
            polyhedron1.position.z = 0;
            scene.add(polyhedron1);


   /*          var textureLoader = new THREE.TextureLoader();

               textureLoader.load( "/seismis/js/3djs/assets/textures/general/bathroom-normal.jpg", function( texture ){
                   // 加载法向贴图
                   textureLoader.load("/seismis/js/3djs/assets/textures/general/bathroom-normal.jpg", function( normalTexture ){
                       var geometry = new THREE.BoxGeometry( 50, 50, 50 );

                       var material = new THREE.MeshBasicMaterial({
                           map: texture, 
                           normalMap: normalTexture // 只要将法向贴图赋给材质的normalMap属性即可
                       });
                       mesh = new THREE.Mesh( geometry, material );
                       scene.add( mesh );
                   } );
               });*/


            //12面体
        /*     var frontMainMaterial = new THREE.MeshPhongMaterial({ map: textures.window() })
               var polyhedron2 = new THREE.Mesh(new THREE.IcosahedronGeometry(150, 0), frontMainMaterial);
        //    var polyhedron2 = createMesh(new THREE.IcosahedronGeometry(50, 0), "stone.jpg");
            polyhedron2.position.x = 112;
            scene.add(polyhedron2);*/


            var cubeGeometry1 = new THREE.Geometry();
            //创建立方体的顶点
            var vertices = [
                new THREE.Vector3(-30,0,0), //v4    0 
                new THREE.Vector3(-22,0,10), //v5   1
                new THREE.Vector3(-22,0,-10), //v9  2
                new THREE.Vector3(-30,35,0) //v10   3
            ];
            cubeGeometry1.vertices = vertices;
            //创建立方的面
            var faces=[
                new THREE.Face3(0,1,3),
                new THREE.Face3(3,2,0),
                new THREE.Face3(2,0,1),
                new THREE.Face3(1,2,3)

            ];
            cubeGeometry1.faces = faces;
            //生成法向量
            cubeGeometry1.computeFaceNormals();
            var cubeMaterial = new THREE.MeshLambertMaterial({color: 0x6a5e74});
            cube = new THREE.Mesh(cubeGeometry1, cubeMaterial);
            cube.position.x = 0;
            cube.position.y = 340;
            cube.position.z = 0;
            scene.add(cube);

            var cubeGeometry2 = new THREE.Geometry();
            //创建立方体的顶点
            var vertices = [
                new THREE.Vector3(30,0,0), //v7    0 
                new THREE.Vector3(22,0,10), //v6   1
                new THREE.Vector3(22,0,-10), //v8  2
                new THREE.Vector3(30,35,0) //v11    3
            ];
            cubeGeometry2.vertices = vertices;
            //创建立方的面
            var faces=[

               new THREE.Face3(0,2,1),
               new THREE.Face3(2,1,3),
               new THREE.Face3(3,1,0),
               new THREE.Face3(3,0,2),

            ];
            cubeGeometry2.faces = faces;
            //生成法向量
            cubeGeometry1.computeFaceNormals();
            var cubeMaterial = new THREE.MeshLambertMaterial({color: 0x6a5e74});
            cube2 = new THREE.Mesh(cubeGeometry2, cubeMaterial);
            cube2.position.x = 0;
            cube2.position.y = 340;
            cube2.position.z = 0;
            scene.add(cube2);


            //顶部
            var cubeGeometry3 = new THREE.Geometry();
            //创建立方体的顶点
            var vertices = [
                new THREE.Vector3(-27,0,4), //    0 
                new THREE.Vector3(-27,0,-4), //   1
                new THREE.Vector3(-30,11,0), //  2
                new THREE.Vector3(30,11,0), //  3
                new THREE.Vector3(27,0,4), //    4
                new THREE.Vector3(27,0,-4), //    5 


            ];
            cubeGeometry3.vertices = vertices;
            //创建立方的面
            var faces=[

               new THREE.Face3(0,2,1),
               new THREE.Face3(1,2,3),
               new THREE.Face3(1,3,5),
               new THREE.Face3(3,2,0),
               new THREE.Face3(3,0,4),
               new THREE.Face3(3,4,5),


            ];
            cubeGeometry3.faces = faces;
            //生成法向量
            cubeGeometry1.computeFaceNormals();
            var cubeMaterial = new THREE.MeshLambertMaterial({color: 0x6a5e74});
            cube2 = new THREE.Mesh(cubeGeometry3, cubeMaterial);
            cube2.position.x = 0;
            cube2.position.y = 364;
            cube2.position.z = 0;
            scene.add(cube2);


        }

        function render() {
      //    stats.update();
            polyhedron.rotation.y = step += 0.01;

            // render using requestAnimationFrame
            requestAnimationFrame(render);
            webGLRenderer.render(scene, camera);
        }      


        return hospital
      }

    function createWindow() {
        var windowObj = new THREE.Object3D()
        var glassGeometry = new THREE.PlaneGeometry(20, 20)
        var glass = utils.makeMesh('phong', glassGeometry, 0x6a5e74)
        windowObj.add(glass)

        var windowBorderGeometry = new THREE.BoxBufferGeometry(22, 2, 2)
        var windowBorder = utils.makeMesh('phong', windowBorderGeometry, 0xffffff)

        var windowBorderTop = windowBorder.clone()
        windowBorderTop.position.y = 10
        windowObj.add(windowBorderTop)

        var windowBorderBottom = windowBorder.clone()
        windowBorderBottom.position.y = -10
        windowObj.add(windowBorderBottom)

        var windowBorderLeft = windowBorder.clone()
        windowBorderLeft.rotation.z = 0.5 * Math.PI
        windowBorderLeft.position.x = -10
        windowObj.add(windowBorderLeft)

        var windowBorderRight = windowBorderLeft.clone()
        windowBorderRight.position.x = 10
        windowObj.add(windowBorderRight)

        return windowObj
      }


    function loadcontainer() {
        var onProgress = function (xhr) {
            if (xhr.lengthComputable) {
                var percentComplete = xhr.loaded / xhr.total * 100;
                console.log(Math.round(percentComplete, 2) + '% downloaded');
            }
        };

        var onError = function (xhr) {
        };
        var mtlLoader = new THREE.MTLLoader();
        mtlLoader.load('/seismis/js/js/objs/5.mtl', function (materials) {
            materials.preload();
            var loader = new THREE.OBJLoader();
            loader.setMaterials(materials);

            loader.load('/seismis/js/js/objs/5.obj', function (object) {
                object.traverse(function (child) {
                    if (child instanceof THREE.Mesh) {
                        child.material.transparent = true;
                        child.material.opacity = 1;
                        if (child.material instanceof Array) {
                            for (var i = 0, length = child.material.length; i < length; i++)
                                child.material[i].transparent = true;
                        }
                    }
                });
            //    for (var i = 0; i < 3; i++) {

                    var temp = object.clone();
            //        temp.position.set(-100 + 300 * i, 150, 0);
                    temp.position.set(0 , 0, 0);
                    scene.add(temp);
            //    }
            }, onProgress, onError);
        })


    }

    function loadmale1() {
        var onProgress = function (xhr) {
            if (xhr.lengthComputable) {
                var percentComplete = xhr.loaded / xhr.total * 100;
                console.log(Math.round(percentComplete, 2) + '% downloaded');
            }
        };

        var onError = function (xhr) {
        };

        THREE.Loader.Handlers.add(/\.dds$/i, new THREE.DDSLoader());

        var mtlLoader = new THREE.MTLLoader();
        mtlLoader.setPath('/seismis/js/js/objs/male02/');
        mtlLoader.load('male02.mtl', function (materials) {
            console.log(materials);
            materials.preload();

            var objLoader = new THREE.OBJLoader();
            objLoader.setMaterials(materials);
            objLoader.setPath('/seismis/js/js/objs/male02/');
            objLoader.load('male02.obj', function (object) {

                object.position.y = 10;
                scene.add(object);

            }, onProgress, onError);

        });
    }

    // 没有考虑group,所以通过obj加载的物体无法点选
    function getMeshs() {
        var meshs = [];
        for (var i = 0, length = scene.children.length; i < length; i++) {
            if (scene.children[i] instanceof THREE.Mesh && scene.children[i].geometry instanceof THREE.BoxGeometry) {
                meshs.push(scene.children[i]);
            }
        }
        return meshs;
    }

    function onDocumentMouseDown(e) {
        e.preventDefault();
        rotate = false;
        //将鼠标点击位置的屏幕坐标转成threejs中的标准坐标,具体解释见代码释义
        var mouse = {};
        mouse.x = (e.clientX / window.innerWidth) * 2 - 1;
        mouse.y = -(e.clientY / window.innerHeight) * 2 + 1;
        //新建一个三维单位向量 假设z方向就是0.5
        //根据照相机,把这个向量转换到视点坐标系
        var vector = new THREE.Vector3(mouse.x, mouse.y, 0.5).unproject(camera);
        console.log(vector);
        var sub = vector.sub(camera.position);
        console.log(sub);
        var param2 = sub.normalize();
        var raycaster = new THREE.Raycaster(camera.position, param2);
        console.log("---------------------------------------------");

        //射线和模型求交,选中一系列直线
        var intersects = raycaster.intersectObjects(getMeshs());

        if (intersects.length > 0) {
            //选中第一个射线相交的物体
            scene.remove(outlineMesh);
            var SELECTED = intersects[0].object;
            var outlineMaterial2 = new THREE.MeshBasicMaterial({color: 0x00ff00, side: THREE.BackSide});
            outlineMesh = new THREE.Mesh(SELECTED.geometry.clone(), outlineMaterial2);
            outlineMesh.position.set(SELECTED.position.x, SELECTED.position.y, SELECTED.position.z);
            outlineMesh.scale.multiplyScalar(1.05);
            scene.add(outlineMesh);
        }

    }

1个回答

贴图的纹理路径是否设置正确了?

qq_41103448
qq_41103448 同意
大约一年之前 回复
fantasy1231
習慣沉默123 正确
大约一年之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
opengl中给球体贴纹理的问题
在球体贴图时,如果用一张纹理图,按两个参数贴,在球体的两极会有很大的扭曲现象,怎样才能消除这种现象?rn 我想可不可以用6张纹理图贴,在上、下、左、右、前、后方向各贴一张,可具体怎么实现还是不太清楚
求大神指点 求大神指点
a表按照b表的规则转换到c表上去rnrnrna表按照b表的规则转换到c表上去rnrnrnrnUSE [erp_zfym]rnGOrn/****** 对象: Table [dbo].[TB_DataPlat] 脚本日期: 08/26/2013 11:23:26 ******/rnSET ANSI_NULLS ONrnGOrnSET QUOTED_IDENTIFIER ONrnGOrnSET ANSI_PADDING ONrnGOrnCREATE TABLE [dbo].[TB_DataPlat](rn [DataID] [int] NOT NULL,rn [PFKID] [int] NULL,rn [UseType] [int] NULL,rn [DataSign] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,rn [Data] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data1] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data2] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data3] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data4] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data5] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data6] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data7] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data8] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data9] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data10] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data11] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data12] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data13] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data14] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data15] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data16] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data17] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data18] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data19] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data20] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data21] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data22] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data23] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data24] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data25] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data26] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data27] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data28] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data29] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data30] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data31] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data32] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data33] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data34] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data35] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data36] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data37] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data38] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data39] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data40] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data41] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data42] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data43] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data44] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data45] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data46] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data47] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data48] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data49] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data50] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data51] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data52] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data53] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data54] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data55] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data56] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data57] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data58] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data59] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data60] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data61] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data62] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data63] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data64] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data65] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data66] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data67] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data68] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data69] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data70] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data71] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data72] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data73] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data74] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data75] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data76] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data77] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data78] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data79] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data80] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data81] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data82] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data83] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data84] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data85] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data86] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data87] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data88] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data89] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data90] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data91] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data92] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data93] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data94] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data95] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data96] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data97] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data98] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data99] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn [Data100] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,rn CONSTRAINT [PK_TB_DataPlat] PRIMARY KEY CLUSTERED rn(rn [DataID] ASCrn)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]rn) ON [PRIMARY]rnrnGOrnSET ANSI_PADDING OFFrnrnrnrnUSE [erp_zfym]rnGOrn/****** 对象: Table [dbo].[PP_CraftData] 脚本日期: 08/26/2013 11:24:04 ******/rnSET ANSI_NULLS ONrnGOrnSET QUOTED_IDENTIFIER ONrnGOrnSET ANSI_PADDING ONrnGOrnCREATE TABLE [dbo].[PP_CraftData](rn [CraftDataID] [int] IDENTITY(1,1) NOT NULL,rn [DataPlatID] [int] NULL,rn [CraftID] [int] NULL,rn [ProcessID] [int] NULL,rn [GoodsID] [int] NULL,rn [ProductID] [int] NULL,rn [ProductCode] [varchar](60) COLLATE Chinese_PRC_CI_AS NULL,rn [Machine] [int] NULL,rn [StandardValue] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,rn [Remark] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,rn [OrderNO] [int] NULL,rn [Flag] [char](1) COLLATE Chinese_PRC_CI_AS NULL,rn [RelateID] [int] NULL,rn [ParentID] [int] NULL,rn [OpID] [int] NULL,rn [OpDate] [datetime] NULL,rn [CraftType] [int] NULL,rn CONSTRAINT [PK_PP_CraftData] PRIMARY KEY CLUSTERED rn(rn [CraftDataID] ASCrn)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]rn) ON [PRIMARY]rnrnGOrnSET ANSI_PADDING OFFrnrnUSE [erp_zfym]rnGOrn/****** 对象: Table [dbo].[PP_CraftDataProperty] 脚本日期: 08/28/2013 09:49:06 ******/rnSET ANSI_NULLS ONrnGOrnSET QUOTED_IDENTIFIER ONrnGOrnSET ANSI_PADDING ONrnGOrnCREATE TABLE [dbo].[PP_CraftDataProperty](rn [CraftDataProID] [char](10) COLLATE Chinese_PRC_CI_AS NULL,rn [CraftDataID] [int] NULL,rn [DataPlatID] [int] NULL,rn [DataPFKID] [int] NULL,rn [CraftID] [int] NULL,rn [RowSign] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,rn [ProID] [int] NULL,rn [Data] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,rn [Type] [int] NULL,rn [UseType] [int] NULL,rn [ProType] [int] NULL,rn [RateType] [int] NULL,rn [Rate] [decimal](10, 4) NULL,rn [Formula] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,rn [remark] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,rn [OrderNO] [int] NULL,rn [Flag] [char](1) COLLATE Chinese_PRC_CI_AS NULL,rn [DeletedFlg] [char](1) COLLATE Chinese_PRC_CI_AS NULL,rn [OpID] [int] NULL,rn [OpDate] [datetime] NULLrn) ON [PRIMARY]rnrnGOrnSET ANSI_PADDING OFFrnrnrnrnrnrn哪位大神能给个建议 或思路呀 没有多少分了 见谅
threejs(三) 光源,材质,纹理
光源 光源基类 THREE.Light ( hex ) 由基类派生出来的其他种类光源 THREE.AmbientLight( hex ) ,当仅为场景指定环境光时,所有的物体无论法向量如何,都将表现为同样的明暗程度 PointLight( color, intensity, distance ) Color:光的颜色 Intensity:光的强度,默认是1.0,就是说是100%强度的灯光
pictureBox里图片颜色改变了???怎么办???
一幅图片背景颜色是EF,EF,EFrn把他设为pictureBox的Image以后,背景颜色明显失真,变成了F7,F3,F7rnrn怎么办?让他不要出现这种偏差?
WEBGL学习【九】立方体贴不同的纹理
&lt;html&gt; &lt;!--开始实现一个三维街景的渲染效果--&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8"&gt; &lt;title&gt;NeHeWebGL----环境光(光照模型)&lt;/title&gt; &lt;meta...
求大神指点指点!
我现在用asp.net 写一个采集。 rnrn有300多个城市 每个城市基本都有2400多条数据。rnrn我想采集起来快一点。 请问有什么好的办法吗!rnrn因为中间还要分析页面上的数据。采集图片等等。 所以速度相对比较慢rnrn那位大神能给点这样的思路或者代码。rn
求大神指点指点
我的是Ubuntu18.04系统;rn里面有docker,我想要把容器挂载到宿主机,报错“mount.nfs: access denied by server while mounting 192.168.0.1:/nfsdisk/”rn请大神们指点一下,这个问题怎么解决;
Threejs开发笔记之十纹理
什么是纹理 纹理就是为网格上每个像素指定颜色基本纹理使用function createMesh(geom, imageFile) { var texture = THREE.ImageUtils.loadTexture("../assets/textures/general/" + imageFile); var mat = new THREE.MeshPhongMaterial(); mat.m
git改变了ant的build文件路径。求指点。
在使用ant将git控制的项目copy到tomcat中的时候,rn控制台打印出来的拷贝路径是:rn[color=#0000FF][copy] Copying 1 file to E:\gitresource\test\test\build\E\:apache-tomcat-6.0.30\conf[/color]rn其中[color=#3366FF]E:\gitresource\test\test\build\[/color]是我的git本地库中的项目下装载ant文件的路径...我要如何去除这段路径呢?rn对git和ant了解尚浅,未能找到合适的网络资源,到此求助。rnrn以下是ant的配置文件:rn[b][color=#000080]build.properties[/color][/b]rn[code=text]rn#项目名rnproject.name=testrn#tomcat服务器配置rntomcat.dir=E\\:apache-tomcat-6.0.30rntomcat.home=$tomcat.dirrnrnlibrary.dir=../../Libraryrnjar.dir.name=testrnlib.dir=$tomcat.home/lib/$jar.dir.namern[/code]rn[b][color=#000080]TestCopyLib.xml[/color][/b]rn[code=html]rnrnrnrnrnrn rnrn rn rn rn rn rn rn rnrn rn rn rnrn rn rn rn rn rn rn ... ... rn rn rn rn rn rn rn rn rn rn rn rn ... ...rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rnrn[/code]
求大神改代码!!!!
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>n<%@page import="util.Info"%>n<%@page import="dao.CommDAO"%>n<%@page import="util.PageManager"%>nn n 话题信息n n n nnn n 已有话题信息列表:n n 搜索: 标题:n nnn list = PageManager.getPages(url,15,sql, request); n int i=0;n for(HashMap map:list) n i++;n n nnn %>n n n 序号n 标题n n 添加人n n 评论管理n 添加时间n n 操作n n <% n nnn new CommDAO().delete(request,"huatixinxi"); n String url = "huatixinxi_list.jsp?1=1"; n String sql = "select * from huatixinxi where 1=1";n nif(request.getParameter("biaoti")=="" ||request.getParameter("biaoti")==null )elsesql=sql+" and biaoti like '%"+request.getParameter("biaoti")+"%'";n sql+=" order by id desc";n ArrayList n <%=i %>n <%=map.get("biaoti") %>n n <%=map.get("tianjiaren") %>n n &biao=huatixinxi">评论管理n <%=map.get("addtime") %>n " onClick="return confirm('真的要删除?')">删除 ">详细 n n <%n n %>nn n n$page.info nnn nnn删除那加一个判断语句,如果是‘’超级管理员‘’执行删除,否则提示“您没有此权限”n这是我自己 弄得不行,可以参考一下:n<% request.getSession().getAttribute("cx").equals("管理员"))%>" onClick="return confirm('真的要删除?')">删除 <%%>n我不懂写代码,最好能给我对的能实现的代码,谢谢。
求大神帮忙指点指点。
rn 现在碰到如下问题 、 需要查询几个平台下的全部店铺 (一个平台下有若干个店铺) 、使用如下语句 。rnrn[code=sql]rnSELECTrn `paipai_shop`.`sellerUin` AS `shopId`,rn `paipai_shop`.`shopName` AS `shopName`rnFROMrn `paipai_shop`rnUNION ALLrn SELECTrn `dangdang_shop`.`id` AS `shopId`,rn `dangdang_shop`.`shopName` AS `shopName`rn FROMrn `dangdang_shop`rn UNION ALLrn SELECTrn `vjia_shop`.`id` AS `shopId`,rn `vjia_shop`.`shopName` AS `shopName`rn FROMrn `vjia_shop`rn UNION ALLrn SELECTrn `amazon_shop`.`id` AS `shopId`,rn `amazon_shop`.`shopName` AS `shopName`rn FROMrn `amazon_shop`rn UNION ALLrn SELECTrn `taobao_shop`.`shopId` AS `shopId`,rn `taobao_shop`.`nick` AS `shopName`rn FROMrn `taobao_shop`rn UNION ALLrn SELECTrn `jingd_shop`.`shopId` AS `shopId`,rn `jingd_shop`.`shopName` AS `shopName`rn FROMrn `jingd_shop`rn UNION ALLrn SELECTrn `yhd_shop`.`shopId` AS `shopId`,rn `yhd_shop`.`shopName` AS `shopName`rn FROMrn `yhd_shop`[/code]rn 查询出来后 、 因为不同平台下的店铺可能有相同的 shopId 、 导致页面上相同shopid的店铺只显示一个条数据 。 求有无解决方法 。 rn rn rn 我曾经尝试给不同平台下的店铺shopid 后面 拼接 数字 譬如 :[color=#FF0000]`yhd_shop`.`shopId`+0[/color] AS `shopId` 结果 没有用 。哪位大神给个解决方法?
D3D 粘贴纹理后,后续绘制的多边形的颜色变了
在程序中我先粘贴了一幅纹理,可是后来再绘制多边形时发现显示的颜色与程序中设定的颜色不一样了。后经分析发现是某个渲染状态改变了。所以我在粘贴纹理前保存了状态块,粘贴纹理后在恢复状态块并绘制后续的多边形,显示的颜色就正确了。rnrn问题是到底是哪个(或哪些)状态被改变了?rnrn程序中未进行光照处理,纹理创建是:rnD3DXCreateTextureFromFileEx(g_pd3dDevice, rn L"image01.bmp",rn D3DX_DEFAULT_NONPOW2,rn D3DX_DEFAULT_NONPOW2,rn D3DX_FROM_FILE,rn 0,rn D3DFMT_UNKNOWN,rn D3DPOOL_MANAGED,rn D3DX_FILTER_NONE,rn D3DX_DEFAULT,rn 0,rn NULL,rn NULL,rn &g_pTexture );
求教:OpenGL加载纹理时怎么改变了其它图元的颜色?
在背景上画了一些白色线条,然后加载了一个黄色的纹理图像,结果发现我的白色背景线条都变成黄色的了。怎么回事?谢谢。
屏幕显示方向改变了,求大虾帮忙
显示器变方向了,不知怎搞的我的显示器要转一个方向才能看得顺眼,也就是说正常显示是水平方向,从左到右。现在变了,必须把显示器底脚那一边转到侧边才能正常看屏幕。
求大神指点哈
这个错误一直循环,怎么回事哦,能运行的项目都运行不起了,空项目都不能运行rn03-15 16:16:52.884 23816-23816/? A/Looper: Thread identity changed from 0x276000004fcf to 0x276000005d08 while dispatching to android.os.Handler com.qihoo.appstore.e@2ef8850e what=0rn03-15 16:16:52.886 23816-23816/? E/JavaBinder: !!! FAILED BINDER TRANSACTION !!!rn03-15 16:16:52.889 23816-23816/? E/ServiceManager: error in getServicern android.os.TransactionTooLargeExceptionrn at android.os.BinderProxy.transactNative(Native Method)rn at android.os.BinderProxy.transact(Binder.java:509)rn at android.os.ServiceManagerProxy.getService(ServiceManagerNative.java:123)rn at android.os.ServiceManager.getService(ServiceManager.java:55)rn at android.app.ActivityManagerNative$1.create(ActivityManagerNative.java:2503)rn at android.app.ActivityManagerNative$1.create(ActivityManagerNative.java:2501)rn at android.util.Singleton.get(Singleton.java:34)rn at android.app.ActivityManagerNative.getDefault(ActivityManagerNative.java:91)rn at com.android.internal.os.RuntimeInit.wtf(RuntimeInit.java:399)rn at android.util.Log$1.onTerribleFailure(Log.java:104)rn at android.util.Log.wtf(Log.java:294)rn at android.util.Log.wtf(Log.java:256)rn at android.os.Looper.loop(Looper.java:220)rn at android.os.HandlerThread.run(HandlerThread.java:61)rn03-15 16:16:52.894 23816-23816/? E/AndroidRuntime: Error reporting WTFrn java.lang.NullPointerException: Attempt to invoke interface method 'boolean android.app.IActivityManager.handleApplicationWtf(android.os.IBinder, java.lang.String, boolean, android.app.ApplicationErrorReport$CrashInfo)' on a null object referencern at com.android.internal.os.RuntimeInit.wtf(RuntimeInit.java:399)rn at android.util.Log$1.onTerribleFailure(Log.java:104)rn at android.util.Log.wtf(Log.java:294)rn at android.util.Log.wtf(Log.java:256)rn at android.os.Looper.loop(Looper.java:220)rn at android.os.HandlerThread.run(HandlerThread.java:61)rn03-15 16:16:52.895 23816-23816/? E/AndroidRuntime: Original WTF:rn android.util.Log$TerribleFailure: Thread identity changed from 0x276000004fcf to 0x276000005d08 while dispatching to android.os.Handler com.qihoo.appstore.e@2ef8850e what=0rn at android.util.Log.wtf(Log.java:291)rn at android.util.Log.wtf(Log.java:256)rn at android.os.Looper.loop(Looper.java:220)rn at android.os.HandlerThread.run(HandlerThread.java:61)rn03-15 16:16:53.188 23814-23814/? A/Looper: Thread identity changed from 0x276000004fcf to 0x276000005d06 while dispatching to android.os.Handler com.qihoo.appstore.e@2ef8850e what=0rn03-15 16:16:53.189 23814-23814/? E/JavaBinder: !!! FAILED BINDER TRANSACTION !!!rn03-15 16:16:53.191 23814-23814/? E/ServiceManager: error in getServicern android.os.TransactionTooLargeExceptionrn at android.os.BinderProxy.transactNative(Native Method)rn at android.os.BinderProxy.transact(Binder.java:509)rn at android.os.ServiceManagerProxy.getService(ServiceManagerNative.java:123)rn at android.os.ServiceManager.getService(ServiceManager.java:55)rn at android.app.ActivityManagerNative$1.create(ActivityManagerNative.java:2503)rn at android.app.ActivityManagerNative$1.create(ActivityManagerNative.java:2501)rn at android.util.Singleton.get(Singleton.java:34)rn at android.app.ActivityManagerNative.getDefault(ActivityManagerNative.java:91)rn at com.android.internal.os.RuntimeInit.wtf(RuntimeInit.java:399)rn at android.util.Log$1.onTerribleFailure(Log.java:104)rn at android.util.Log.wtf(Log.java:294)rn at android.util.Log.wtf(Log.java:256)rn at android.os.Looper.loop(Looper.java:220)rn at android.os.HandlerThread.run(HandlerThread.java:61)rn03-15 16:16:53.195 23814-23814/? E/AndroidRuntime: Error reporting WTFrn java.lang.NullPointerException: Attempt to invoke interface method 'boolean android.app.IActivityManager.handleApplicationWtf(android.os.IBinder, java.lang.String, boolean, android.app.ApplicationErrorReport$CrashInfo)' on a null object referencern at com.android.internal.os.RuntimeInit.wtf(RuntimeInit.java:399)rn at android.util.Log$1.onTerribleFailure(Log.java:104)rn at android.util.Log.wtf(Log.java:294)rn at android.util.Log.wtf(Log.java:256)rn at android.os.Looper.loop(Looper.java:220)rn at android.os.HandlerThread.run(HandlerThread.java:61)rn03-15 16:16:53.196 23814-23814/? E/AndroidRuntime: Original WTF:rn android.util.Log$TerribleFailure: Thread identity changed from 0x276000004fcf to 0x276000005d06 while dispatching to android.os.Handler com.qihoo.appstore.e@2ef8850e what=0rn at android.util.Log.wtf(Log.java:291)rn at android.util.Log.wtf(Log.java:256)rn rn
求大神指点!谢谢
[img=https://img-bbs.csdn.net/upload/201312/10/1386654407_153499.jpg][/img]我想实现如图中间游戏房间那一块界面。但是还差点什么呢?求大神指点,label button上的图片还没加上去rn程序如下:rnimport javax.swing.JButton;rnimport javax.swing.JFrame;rnimport javax.swing.JLabel;rnrnpublic class ScendGui extends JFrame rn private static int num = 1;rn private int jb_size=40;rn private int jl_size=45;rn private int fgap = 20;//行间隔rn private int fgap2 = 20;//列间隔rn private int rgap = 35;//两房间间隔rn private int mgap =2*jb_size+jl_size+rgap; //两桌子间隔rn private int fjb2gap = fgap+jl_size+jb_size;//jb2的首距离rn private int fjlgap = fgap+jl_size; //jl的首距离rn public ScendGui(String s)rn super(s);rn rn this.setLocation(100, 100);rn this.setSize(600, 600);rn for(int i = 1;i<=5;i++)rn for(int j= 0;j<=2;j++)rn rn JButton jb1= new JButton("椅子");rn jb1.setBounds(fgap+j*mgap, fgap2, jb_size, jb_size);rn JButton jb2= new JButton("椅子"); rn jb2.setBounds(fjb2gap+j*mgap, fgap2, jb_size, jb_size);rn JLabel jl= new JLabel("桌子");rn jl.setBounds(fjlgap+j*mgap, fgap2,jl_size, jl_size);rn String str = Integer.toString(num); rn JLabel label = new JLabel("-"+str+"-");rn num = Integer.parseInt(str);rn label.setBounds(mgap/2+j*mgap, 2*jb_size, 20, 20);rn this.add(jb1);rn this.add(jb2);rn this.add(jl);rn this.add(label);rn rn num++;rn fgap2 = (fgap2+2*jb_size)*i+20;rn rn this.setVisible(true);rn rn rn rn public static void main(String[] args) rn new ScendGui("游戏大厅");rnrn rnrnrn
SOS,求大神指点
我想在网站首页上放一个JS,动态捕获国际油价,铜价,请问怎么实现?
求大神指点
下面是迷宫寻找路径的方法,用的堆栈存储结构,要把堆栈的变化显示在下面的图形界面上,该怎么办啊[img=http://img.my.csdn.net/uploads/201303/01/1362135323_7628.jpg][/img][img=http://img.my.csdn.net/uploads/201303/01/1362135480_8689.jpg][/img][img=http://img.my.csdn.net/uploads/201303/01/1362135492_9720.jpg][/img][img=http://img.my.csdn.net/uploads/201303/01/1362135508_5756.jpg][/img]
求大神指点,谢谢!!
#include rnusing namespace std;rnclass Testrnrn int a;rn static int b;rn public:rn Test(int n)rn rn a=n;rn b++;rn rn void Print()rn rn cout<<"a="<
求大神指点????
一个抽奖的需求:rn一等奖1000个,二等奖30万个,三等奖30万个。如何快速的随机抛出一个奖品?我用了数组,把奖品放到数组里面,然后随机抛出一个,这种方式感觉有点慢,需要1到2秒的时间才能得到一个奖品。有没有别的方法,求大神指点?
求大神指点一二
数据库连接rn[code=php]$rs = mysql_query("select id,degree,min,max,prize,v from magic_config");rnwhile($r = mysql_fetch_assoc($rs)) rn $prize_arr[] = $r;rnrnprint_r($prize_arr);[/code]rn看了下 出来的是rnArray ( rn[0] => Array ( [id] => 1 [degree] => 1 [min] => 1 [max] => 5 [prize] => 一等奖 [v] => 1 ) rn[1] => Array ( [id] => 2 [degree] => 122 [min] => 97 [max] => 125 [prize] => 二等奖 [v] => 1 ))rnrn但想要的是 rn$prize_arr = array( rnarray('id'=>1,'degree'=>1,'min'=>1,'max'=>5,'prize'=>'一等奖','v'=>89), rnarray('id'=>2,'degree'=>32,'min'=>7,'max'=>35,'prize'=>'不要灰心','v'=>1)); rn该怎么办?
求android大神指点
这是我实现的仿网易客户端的源码,里面用了fragment,tabhost等,功能已经实现了一大半,rn但是还有个问题一直解决不了,困了我两天了,rn1.就是点击左边隐藏部分不同的位置,然后右边显示到不同的fragment,我一直搞不定rn2.怎么把每一个fragment弄成一个activity,这样自己感觉方便继承自己的BaseActivity,方便管理。rnrn这是下载连接 [url=http://download.csdn.net/detail/agareminder/5219316][/url]rnrn谢谢啦,我这两天特别着急需要,哪个大神搞定了我必有重谢,求发到邮箱,求大神破rn我邮箱visonnum@gmail.comrnqq:894754617 在线等答案
求delphi 的大神指点
用户访问我Web服务器上的ISAPI DLL,可是报告:“Invalid filename"(无效的文件名),然而文件的确存在的。对了,我的数据库在一台Novell 服务器上。这是为什么呢?求指点
新人求大神指点下。。。
请问exec和execute有什么区别吗?rn为什么要加上exec?rn请问有储存过程这方面基础的东西吗?看书看到这里全部都看不懂了rn最后print@sqlStr什么意思呢?
求大神。指点、
select x.* from (Select rownum rowno, z.* from ( rn select a.zhongduanid,rn b.addressname,rn c.display_name as zhongduanxinhao,rn a.zhongduanbianhao,rn a.simkahao,rn a.dengjiriqi,rn a.youxiaoriqi,rn decode(a.zhuangtai, 0, '停用', '正常') as zhuangtai,rn a.zuihouxiugaishijian,rn a.banbenhaorn from t_zhongduan arn left join t_address brn on a.quhuaid = b.addressidrn left join mansys.t_dict_item c on a.zhongduanxinghaodm=CAST(c.fact_value as char(3))rn where 1 = 1 and dict_code='dm_xb'rnrnrn这是我的SQL语句,数据库表里面有个字段 dengjiriqi ,现在我想查的是 dengjiriqi,与服务器上的时间一样的数据。在SQL语句上该怎么改。
求C#大神指点下
打开考生文件夹(D:\Exam\初级会计电算化\XXX)下的“资产负债表-简表.rep”,完成下列操rn作后,将报表以原文件名进行保存rn(1 )设置所有列列宽为3 0rn(2)设置A3、D3单元格文字“宋体、12号、加粗”,垂直居中对齐rnrnrn如题请问大神们,怎么才能读取到这些格式呢
求大神指点一下
$(function()rn //表情rn var tip='表情';rn var table;rn var on=true;rn $('.choice_ul li').eq(0).click(function()rn $('.biaoq').css('display','block');rn table=' ';rn if (on==true)rn for(var i=1; i<=75; i++)rn biaoq = '[/'+tip+i+']';rn table += ' ';rn if( i % 15 == 0 ) table += ' ';rn rn table+='';rn $('.biaoq').append(table);rn rn on=false;rn //下面这一段哪儿出了问题,点击一下添加了[/表情1],点击两下添加了两个[/表情2],继续点击一直都在涨rn $('.biaoq img').click(function()rn var text=$(this).attr('bq');rn rn $('.text_box textarea').append(text);rn rn )rn rn ) rn rn rn )
跟帖,求大神指点
select sysdate from dual 获取的系统时间,这个是获取的年 月 日 时 分 秒。rnrnrn我只想获得 当前时间 的 年月 日 该怎么写 Sql 语句 求大神指点
新手求大神指点
[code=php]rnrnrn rn 无标题文档rnrnrnrnrnrn";rn rn rn if (!is_numeric($_GET["num1"]))rn $a = false;rn $message .= "第一个数必须为数字 ";rn rn rn if ($_GET["num2"]=="")rn $numb = false;rn $message .= "第二个数不能为空 ";rn rn rn if (!is_numeric($_GET["num2"]))rn $b = false;rn $message .= "第二个数必须为数字 ";rn rn if ($a && $b && $numa && $numb)rn $sum = 0;rn switch ($_GET["ysf"])rn case "+" : $sum = $_GET["num1"] + $_GET["num2"];break;rn case "-" : $sum = $_GET["num1"] - $_GET["num2"];break;rn case "x" : $sum = $_GET["num1"] * $_GET["num2"];break;rn case "/" : $sum = $_GET["num1"] / $_GET["num2"];break;rn case "%" : $sum = $_GET["num1"] % $_GET["num2"];break;rn rnrn rn rn rn?>rn rn 计算器rn rn rn rn " size="9" maxlength="9" />rn rn rn >+rn >-rn >xrn >/rn >%rn rn "/>rn rn rn ";rn if ($a && $b && $numa && $numb)rn echo "结果: $_GET['num1'] $_GET['ysf'] $_GET['num2'] = $sum"; rn else rn echo $message;rn rn echo "";rn rn rn ?>rn rnrnrnrnrn[/code]
求文档大神指点
我公司给了我一个功能模块 让我写方案 我不会写啊 希望有文档高手帮我弄一下:rnhttp://hi.csdn.net/attachment/201104/21/9878450_1303355322p60j.jpg.thumb.jpgrnrnhttp://hi.csdn.net/attachment/201104/21/9878450_13033552367U77.jpg.thumb.jpgrnrn求各位大大帮帮我啊 这关系到我能否在这家公司生存 谢谢了rnrn需要这个模块的详细设计 越详细越好
求大神,指点
单位地址rnrn rn rn 单位详址rn rn 单位1 rn rn这是我的代码,单位地址 是通过地址空间获得的,然后自动赋给单位详址,我现在想的是,如何把已经获取单位地址的单位详址再一次赋给 隐藏域单位1里面。
求各位大神指点
本来最近学习java的GUI的图形界面编程,想弄个选课系统,那我需要什么知识点?要有1) 点击班级能以树型结构显示查看班级姓名(类似QQ好友分栏);2)管理员(一名)、选修课老师以及学生,均有登录功能。
求大神 指点解决方案
我想写一个查询的sqlrn需求:rnrnrn 在一张1000w+的表里通过时间来获取一段数据源(D1),然后通过另外的时间段来获取另一段数据(D2),那两团数据做对比,查询去重(手机号)出D1里面 D2不存在的数据rn(细化 :如果D1里有的手机号 然后D2也有 就不显示,D2里有的数据 D1没有 也不显示,就只显示D1里有 D2里没有的数据)rnrn这个是个通过单据记录手机号的表 手机号存在重复 需要去重rn rnrn求大神指点下思路 这个sql该怎么写?
oracle数据库求大神指点
Oracle中修改表结构时约束会被修改吗?
求大神指点一下~
之前学Java,基础还过得去,现在有研究C#,但对Visual Studio2010用的有点陌生,不是很熟,怎样可以学好C#?需要重新看C#基础开始吗?求大牛指点
求版主大神指点
本人想实现网站手机验证,现有接口文件及提供商提供的相关文件。因我的是ASP,使用的是post,该如何直接调用短信接口,并如何建立XML等文件。 求版主大神指点。
求大神指点!
String sql = "select a.id as id,a.title as title,a.sequence as sequence,b.names as departName,c.names as webName from board as a left join department as b on a.depart_id=b.id join web as c on a.web_id=c.id where 1=1";rn这句话什么意思,a.id as id 这是什么意思? join有是什么意思?
求大神指点CH375
rnrn [DllImport("CH375DLL.dll")]rn static extern IntPtr CH375OpenDevice(int i);//初始化rnrn [DllImport("CH375DLL.dll", EntryPoint = "CH375ResetDevice")]rn static extern bool CH375ResetDevice(ulong iIndex );//复位USB设备rnrn [DllImport("CH375DLL.DLL", EntryPoint = "CH375ReadData", ExactSpelling = false, SetLastError = true)]rn public static extern bool CH375ReadData(Int16 iIndex, [MarshalAs(UnmanagedType.LPArray)] byte[] oBuffer, [MarshalAs(UnmanagedType.LPArray)] Int32[] ioLength);//读单片机缓存rnrn [DllImport("CH375DLL.DLL", EntryPoint = "CH375WriteData", ExactSpelling = false, SetLastError = true)]rn public static extern bool CH375WriteData(Int16 iIndex, [MarshalAs(UnmanagedType.LPArray)] byte[] iBuffer, [MarshalAs(UnmanagedType.LPArray)] Int32[] ioLength); //写单片机缓存rnrn [DllImport("CH375DLL.dll", EntryPoint = "CH375CloseDevice")]rn static extern void CH375CloseDevice( // 关闭CH375设备rn ulong iIndex);rnrnrn private void button1_Click(object sender, EventArgs e)rn rn CH375OpenDevice(0);//初始化(0为设备号)rn byte[] str = new byte[20]; //用于开设单片机缓冲区rn Int32[] len = new Int32[1];//读写长度rn len[0] = 20;rnrn rnrn str[0] = 6;str[1] = 4;str[2] = 1;//缓冲区写入值641rn if (CH375WriteData(0, str, len))//写入单片机缓存rn rn //读取刚才写入的数据rn if (CH375ReadData(0, str, len))rn rn string s = str[0].ToString();rn string s2 = str[1].ToString();rn string s3 = str[2].ToString();rn if (s == "6" && s2 == "4" && s3 == "1")rn rn MessageBox.Show("OK");rn rn elsern rn MessageBox.Show("ERROR");rn rn rn rnrn rn rnrn这是网上的那段代码,为什么会在读的时候 死掉了呢?求指点
MVC 求大神指点
小弟刚刚看了几天MVC,有一些地方不是很明白,希望各位帮忙讲解一下。rn(1)MVC的路由机制rnMVC中路由有好几种定义,比如controller/action/id或者reporttype/year/month/day,系统路由设置是放在Global.asax文件中的,,,貌似只能设置一种默认路由吧,一般默认为controller/action/id,一个系统中只能有一个路由定义吗?那如果我打开报表,该怎么打开呢?rn(2)MVC怎么从数据库中已存在的表中读取数据,而不是通过EFCodeFirst方式新增的表。rn(3)我自定义了一个远程验证(Remote Validation),当不满足条件时是可以验证,但是当我保存数据的时候,确没反应。如果把我在Model上把它的特性去掉,就可以保存了。rn代码如下:rn[color=#FF0000]Controller[/color]rn public JsonResult CheckTitleUnqie(string Title)rn rn if (Title.Length > 5)rn rn return Json("标题太长了", JsonRequestBehavior.AllowGet);rn rn elsern rn return Json("",JsonRequestBehavior.DenyGet);rn rn rn[color=#0000FF]下面这个保存方法根本进不来。[/color]rn [HttpPost]rn public ActionResult Edit(Movie model)rn rn var movie = db.Movies.Find(model.ID);rn tryrn rn UpdateModel(movie);rn db.SaveChanges();rn return RedirectToAction("Details", new id = movie.ID );rn rn catch (Exception e)rn rn ModelState.AddModelError("", "修改失败");rn rn return View(movie);rn rnrn[color=#FF0000]Model:[/color]rnpublic class Moviern rn public int ID get; set; rn [Required(ErrorMessage="电影标题不能为空")]rn //[StringLength(10,ErrorMessage="电影标题不能超过10个字符")]rn [Remote("CheckTitleUnqie", "Movie")]rn public string Title get; set; rn public DateTime ResealseDate get; set; rn //[Required(ErrorMessage = "价格不能为空")]rn [Price(ErrorMessage = "价格不合理")]rn //[RegularExpression(@"^(0|1-9\d)$",ErrorMessage="")]rn public float Prices get; set;rn [Required(ErrorMessage = "0不能为空")]rn public string Type get; set; rn rn视图的就不贴了,应该没关系吧。
求大神指点。
我家里的网络这几天突然只能上网聊天看视频,却不能更新软件或者是下载软件。手机和电脑都是这种情况?换了很多地址下载都不行都是安装失败rn求大神给个解决的方案
相关热词 c++和c#哪个就业率高 c# 批量动态创建控件 c# 模块和程序集的区别 c# gmap 截图 c# 验证码图片生成类 c# 再次尝试 连接失败 c#开发编写规范 c# 压缩图片好麻烦 c#计算数组中的平均值 c#获取路由参数