如何在文本字段中显示数据库中的数据

问题描述：

大家好，

我是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（）;
}

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.

如何在文本字段中显示数据库中的数据

相关推荐