database.java
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */
package com.test;
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List;
public class Database {
public List getUsers() throws SQLException,Exception{
List list = new ArrayList();
ResultSet rs = null;
javabean b = null;
Connection conn = null;
Statement stmt = null;
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase","root","mysql");
stmt = conn.createStatement();
String sql;
sql = "SELECT user_id, name,lname,fname FROM mydatabase.test_users";
rs = stmt.executeQuery(sql);
while(rs.next()){
b = new javabean();
b.setName(rs.getString("name"));
b.setFname(rs.getString("fname"));
b.setLname(rs.getString("lname"));
b.setUserId(rs.getString("user_id"));
list.add(b);
}
}catch(SQLException e){
System.out.println("Exception occured"+e.getMessage());
throw new SQLException(e);
}
finally{
if(conn!=null)
conn.close();
if(stmt!=null)
stmt.close();
if(rs!=null)
rs.close();
}
return list;
}
public List addUsers(javabean bean) throws SQLException,Exception{
List list = new ArrayList();
ResultSet rs = null;
javabean b = null;
Connection conn = null;
Statement stmt = null;
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase","root","mysql");
stmt = conn.createStatement();
String sql;
sql = "insert into mydatabase.test_users(name,fname,lname) values('"+bean.getName()+"','"+bean.getFname()+"','"+bean.getLname()+"');";
stmt.execute(sql);
//conn.commit();
}catch(SQLException e){
System.out.println("Exception occured"+e.getMessage());
throw new SQLException(e);
}
finally{
if(conn!=null)
conn.close();
if(stmt!=null)
stmt.close();
if(rs!=null)
rs.close();
}
return list;
}
}
action class
package com.test;
import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.actions.DispatchAction;
public class TestAction extends DispatchAction{
public ActionForward get(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
Database d = new Database();
try {
List list = d.getUsers();
request.setAttribute("list", list);
} catch (Exception e) {
}
return mapping.findForward("display");
}
public ActionForward add(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
HttpSession session = null;
try {
session = request.getSession();
} catch (Exception e) {
}
return mapping.findForward("add");
}
public ActionForward insert(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
Database d = new Database();
javabean b = new javabean();
b.setName(request.getParameter("name"));
b.setFname(request.getParameter("fname"));
b.setLname(request.getParameter("lname"));
try {
d.addUsers(b);
} catch (Exception e) {
}
return mapping.findForward("save");
}
public ActionForward delete(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
HttpSession session = null;
try {
session = request.getSession();
} catch (Exception e) {
}
return mapping.findForward("delete");
}
}
adduser.jsp
<%@taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> <%@taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %> <%@taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>