UI5_CRUD 2 App创建

创建SAPUI5 Application

创建Application，并创建XML view，在view1.view.xml的content标签内创建table组件内容

<Table id="idEmployeeTable"
        inset="false"
        items="{
            path: '/DemoSet'
        }">
        <headerToolbar>
            <Toolbar>
                <Title text="Employee Details" level="H2"/>
            </Toolbar>
        </headerToolbar>
        <columns>
            <Column>
                <Text text="Employee ID" />
            </Column>
            <Column>
                <Text text="First Name" />
            </Column>
            <Column>
                <Text text="Last Name" />
            </Column>
            <Column>
                <Text text="Address" />
            </Column>
            <Column>
                <Text text="Designation" />
            </Column>
            
        </columns>
        <items>
            <ColumnListItem>
                <cells>
                    <Text
                        text="{Empno}" />
                    <Text
                        text="{Fname}" />
                    <Text
                        text="{Lname}" />
                    <Text
                        text="{Addrs}" />
                    <Text
                        text="{Desgn}" />
                </cells>
            </ColumnListItem>
        </items>
    </Table>    

在web.xml中，添加SimpleProxyServlet的参数

在view1.controller.js中，添加init方法

    onInit: function() {
//      var oModel = new sap.ui.model.odata.ODataModel("proxy/sap/opu/odata/sap/ZLL_DEMO_SRV/");
        var oModel = new sap.ui.model.odata.v2.ODataModel("proxy/sap/opu/odata/sap/ZLL_DEMO_SRV/", { 
            json     : true,
            user     : "username",
            password : "Password"
        });
        this.getView().setModel(oModel);
    },

解决PKIX：unable to find valid certification path to requested target 的问题：对于https，需要导入证书，创建InstallCert class

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.security.KeyStore;
import java.security.MessageDigest;
import java.security.cert.CertificateException;
import java.security.cert.X509Certificate;

import javax.net.ssl.SSLContext;
import javax.net.ssl.SSLException;
import javax.net.ssl.SSLSocket;
import javax.net.ssl.SSLSocketFactory;
import javax.net.ssl.TrustManager;
import javax.net.ssl.TrustManagerFactory;
import javax.net.ssl.X509TrustManager;

public class InstallCert {

    public static void main(String[] args) throws Exception {
        String host;
        int port;
        char[] passphrase;
        if ((args.length == 1) || (args.length == 2)) {
            String[] c = args[0].split(":");
            host = c[0];
            port = (c.length == 1) ? 443 : Integer.parseInt(c[1]);
            String p = (args.length == 1) ? "changeit" : args[1];
            passphrase = p.toCharArray();
        } else {
            System.out
                    .println("Usage: java InstallCert <host>[:port] [passphrase]");
            return;
        }

        File file = new File("jssecacerts");
        if (file.isFile() == false) {
            char SEP = File.separatorChar;
            File dir = new File(System.getProperty("java.home") + SEP + "lib"
                    + SEP + "security");
            file = new File(dir, "jssecacerts");
            if (file.isFile() == false) {
                file = new File(dir, "cacerts");
            }
        }
        System.out.println("Loading KeyStore " + file + "...");
        InputStream in = new FileInputStream(file);
        KeyStore ks = KeyStore.getInstance(KeyStore.getDefaultType());
        ks.load(in, passphrase);
        in.close();

        SSLContext context = SSLContext.getInstance("TLS");
        TrustManagerFactory tmf = TrustManagerFactory
                .getInstance(TrustManagerFactory.getDefaultAlgorithm());
        tmf.init(ks);
        X509TrustManager defaultTrustManager = (X509TrustManager) tmf
                .getTrustManagers()[0];
        SavingTrustManager tm = new SavingTrustManager(defaultTrustManager);
        context.init(null, new TrustManager[] { tm }, null);
        SSLSocketFactory factory = context.getSocketFactory();

        System.out
                .println("Opening connection to " + host + ":" + port + "...");
        SSLSocket socket = (SSLSocket) factory.createSocket(host, port);
        socket.setSoTimeout(10000);
        try {
            System.out.println("Starting SSL handshake...");
            socket.startHandshake();
            socket.close();
            System.out.println();
            System.out.println("No errors, certificate is already trusted");
        } catch (SSLException e) {
            System.out.println();
            e.printStackTrace(System.out);
        }

        X509Certificate[] chain = tm.chain;
        if (chain == null) {
            System.out.println("Could not obtain server certificate chain");
            return;
        }

        BufferedReader reader = new BufferedReader(new InputStreamReader(
                System.in));

        System.out.println();
        System.out.println("Server sent " + chain.length + " certificate(s):");
        System.out.println();
        MessageDigest sha1 = MessageDigest.getInstance("SHA1");
        MessageDigest md5 = MessageDigest.getInstance("MD5");
        for (int i = 0; i < chain.length; i++) {
            X509Certificate cert = chain[i];
            System.out.println(" " + (i + 1) + " Subject "
                    + cert.getSubjectDN());
            System.out.println("   Issuer  " + cert.getIssuerDN());
            sha1.update(cert.getEncoded());
            System.out.println("   sha1    " + toHexString(sha1.digest()));
            md5.update(cert.getEncoded());
            System.out.println("   md5     " + toHexString(md5.digest()));
            System.out.println();
        }

        System.out
                .println("Enter certificate to add to trusted keystore or 'q' to quit: [1]");
        String line = reader.readLine().trim();
        int k;
        try {
            k = (line.length() == 0) ? 0 : Integer.parseInt(line) - 1;
        } catch (NumberFormatException e) {
            System.out.println("KeyStore not changed");
            return;
        }

        X509Certificate cert = chain[k];
        String alias = host + "-" + (k + 1);
        ks.setCertificateEntry(alias, cert);

        OutputStream out = new FileOutputStream("jssecacerts");
        ks.store(out, passphrase);
        out.close();

        System.out.println();
        System.out.println(cert);
        System.out.println();
        System.out
                .println("Added certificate to keystore 'jssecacerts' using alias '"
                        + alias + "'");
    }

    private static final char[] HEXDIGITS = "0123456789abcdef".toCharArray();

    private static String toHexString(byte[] bytes) {
        StringBuilder sb = new StringBuilder(bytes.length * 3);
        for (int b : bytes) {
            b &= 0xff;
            sb.append(HEXDIGITS[b >> 4]);
            sb.append(HEXDIGITS[b & 15]);
            sb.append(' ');
        }
        return sb.toString();
    }

    private static class SavingTrustManager implements X509TrustManager {

        private final X509TrustManager tm;
        private X509Certificate[] chain;

        SavingTrustManager(X509TrustManager tm) {
            this.tm = tm;
        }

        public X509Certificate[] getAcceptedIssuers() {
            throw new UnsupportedOperationException();
        }

        public void checkClientTrusted(X509Certificate[] chain, String authType)
                throws CertificateException {
            throw new UnsupportedOperationException();
        }

        public void checkServerTrusted(X509Certificate[] chain, String authType)
                throws CertificateException {
            this.chain = chain;
            tm.checkServerTrusted(chain, authType);
        }
    }

}

编译InstallCert.java，然后执行：java InstallCert hostname

输入1，回车，然后会在当前的目录下产生一个名为“ssecacerts”的证书。将证书拷贝到$JAVA_HOME/jre/lib/security目录下，重启服务器，可以看到调用成功。

修改UI

给table添加SingleSelect属性

添加CRUD4个按钮

    <Button id="IdDisplay" press="onDisplay" text="Display"/>
    <Button id="IdUpdate" press="onUpdate" text="Update"/>
    <Button id="IdCreate" press="onCreate" text="Create"/>
    <Button id="IdDelete" press="onDelete" text="Delete"/>

并在controller中创建相应的方法

    onDisplay: function(){      
    },
    onUpdate: function(){
    },
    onCreate: function(){       
    },
    onDelete: function(){       
    },

添加Simple Form，拷贝Change.fragment.xml中的Grid代码

最终view的代码如下

<core:View xmlns:core="sap.ui.core" xmlns:mvc="sap.ui.core.mvc" xmlns="sap.m" xmlns:l="sap.ui.layout"
    xmlns:f="sap.ui.layout.form"
        controllerName="tablebinding.view1" xmlns:html="http://www.w3.org/1999/xhtml">
    <Page title="CRUD Operations">
        <content>
    <Table id="idEmployeeTable"
        inset="false"
        mode="SingleSelectLeft"
        items="{
            path: '/DemoSet'

        }">
        <headerToolbar>
            <Toolbar>
                <Title text="Employee Details" level="H2"/>
            </Toolbar>
        </headerToolbar>
        <columns>
            <Column>
                <Text text="Employee ID" />
            </Column>
            <Column>
                <Text text="First Name" />
            </Column>
            <Column>
                <Text text="Last Name" />
            </Column>
            <Column>
                <Text text="Address" />
            </Column>
            <Column>
                <Text text="Designation" />
            </Column>
            
        </columns>
        <items>
            <ColumnListItem>
                <cells>

                    <Text
                        text="{Empno}" />
                    <Text
                        text="{Fname}" />
                    <Text
                        text="{Lname}" />
                    <Text
                        text="{Addrs}" />
                    <Text
                        text="{Desgn}" />

                </cells>
            </ColumnListItem>
        </items>
    </Table>    
    <Button id="IdDisplay" press="onDisplay" text="Display"/>
    <Button id="IdUpdate" press="onUpdate" text="Update"/>
    <Button id="IdCreate" press="onCreate" text="Create"/>
    <Button id="IdDelete" press="onDelete" text="Delete"/>
    <VBox class="sapUiSmallMargin">
        <f:SimpleForm id="GridId"
            editable="true"
            layout="ResponsiveGridLayout"
            title="Address"
            labelSpanXL="3"
            labelSpanL="3"
            labelSpanM="3"
            labelSpanS="12"
            adjustLabelSpan="false"
            emptySpanXL="4"
            emptySpanL="4"
            emptySpanM="4"
            emptySpanS="0"
            columnsXL="1"
            columnsL="1"
            columnsM="1"
            singleContainerFullSize="false" >
            <f:content>
                <Label text="Employee ID" />
                <Input value="{Empno}" />
                <Label text="First Name" />
                <Input value="{Fname}"/>
                <Label text="Last name" />
                <Input value="{Lname}" />
                <Label text="Address" />
                <Input value="{Addrs}"/>
                <Label text="Designation" />
                <Input value="{Desgn}"/>                            
            </f:content>
        </f:SimpleForm>
    </VBox>
    </content>
    </Page>
</core:View>

UI如图

可以在init方法中令grid不显示

var oGrid = this.getView().byId("GridId");
oGrid.setVisible(false);