如何在文本字段中显示数据库中的数据 [英] How to display data from database in text fields
问题描述
大家好，
我是java新手。我正在制作一个简单的java项目。我只想在html页面上显示来自数据库的存储数据。
这是我的代码： -
JAVA代码
包主页;
import java.io. *;
import java.sql。*;
import javax.servlet.ServletException;
import javax.servlet.http。*;
public class Profile extends HttpServlet {
public void doGet（HttpServletRequest request，HttpServletResponse response）抛出IOException，ServletException {
response.setContentType（text / html）;
PrintWriter out = response.getWriter（）;
String s1 = request.getParameter（name）;
String s2 = request.getParameter（number）;
String s3 = request.getParameter（state）;
String s4 = request.getParameter（country）;
try {
Class.forName（oracle.jdbc.OracleDriver）;
连接con = DriverManager.getConnection（jdbc：oracle：thin：@localhost ：1521：xe，system，admin）;
语句st = con.createStatement（）;
ResultSet rs = st.executeQuery（选择名称来自REGISTRATION）的数字，州和国家;
while（rs.next（））{
String name = rs.getString（name）;
字符串编号= rs.getString（number）;
字符串状态= rs.getString（state）;
字符串country = rs .getString（country）;
out.print（name）;
out.print（number）;
out.print（state）;
out.print（country）;
}
con.close（）; < br $>
}
catch（例外e）{
e.printStackTrace（）;
}
}
}
和HTML页面代码是： -
Hello everyone,
I am new in java. I am making a simple java project. I just want to display stored data from database on html page.
Here is my code:-
The JAVA code
package home;
import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
public class Profile extends HttpServlet{
public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String s1 = request.getParameter("name");
String s2 = request.getParameter("number");
String s3 = request.getParameter("state");
String s4 = request.getParameter("country");
try{
Class.forName("oracle.jdbc.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","admin");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select name,number,state and country from REGISTRATION");
while(rs.next()){
String name = rs.getString("name");
String number = rs.getString("number");
String state = rs.getString("state");
String country = rs.getString("country");
out.print(name);
out.print(number);
out.print(state);
out.print(country);
}
con.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
and the HTML page code is :-
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Profile</title>
</head>
<body>
<form action="profile" method="get">
<section>
Name:<input type="text" name="name">
Mobile:<input type="text" name="number">
State:<input type="text" name="state">
Country:<input type="text" name="country">
</section>
</form>
</body>
</html>
推荐答案
你必须使用 SqlDataReader
首先使用选择查询然后读取选择数据。
you have to work with SqlDataReader
first select you data using select query then read it.
这篇关于如何在文本字段中显示数据库中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
