<%@page contentType="text/html" pageEncoding="UTF-8"%> <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> <style type="text/css"> table { border-collapse: collapse; } th { background-color: lightyellow; } th, td { border: 1px solid black; } </style> </head> <body> <c:choose> <c:when test="${param.submit != null}"> <span>You choose database: </span><c:out value="${param.dbname}"/> <c:if test="${param.querystring != ''}"> <br /> <br /> <c:out value="${param.querystring}"/> <br /> <br /> <c:choose> <c:when test="${param.dbname == 'mysql'}"> <c:set var="driver" value="com.mysql.jdbc.Driver" /> <c:set var="url" value="jdbc:mysql://127.0.0.1:3306/northwind;" /> <c:set var="user" value="root" /> <c:set var="password" value="mysql56" /> </c:when> <c:otherwise> <c:set var="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" /> <c:set var="url" value="jdbc:sqlserver://127.0.0.1;instanceName=SQLEXPRESS;databaseName=northwind;integratedSecurity=true;" /> <c:set var="user" value="" /> <c:set var="password" value="" /> </c:otherwise> </c:choose> <sql:setDataSource var="dataSource" driver="${driver}" url="${url}" user="${user}" password="${password}" /> <sql:query dataSource="${dataSource}" var="result"> ${param.querystring} </sql:query> <table> <c:set var="columns" value="${result.rows[0]}" /> <tr> <c:forEach var="column" items="${columns}" > <th><c:out value="${column.key}" /></th> </c:forEach> </tr> <c:forEach var="row" items="${result.rows}"> <tr> <c:forEach var="column" items="${row}" > <td> <c:out value="${column.value}" /> </td> </c:forEach> </tr> </c:forEach> </table> </c:if> </c:when> <c:otherwise> <form method="POST" > <span>Select Database:</span> <select name="dbname"> <option value="sqlserver">Sql Server</option> <option value="mysql">MySql Server</option> </select> <br /> <br /> <textarea name="querystring" rows="5" cols="75"> </textarea> <br /> <br /> <input type="submit" name="submit" value="Submit" /> </form> </c:otherwise> </c:choose> </body> </html>
<%@taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<c:if test="${fn:trim(param.queryString) != ''}">
<c:set var="driver" value="com.mysql.jdbc.Driver" />
<%@page contentType="text/html" pageEncoding="UTF-8"%> <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> <%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> <style type="text/css"> table { border-collapse: collapse; } th { background-color: lightyellow; } th, td { border: 1px solid black; } .catch { color: red; } </style> </head> <body> <c:choose> <c:when test="${param.submit != null}"> <span>You choose database: </span><c:out value="${param.dbServer}"/> <c:if test="${fn:trim(param.queryString) != ''}"> <br /> <br /> Query string: <c:out value="${param.queryString}"/> <br /> <br /> <c:choose> <c:when test="${param.dbServer == 'mySql'}"> <c:set var="driver" value="com.mysql.jdbc.Driver" /> <c:set var="url" value="jdbc:mysql://localhost:3306/northwind" /> <c:set var="user" value="root" /> <c:set var="password" value="mysql56" /> </c:when> <c:otherwise> <c:set var="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" /> <c:set var="url" value="jdbc:sqlserver://localhost;instanceName=SQLEXPRESS;databaseName=northwind;integratedSecurity=true;" /> <c:set var="user" value="" /> <c:set var="password" value="" /> </c:otherwise> </c:choose> <sql:setDataSource var="dataSource" driver="${driver}" url="${url}" user="${user}" password="${password}" /> <c:catch var="catchException"> <sql:query var="resultSet" dataSource="${dataSource}"> ${fn:trim(param.queryString)} </sql:query> </c:catch> <c:choose> <c:when test="${catchException != null}"> The exception is : <span class="catch"><c:out value="${catchException}" /></span><br /> There is an exception: <span class="catch"><c:out value="${catchException.message}" /></span> </c:when> <c:otherwise> <table> <c:set var="columns" value="${resultSet.rows[0]}" /> <tr> <c:forEach var="column" items="${columns}" > <th><c:out value="${column.key}" /></th> </c:forEach> </tr> <c:forEach var="row" items="${resultSet.rows}"> <tr> <c:forEach var="column" items="${row}" > <td><c:out value="${column.value}" /></td> </c:forEach> </tr> </c:forEach> </table> </c:otherwise> </c:choose> </c:if> </c:when> <c:otherwise> <form method="POST"> <span>Select Database:</span> <select name="dbServer"> <option value="sqlServer">Sql Server</option> <option value="mySql">MySql Server</option> </select> <br /> <br /> <textarea name="queryString" rows="5" cols="75"></textarea> <br /> <br /> <input type="submit" name="submit" value="Submit" /> </form> </c:otherwise> </c:choose> </body> </html>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
