java
1コード
'package sample1;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/Hello")
public class Hello extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html; charset=utf-8"); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<body>"); Connection conn = null; String url ="jdbc:mysql://localhost/training"; String user = "root"; String password ="ryota"; try{ Class.forName("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection(url, user, password); Statement stmt =conn.createStatement(); String sql ="SELECT * FROM user"; ResultSet rs = stmt.executeQuery(sql); while(rs.next()){ ````````````ここに言語を入力 int id = rs.getInt("id"); String name = rs.getString("name"); int age = rs.getInt("age"); out.println(id + name + age ); out.println("\n"); } rs.close(); stmt.close(); }catch(ClassNotFoundException e){ out.println("lassNotFoundException:"+ e.getMessage()); }catch(SQLException e){ out.println("SQLException:" + e.getMessage()); }catch(Exception e){ out.println("Exception:" + e.getMessage()); } finally{ try{ if(conn !=null){ conn.close();} }catch (SQLException e){ out.println("SQLException:" + e.getMessage()); } } //out.println("</html>"); out.println("</body>"); out.println("</html>"); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); }
}'
回答2件
あなたの回答
tips
プレビュー