George2 at 17:08, 25 April 2025

2025-04-25T17:08:54Z

George2: Created page with " import java.io.; import javax.servlet.; import javax.servlet.http.*; import java.time.format.DateTimeFormatter; import java.time.LocalDateTime; im..."

2025-04-25T16:36:57Z

Created page with "<source lang="java"> import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.time.format.DateTimeFormatter; import java.time.LocalDateTime; im..."

New page

<source lang="java">
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.time.format.DateTimeFormatter;
import java.time.LocalDateTime;
import java.sql.*;

public class Api extends HttpServlet
{

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
response.setContentType("text/html");
ServletOutputStream out = response.getOutputStream();
out.println("this is a get");
String voltage = request.getParameter("voltage");
out.println(voltage);
System.out.println("GET : " + voltage);

}

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;

response.setContentType("text/html");
ServletOutputStream out = response.getOutputStream();
out.println("This is a post \n");
String voltage = request.getParameter("voltage");
String key = request.getParameter("key");
out.println(voltage);
//Sql bla = new Sql();

try {

String userName = "solar";
String passWord = "solar";
String url = "jdbc:mysql://localhost/solar";
//Class.forName ("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection (url, userName, passWord);
System.out.println("Database connection established");

}
catch (SQLException e)
{
System.out.println("Cannot connect the database!" + e.toString());
}

System.out.print("POST : " + voltage + " ");
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy/MM/dd HH:mm:ss");
LocalDateTime now = LocalDateTime.now();
System.out.print(dtf.format(now));
System.out.println(" " + key);

Sql bla = new Sql();
bla.runIt(voltage);

}

}

</source>

@@ Line 42: / Line 42: @@
-                String userName = "solar";
+                String userName = "xxxx";
-                String passWord = "solar";
+                String passWord = "xxxx";
-                String url = "jdbc:mysql://localhost/solar";
+                String url = "jdbc:mysql://localhost/xxxxxxx";
                 //Class.forName ("com.mysql.jdbc.Driver").newInstance();
                 conn = DriverManager.getConnection (url, userName, passWord);

The Api.java file - Revision history

George2 at 17:08, 25 April 2025

George2: Created page with " import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.time.format.DateTimeFormatter; import java.time.LocalDateTime; im..."

George2: Created page with " import java.io.; import javax.servlet.; import javax.servlet.http.*; import java.time.format.DateTimeFormatter; import java.time.LocalDateTime; im..."