blocks|key|2121900|text|有几种方法可以做你想做的事情，我将列出几种：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2121901|服务器端的。|offset|length|style|BOLD|2121902|servlets使用jersey|2121903|Use+|unordered-list-item|2121904|
|2121905|之类的REST框架。|2121906|2121907|我推荐REST，你可以在here上找到教程。|2121908|在客户端，你需要使用javascript来发送ajax请求。|2121909|我建议你看看jquery，这是一个让你的生活变得更容易的javascript框架。here是学习它的一些很好的资源。|2121910|entityMap|0|LINK|mutability|MUTABLE|url|http://jersey.java.net/|1|http://www.vogella.com/articles/REST/article.html|2|http://jquery.com/|3|http://net.tutsplus.com/tutorials/javascript-ajax/15-resources-to-get-you-started-with-jquery-from-scratch/^0|0|5|1|0|A|6|0|0|0|0|0|0|C|4|1|0|0|6|6|2|15|4|3|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1C|8|@$D|1D|E|1E|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|1F|8|@]|9|@$D|1G|E|1H|1|1I]]|A|$]]|$1|J|3|K|5|L|7|1J|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1K|8|@]|9|@]|A|$]]|$1|O|3|P|5|L|7|1L|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1N|8|@]|9|@$D|1O|E|1P|1|1Q]]|A|$]]|$1|T|3|U|5|6|7|1R|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1S|8|@]|9|@$D|1T|E|1U|1|1V]|$D|1W|E|1X|1|1Y]]|A|$]]|$1|X|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|14]]|15|$5|10|11|12|A|$13|16]]|17|$5|10|11|12|A|$13|18]]|19|$5|10|11|12|A|$13|1A]]]]

There are several ways of doing what you want, i'll list a couple:

on the server side.

<ol>
<li>Use a REST framework like <a href="http://jersey.java.net/" rel="nofollow">jersey</a></li>
<li>Use servlets.</li>
</ol>

I'd recommend REST, and <a href="http://www.vogella.com/articles/REST/article.html" rel="nofollow">here</a> you can find a tutorial.

On the client side, you'll need to use javascript to send ajax requests.

I suggest you take a look at <a href="http://jquery.com/" rel="nofollow">jquery</a>, which is a javascript framework that would make your life much easier. <a href="http://net.tutsplus.com/tutorials/javascript-ajax/15-resources-to-get-you-started-with-jquery-from-scratch/" rel="nofollow">here</a> are some great resources for learning it.

blocks|key|2115084|text|假设您非常信任您的用户，那么最简单的方法就是创建一个简单的带有文本框的HTML页面，然后让用户输入他/她想要的内容。然后，您可以将用户直接键入的任何文本传递到数据库，并抛出结果。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2115085|如果你想在这个过程中学到一些新东西，你可以使用Spring框架。这可能有点夸张，但是考虑到应用程序的简单性(在您的例子中)，这个练习可能是一个很好的入门方法。|offset|length|2115086|entityMap|0|LINK|mutability|MUTABLE|url|http://www.springsource.org/^0|0|N|6|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Assuming you trust your users very much, the simplest thing would be to create a simple HTML page with a text box and let the user type in the queries to his/her heart's content. You can then pass whatever text the user typed in directly to the database and throw out the results.

You could use the <a href="http://www.springsource.org/" rel="nofollow">Spring</a> framework for this, if you want to learn something new in the process. It might be an overkill, but considering the simplicity of the application (in your case) this exercise might be a good way to get you started.

blocks|key|2121934|text|如果有人感兴趣，我最终使用了tapestry.apache.org，它提供了一个很好的入门教程:)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2121935|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If anyones interested, i ended up using tapestry.apache.org which comes with a good starting tutorial :)

blocks|key|3757444|text|也许你可以试试ZK+framework，它很简单。你可以查看他们的awesome+live+demos来感受它是多么的简单和容易。此外，他们有一个在线的sandbox+web应用程序，你可以在其中尝试zk代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3757445|例如，以下代码将查询数据库并将结果显示给用户。如果你填写了数据库访问部分的代码，那么这段代码就会运行，这一点也不奇怪。|3757446|index.zul|style|BOLD|3757447|<?xml+version="1.0"+encoding="UTF-8"?>
<zk>
++++<button+label='Query+database'+onClick='QueryAndDisplay()'/>
++++<grid+id='gridQueryResult'>
++++++++<columns/>
++++++++<rows/>
++++</grid>
++++<zscript><![CDATA[
++++import+java.sql.*;
++++void+QueryAndDisplay+()
++++{
++++++++//+clear+displayed+content
++++++++org.zkoss.zul.Columns+cols+=+gridQueryResult.getColumns();
++++++++org.zkoss.zul.Rows+rows+=+gridQueryResult.getRows+();

++++++++//+...
++++++++//+query+the+database,+get+the+result+set
++++++++//...
++++++++ResultSetMetaData+rsmd+=+rs.getMetaData();
++++++++for+(int+i=1;+i<rsmd.getColumnCount();+i%2B%2B)
++++++++{
++++++++++++//+display+the+columns
++++++++++++org.zkoss.zul.Column+col+=+new+org.zkoss.zul.Column+(rsmd.getColumnName(i));
++++++++++++cols.appendChild+(col);
++++++++}
++++++++while+(rs.next())
++++++++{
++++++++++++for+(int+i=1;+i<rsmd.getColumnCount();+i%2B%2B)
++++++++++++{
++++++++++++++++org.zkoss.zul.Row+row+=+new+org.zkoss.zul.Row+(rs.getString(i));
++++++++++++++++rows.appendChild+(row);
++++++++++++}
++++++++}

++++++++//+close+database
++++++++//+...
++++}
++++]]></zscript>
</zk>|code-block|syntax|javascript|3757448|entityMap|0|LINK|mutability|MUTABLE|url|http://www.zkoss.org/|1|http://www.zkoss.org/demo/|2|http://www.zkoss.org/zksandbox/^0|7|C|0|X|I|1|24|7|2|0|0|0|9|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]|$A|14|B|15|1|16]|$A|17|B|18|1|19]]|C|$]]|$1|D|3|E|5|6|7|1A|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|1B|8|@$A|1C|B|1D|H|I]]|9|@]|C|$]]|$1|J|3|K|5|L|7|1E|8|@]|9|@]|C|$M|N]]|$1|O|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]|W|$5|R|S|T|C|$U|X]]|Y|$5|R|S|T|C|$U|Z]]]]

Maybe you can try <a href="http://www.zkoss.org" rel="nofollow">ZK framework</a>, which is simple &amp; easy. You can check their <a href="http://www.zkoss.org/demo/" rel="nofollow">awesome live demos</a> to feel how simple &amp; easy it is. Also, they have a online <a href="http://www.zkoss.org/zksandbox/" rel="nofollow">sandbox</a> web application, you can try zk code in it.

eg, the following code will query the database and display result to user. Don't be surprise that such piece of code will run if you filled the code of database access part.

index.zul

<pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;zk&gt;
 &lt;button label='Query database' onClick='QueryAndDisplay()'/&gt;
 &lt;grid id='gridQueryResult'&gt;
 &lt;columns/&gt;
 &lt;rows/&gt;
 &lt;/grid&gt;
 &lt;zscript&gt;&lt;![CDATA[
 import java.sql.*;
 void QueryAndDisplay ()
 {
 // clear displayed content
 org.zkoss.zul.Columns cols = gridQueryResult.getColumns();
 org.zkoss.zul.Rows rows = gridQueryResult.getRows ();

 // ...
 // query the database, get the result set
 //...
 ResultSetMetaData rsmd = rs.getMetaData();
 for (int i=1; i&lt;rsmd.getColumnCount(); i++)
 {
 // display the columns
 org.zkoss.zul.Column col = new org.zkoss.zul.Column (rsmd.getColumnName(i));
 cols.appendChild (col);
 }
 while (rs.next())
 {
 for (int i=1; i&lt;rsmd.getColumnCount(); i++)
 {
 org.zkoss.zul.Row row = new org.zkoss.zul.Row (rs.getString(i));
 rows.appendChild (row);
 }
 }

 // close database
 // ...
 }
 ]]&gt;&lt;/zscript&gt;
&lt;/zk&gt;
</code></pre>

I have an SQL database running. All the java interaction with it is clear. 
Now I want to display the result of some queries (say <code>SELECT * FROM example</code>) and let the user make queries (<code>DELETE FROM example</code>) with a couple of buttons from within the browser. 

What's a not too complex way of doing that? My head is buzzing with words like JAX-WS, JSP, Servlets etc. Easiest way seems to be JSP, but I heard its deprecated and while doing this simple task I also want to learn something useful for the future :)

What would you recommend? Also, if you could point me to a good tutorial would be nice, because all the tutorials I found for Java webservices included writing a client, not using them from within the browser.

Java: simple way of displaying some SQL data in browser & interact

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个正在运行的SQL数据库。所有与之相关的java交互都是清晰的。现在，我想显示一些查询的结果(比如SELECT * FROM example)，并让用户在浏览器中使用几个按钮进行查询(DELETE FROM example)。要做到这一点，有什么方法不太复杂？我的脑海中充斥着JAX-WS、JSP、Servlet等词。最简单的方法似乎是JSP，但我听说它被弃用了，在做这项简单的任务时，我也想学

问Java:在浏览器和交互中显示一些SQL数据的简单方法
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Java:在浏览器和交互中显示一些SQL数据的简单方法EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Java:在浏览器和交互中显示一些SQL数据的简单方法
EN