创建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);
网友评论