Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <------------------------------------------------------JSP File----------------------------------------------------------------------->
- <%@page contentType="text/html" pageEncoding="UTF-8"%>
- <%@page import="pkg.*" %>
- <%@page import="java.sql.*" %>
- <%@page import="java.io.*" %>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <title> Page</title>
- </head>
- <body>
- <jsp:useBean id="iClass" class="Insert_Class" scope="page"></jsp:useBean>
- <jsp:setProperty name="iClass" property="name" param="name"></jsp:setProperty>
- <jsp:setProperty name="iClass" property="salary" param="salary"></jsp:setProperty>
- <jsp:useBean id="DAO1" class="DAO" scope="page" ></jsp:useBean>
- <%
- DAO1.savePerson(iClass);
- %>
- </body>
- </html>
- <--------------------------------------------------------Database Class------------------------------------------------------------>
- package pkg;
- import java.io.Serializable;
- import java.sql.*;
- public class DAO implements Serializable {
- Connection con=null;
- public void DAO()
- {
- establishConnection();
- }
- public void establishConnection()
- {
- try{
- Class.forName("com.msql.jdbc.Driver");
- String url="jdbc:mysql://localhost:3306/name_salary?zeroDateTimeBehavior=convertToNull";
- con=DriverManager.getConnection(url);
- }catch(Exception e){System.out.println(e);}
- }
- public void savePerson(Insert_Class obj)
- { try{
- String sql="INSERT INTO record1(name,salary)VALUES(?,?)";
- PreparedStatement pst=con.prepareStatement(sql);
- String name=obj.getName();
- int salary=(int)obj.getSalary();
- pst.setString(1, name);
- pst.setInt(2, salary);
- pst.executeUpdate();
- }catch(Exception e)
- {
- System.out.println(e);
- }
- }
- }
- <--------------------------------------------------------JAVA Bean CLass-------------------------------------------------------------->
- package pkg;
- import java.io.Serializable;
- public class Insert_Class implements Serializable{
- private String name;
- private int salary;
- public Insert_Class()
- {
- name="";
- salary=0;
- }
- public void setName(String name)
- {
- this.name=name;
- }
- public void setSalary(int salary)
- {
- this.salary=salary;
- }
- public String getName()
- {
- return name;
- }
- public int getSalary()
- {
- return salary;
- }
- }
Add Comment
Please, Sign In to add comment