How to insert data in Postgres database using Java Beans and jsp tags?

Question

I need your help.
I have to develop a Web Application which consists in a JSP and a Java Bean. The JSP file has to get two parameters (name and account) and then insert them in a database only using bean and jsp tags. I started to do something:
Java Bean:

    package beans;
    public class java1 {
        private String name = "";
        private String account = "";

        public String getName(){
            return name;
        }

        public String getAccount(){
            return account;
        }

        public void setName(String name){
            this.name = name;
        }

        public void setAccount(String account){
            this.account = account;
        }
    }

JSP

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <%@page import = "java.sql.*"%>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
        <%String nome = (String) request.getParameter("nome");
        String account = (String) request.getParameter("account");%>
        <jsp:useBean id = "esame" class = "beans.java1" scope = "page"/>
            <jsp:setProperty name = "esame" property = "name" value = "<%=nome%>"/>
            <jsp:setProperty name = "esame" property = "account" value = "<%=account%>"/>
    </head>
    <body>
        <h1>Nome: </h1>
        <jsp:getProperty name = "esame" property = "name"/>
        <h1>Account:</h1>
        <jsp:getProperty name = "esame" property = "account"/>

    </body>
</html>

Now the Java Bean and jsp page itself work good. I need to know how to get those two parameters and insert them in database. Table structure would be:

users(name, account);

I know how to insert data into a database using JDBC driver, here's an example method:

public static void insert(String name, String account){
        String sql = "insert into users values('" + name + "', '" + account + "');";
        String url = "jdbc:postgresql://localhost/tests";
        Connection conn = null;
        Statement st = null;
        try{
            conn = DriverManager.getConnection(url);
            st = conn.createStatement();
            st.executeUpdate(sql);
            st.close();
            conn.close();
        }
        catch(SQLException ecc){
            System.out.println(ecc.getMessage());
        }
    }

But how can I do it using ONLY java bean and jsp tags? Sorry for the long question, I only wanted to be clear. Thank you

There is no way to persist data using only beans and JSP tags. What you can do (but shouldn't) is insert your JDBC code inside your JSP tags. You should use at least a servlet to hold persistence logic. — Diego Victor de Jesus
– Diego Victor de Jesus, Commented Jun 11, 2018 at 5:01

Rey333 · Accepted Answer · 2018-06-11 07:33:44Z

1

If you ONLY want beans and jsp's (which is really bad) then you can just put the insert method in the java1 class and then call it from the jsp like

<%    esame.insert(); %>

Of course you will need a second jsp with a form for inserting the data. If the user submits then you call a third jsp that calls the insert method.

answered Jun 11, 2018 at 7:33

Rey333

3502 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sergio Over a year ago

This is not an Application I'd use, it's just an exercise. By the way I did it your way and it works. I also created a new property in class bean1 which inserts the other's two properties in DB by calling the setProperty tag in jsp. Works this way too. Thank you

ntg Over a year ago

Thanx. If you ONLY want beans and jsp's : If not, what would be the suggestion, how can a bean be mapped to rows of the DB?

Rey333 Over a year ago

Then you should do the insert (or any other DML operation) in a separate Java class (not in the JSP). The jsp is for display only.

Collectives™ on Stack Overflow

How to insert data in Postgres database using Java Beans and jsp tags?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related