XPagesからSQLServerに接続する

You have to login first to use 'My Favorites' feature

So far, noone has added to favorites

<?xml version="1.0" encoding="UTF-8"?>
<xp:view xmlns:xp="http://www.ibm.com/xsp/core">

	<xp:button value="query" id="button1">
		<xp:eventHandler event="onclick" submit="true"
			refreshMode="partial" refreshId="dataTable1">
			<xp:this.action><![CDATA[#{javascript:try{
	var connection:java.sql.Connection;
	var statement:java.sql.Statement;
	var resultSet:java.sql.ResultSet;
	var sql = "SELECT ID, FIRST_NAME, LAST_NAME FROM EMP";
	
	connection = @JdbcGetConnection("mssql");	//WebContent - WEB-INF - jdbc - 接続名.jdbc
	statement = connection.createStatement();
	resultSet = statement.executeQuery(sql);
	
	viewScope.result =[];
	
	while (resultSet.next()){
		var item = {};
		item.ID = resultSet.getString(1).trim();
		item.FIRSTNAME = resultSet.getString(2).trim();
		item.LASTNAME = resultSet.getString(3).trim();
		viewScope.result.push(item);	
	}
	}catch(e){
		print("error:"+e);
	}finally{
		if(resultSet != null){resultSet.close()}
		if(statement != null){statement.close()}
		if(connection != null){connection.close()}
	}
}]]></xp:this.action>
		</xp:eventHandler></xp:button>

	<xp:dataTable id="dataTable1" rows="30" value="#{viewScope.result}"
		var="items" indexVar="itemIndex">
		<xp:column id="column1">
			<xp:this.facets>
				<xp:label value="ID" xp:key="header" id="label1"></xp:label>
			</xp:this.facets>
			<xp:inputText id="ID" value="#{items.ID}" readonly="true"></xp:inputText>
		</xp:column>

		<xp:column id="column2">
			<xp:this.facets>
				<xp:label value="FirstName" id="label2" xp:key="header"></xp:label>
			</xp:this.facets>
			<xp:inputText id="inputText1" value="#{items.FIRSTNAME}" readonly="true"></xp:inputText>
		</xp:column>
		
		<xp:column id="column3">
			<xp:this.facets>
				<xp:label value="LastName" id="label3" xp:key="header"></xp:label>
			</xp:this.facets>
			<xp:inputText id="inputText2" value="#{items.LASTNAME}" readonly="true"></xp:inputText>
		</xp:column>
	</xp:dataTable>
</xp:view>

Language	XPages
Author	onota
Submitted on	July 17, 2018 at 4:35 PM
Rating
Downloads	0
QAサイト