Baixe o app para aproveitar ainda mais
Leia os materiais offline, sem usar a internet. Além de vários outros recursos!
academicNet3Pessoa
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
academicNet3/build.xml
Builds, tests, and runs the project academicNet3.
academicNet3/nbproject/ant-deploy.xml
<!DOCTYPE
<!-- <!DOCTYPE
<sun-web-app
--> <sun-web-app
<!DOCTYPE
<!-- <!DOCTYPE
<glassfish-web-app
--> <glassfish-web-app
academicNet3/nbproject/build-impl.xml
Must set src.dir
Must set test.src.dir
Must set build.dir
Must set build.web.dir
Must set build.generated.dir
Must set dist.dir
Must set build.classes.dir
Must set dist.javadoc.dir
Must set build.test.classes.dir
Must set build.test.results.dir
Must set build.classes.excludes
Must set dist.war
The Java EE server classpath is not correctly set up - server home directory is missing.
Either open the project in the IDE and assign the server or setup the server classpath manually.
For example like this:
ant -Dj2ee.server.home=<app_server_installation_directory>
The Java EE server classpath is not correctly set up. Your active server type is ${j2ee.server.type}.
Either open the project in the IDE and assign the server or setup the server classpath manually.
For example like this:
ant -Duser.properties.file=<path_to_property_file> (where you put the property "j2ee.platform.classpath" in a .properties file)
or ant -Dj2ee.platform.classpath=<server_classpath> (where no properties file is used)
Must set javac.includes
No tests executed.
The libs.CopyLibs.classpath property is not set up.
This property must point to
org-netbeans-modules-java-j2seproject-copylibstask.jar file which is part
of NetBeans IDE installation and is usually located at
<netbeans_installation>/java<version>/ant/extra folder.
Either open the project in the IDE and make sure CopyLibs library
exists or setup the property manually. For example like this:
ant -Dlibs.CopyLibs.classpath=a/path/to/org-netbeans-modules-java-j2seproject-copylibstask.jar
Must set JVM to use for profiling in profiler.info.jvm
Must set profiler agent JVM arguments in profiler.info.jvmargs.agent
Must select some files in the IDE or set javac.includes
Must select some files in the IDE or set javac.jsp.includes
Must select a file in the IDE or set jsp.includes
Browser not found, cannot launch the deployed application. Try to set the BROWSER environment variable.
Launching ${browse.url}
Must select one file in the IDE or set run.class
Must select one file in the IDE or set run.class
Must select one file in the IDE or set debug.class
Must select one file in the IDE or set debug.class
Must set fix.includes
This target only works when run from inside the NetBeans IDE.
Must select some files in the IDE or set javac.includes
Some tests failed; see details above.
Must select some files in the IDE or set test.includes
Some tests failed; see details above.
Must select some files in the IDE or set test.class
Must select some method in the IDE or set test.method
Some tests failed; see details above.
Must select one file in the IDE or set test.class
Must select one file in the IDE or set test.class
Must select some method in the IDE or set test.method
academicNet3/nbproject/genfiles.properties
build.xml.data.CRC32=64594a84
build.xml.script.CRC32=8de9c2a3
build.xml.stylesheet.CRC32=651128d4@1.68.1.1
# This file is used by a NetBeans-based IDE to track changes in generated files such as build-impl.xml.
# Do not edit this file. You may delete it but then the IDE will never regenerate such files for you.
nbproject/build-impl.xml.data.CRC32=64594a84
nbproject/build-impl.xml.script.CRC32=bea6cbbd
nbproject/build-impl.xml.stylesheet.CRC32=99ea4b56@1.68.1.1
academicNet3/nbproject/project.properties
annotation.processing.enabled=true
annotation.processing.enabled.in.editor=true
annotation.processing.processors.list=
annotation.processing.run.all.processors=true
annotation.processing.source.output=${build.generated.sources.dir}/ap-source-output
build.classes.dir=${build.web.dir}/WEB-INF/classes
build.classes.excludes=**/*.java,**/*.form
build.dir=build
build.generated.dir=${build.dir}/generated
build.generated.sources.dir=${build.dir}/generated-sources
build.test.classes.dir=${build.dir}/test/classes
build.test.results.dir=${build.dir}/test/results
build.web.dir=${build.dir}/web
build.web.excludes=${build.classes.excludes}
client.urlPart=
compile.jsps=false
conf.dir=${source.root}/conf
debug.classpath=${build.classes.dir}:${javac.classpath}
debug.test.classpath=\
${run.test.classpath}
display.browser=true
# Arquivos a serem exclu\u00eddos do war de distribui\u00e7\u00e3o
dist.archive.excludes=
dist.dir=dist
dist.ear.war=${dist.dir}/${war.ear.name}
dist.javadoc.dir=${dist.dir}/javadoc
dist.war=${dist.dir}/${war.name}
endorsed.classpath=\
${libs.javaee-endorsed-api-6.0.classpath}
excludes=
file.reference.classes12.zip=C:\\oracle\\ora81\\jdbc\\lib\\classes12.zip
includes=**
j2ee.compile.on.save=true
j2ee.copy.static.files.on.save=true
j2ee.deploy.on.save=true
j2ee.platform=1.7-web
j2ee.platform.classpath=${j2ee.server.home}/modules/endorsed/javax.annotation-api.jar:${j2ee.server.home}/modules/endorsed/jaxb-api.jar:${j2ee.server.home}/modules/endorsed/webservices-api-osgi.jar:${j2ee.server.home}/modules/bean-validator.jar:${j2ee.server.home}/modules/javax.batch-api.jar:${j2ee.server.home}/modules/javax.ejb-api.jar:${j2ee.server.home}/modules/javax.el.jar:${j2ee.server.home}/modules/javax.enterprise.concurrent-api.jar:${j2ee.server.home}/modules/javax.enterprise.concurrent.jar:${j2ee.server.home}/modules/javax.enterprise.deploy-api.jar:${j2ee.server.home}/modules/javax.faces.jar:${j2ee.server.home}/modules/javax.inject.jar:${j2ee.server.home}/modules/javax.interceptor-api.jar:${j2ee.server.home}/modules/javax.jms-api.jar:${j2ee.server.home}/modules/javax.json.jar:${j2ee.server.home}/modules/javax.mail.jar:${j2ee.server.home}/modules/javax.management.j2ee-api.jar:${j2ee.server.home}/modules/javax.persistence.jar:${j2ee.server.home}/modules/javax.resource-api.jar:${j2ee.server.home}/modules/javax.security.auth.message-api.jar:${j2ee.server.home}/modules/javax.security.jacc-api.jar:${j2ee.server.home}/modules/javax.servlet-api.jar:${j2ee.server.home}/modules/javax.servlet.jsp-api.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jstl-api.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jstl.jar:${j2ee.server.home}/modules/javax.transaction-api.jar:${j2ee.server.home}/modules/javax.websocket-api.jar:${j2ee.server.home}/modules/javax.ws.rs-api.jar:${j2ee.server.home}/modules/javax.xml.registry-api.jar:${j2ee.server.home}/modules/javax.xml.rpc-api.jar:${j2ee.server.home}/modules/jaxb-osgi.jar:${j2ee.server.home}/modules/webservices-osgi.jar:${j2ee.server.home}/modules/weld-osgi-bundle.jar:${j2ee.server.middleware}/mq/lib/jaxm-api.jar
j2ee.platform.embeddableejb.classpath=${j2ee.server.home}/lib/embedded/glassfish-embedded-static-shell.jar
j2ee.platform.wscompile.classpath=${j2ee.server.home}/modules/webservices-osgi.jar
j2ee.platform.wsgen.classpath=${j2ee.server.home}/modules/webservices-osgi.jar:${j2ee.server.home}/modules/endorsed/webservices-api-osgi.jar:${j2ee.server.home}/modules/jaxb-osgi.jar:${j2ee.server.home}/modules/endorsed/jaxb-api.jar
j2ee.platform.wsimport.classpath=${j2ee.server.home}/modules/webservices-osgi.jar:${j2ee.server.home}/modules/endorsed/webservices-api-osgi.jar:${j2ee.server.home}/modules/jaxb-osgi.jar:${j2ee.server.home}/modules/endorsed/jaxb-api.jar
j2ee.platform.wsit.classpath=
j2ee.server.type=gfv3ee6
jar.compress=false
javac.classpath=\
${file.reference.classes12.zip}
# Space-separated list of extra javac options
javac.compilerargs=
javac.debug=true
javac.deprecation=false
javac.processorpath=\
${javac.classpath}
javac.source=1.8
javac.target=1.8
javac.test.classpath=\
${javac.classpath}:\
${build.classes.dir}
javac.test.processorpath=\
${javac.test.classpath}
javadoc.additionalparam=
javadoc.author=false
javadoc.encoding=${source.encoding}
javadoc.noindex=false
javadoc.nonavbar=false
javadoc.notree=false
javadoc.preview=true
javadoc.private=false
javadoc.splitindex=true
javadoc.use=true
javadoc.version=false
javadoc.windowtitle=
lib.dir=${web.docbase.dir}/WEB-INF/lib
no.dependencies=false
persistence.xml.dir=${conf.dir}
platform.active=default_platform
resource.dir=setup
run.test.classpath=\
${javac.test.classpath}:\
${build.test.classes.dir}
# Space-separated list of JVM arguments used when running a class with a main method or a unit test
# (you may also define separate properties like run-sys-prop.name=value instead of -Dname=value):
runmain.jvmargs=
source.encoding=UTF-8
source.root=src
src.dir=${source.root}/java
test.src.dir=test
war.content.additional=
war.ear.name=${war.name}
war.name=academicNet3.war
web.docbase.dir=web
webinf.dir=web/WEB-INF
academicNet3/nbproject/project.xml
org.netbeans.modules.web.project
academicNet3
1.6.5
${file.reference.classes12.zip}
WEB-INF/lib
academicNet3/src/conf/MANIFEST.MF
Manifest-Version: 1.0
academicNet3/src/java/business/Aluno.java
package business;
public class Aluno
{
private int id;
private String nome;
private String matricula;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getMatricula() {
return matricula;
}
public void setMatricula(String matricula) {
this.matricula = matricula;
}
public String getNome() {
return nome;
}
public void setNome(String nome) {
this.nome = nome;
}
}
academicNet3/src/java/business/Pessoa.java
package business;
public class Pessoa
{
private int matricula;
private String nomePessoa;
public int getMatricula() {
return matricula;
}
public void setMatricula(int matricula) {
this.matricula = matricula;
}
public String getNomePessoa() {
return nomePessoa;
}
public void setNomePessoa(String nomePessoa) {
this.nomePessoa = nomePessoa;
}
}
academicNet3/src/java/business/Professor.java
package business;
public class Professor
{
private int id;
private String nome;
private String matricula;
private String titulacao;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getMatricula() {
return matricula;
}
public void setMatricula(String matricula) {
this.matricula = matricula;
}
public String getTitulacao() {
return titulacao;
}
public void setTitulacao(String titulacao) {
this.titulacao = titulacao;
}
public String getNome() {
return nome;
}
public void setNome(String nome) {
this.nome = nome;
}
}
academicNet3/src/java/dao/AlunoDAO.java
package dao;
import java.util.ArrayList;
import business.Aluno;
public class AlunoDAO
{
ArrayList lista = new ArrayList();
public void inserir(Aluno al)
{
lista.add(al);
}
public boolean removerPorMatricula(String matricula)
{
for (int i=0; i<lista.size() ; i++)
{
Aluno al = (Aluno)lista.get(i);
if (matricula.equals( al.getMatricula() ))
{
lista.remove(al);
return true;
}
}
return false;
}
public ArrayList listar()
{
return lista;
}
}
academicNet3/src/java/dao/PessoaDAO.java
package dao;
import business.Pessoa;
import java.util.ArrayList;
public class PessoaDAO
{
ArrayList lista = new ArrayList();
public void inserir(Pessoa p)
{
lista.add(p);
}
public Pessoa consultar (int matricula){
Pessoa p = null;
for (Object lista1 : lista) {
Pessoa aux = (Pessoa) lista1;
if (aux.getMatricula() == matricula){
p = aux;
}
}
return p;
}
public boolean alterar(Pessoa pNovo)
{
boolean retorno = false;
try {
for (Object lista1 : lista) {
Pessoa aux = (Pessoa) lista1;
if (aux.getMatricula() == pNovo.getMatricula()){
aux.setNomePessoa(pNovo.getNomePessoa());
retorno = true;
}
}
} catch(Exception e){
retorno = false;
}
return retorno;
}
public boolean remover(int matricula)
{
for (int i=0; i < lista.size() ; i++)
{
Pessoa p = (Pessoa)lista.get(i);
if (p.getMatricula() == matricula)
{
lista.remove(p);
return true;
}
}
return false;
}
public ArrayList listar()
{
return lista;
}
}
academicNet3/src/java/dao/ProfessorDAO.java
package dao;
import java.util.ArrayList;
import business.Professor;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import util.DBUtil2;
import business.Professor;
public class ProfessorDAO
{
public String adicionarProfessor(Professor professor)
{
boolean babou = false;
String msg = "Professor Inserido com Sucesso!";
try
{
// Recupera conexão com o banco
Connection con = DBUtil2.getConnection();
// Cria um statement
Statement stmt = con.createStatement();
// Monta base do SQL
String sql = "SELECT * from professor where matricula = ";
sql += professor.getMatricula();
System.out.println(sql);
// Executa o sql
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()){
babou = true;
msg = "Matrícula já cadastrada";
}
// Termina o statement
stmt.close();
if (!babou)
{
// Monta base do SQL
sql = "INSERT INTO professor(nome,matricula,titulacao) values";
// Adiciona valores do professor
sql += "(";
sql += "'"+professor.getNome()+"'";
sql += ",";
sql += "'"+professor.getMatricula()+"'";
sql += ",";
sql += "'"+professor.getTitulacao()+"'";
sql += ")";
// Cria um statement
stmt = con.createStatement();
// Executa o sql
stmt.executeUpdate(sql);
// Termina o statement
stmt.close();
}
}
catch(SQLException e)
{
e.printStackTrace();
msg = "Erro na execução do SQL. Contacte o Administrador";
}
return msg;
}
public String removerProfessor(int idProfessor)
{
// Monta base do SQL
String sql = "DELETE FROM professor WHERE id";
String msg = null;
// Adiciona posicao
sql += "=";
sql += idProfessor;
try
{
// Recupera conexão com o banco
Connection con = DBUtil2.getConnection();
// Cria um statement
Statement stmt = con.createStatement();
// Executa o sql
stmt.executeUpdate(sql);
// Termina o statement
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
msg = "Erro na execução do SQL. Contacte o Administrador";
}
return
msg;
}
public Professor leProfessor(int idProfessor)
{
// Monta base do SQL
String sql = "SELECT * FROM professor WHERE id";
// Adiciona posicao
sql += "=";
sql += idProfessor;
// Recupera conexão com o banco
Connection con = DBUtil2.getConnection();
try
{
// Cria um statement
Statement stmt = con.createStatement();
// Executa o sql
ResultSet rs = stmt.executeQuery(sql);
// Direciona o ResultSet para o primeiro registro
rs.next();
// Monta o professor
Professor a = montaProfessor(rs);
// Termina o resultset e o statement
rs.close();
stmt.close();
// Retorna o professor
return a;
}
catch(SQLException e)
{
e.printStackTrace();
return null;
}
}
public ArrayList listarProfessores()
{
// Monta base do SQL
String sql = "SELECT * FROM professor order by nome";
try
{
// Recupera conexão com o banco
Connection con = DBUtil2.getConnection();
// Cria um statement
Statement stmt = con.createStatement();
// Executa o sql
ResultSet rs = stmt.executeQuery(sql);
// Cria objeto de Lista
ArrayList professores = new ArrayList();
// Direciona o ResultSet para o primeiro registro
while(rs.next())
{
Professor p = montaProfessor(rs);
professores.add(p);
}
// Termina o resultset e o statement
rs.close();
stmt.close();
// Retorna a lista
return professores;
}
catch(SQLException e)
{
e.printStackTrace();
return null;
}
}
public ArrayList listarProfessoresPorNome(String nome)
{
// Monta base do SQL
String sql = "SELECT * FROM professor where nome like '%"+nome+"%'";
try
{
// Recupera conexão com o banco
Connection con = DBUtil2.getConnection();
// Cria um statement
Statement stmt = con.createStatement();
// Executa o sql
ResultSet rs = stmt.executeQuery(sql);
// Cria objeto de Lista
ArrayList professores = new ArrayList();
// Direciona o ResultSet para o primeiro registro
while(rs.next())
{
Professor p = montaProfessor(rs);
professores.add(p);
}
// Termina o resultset e o statement
rs.close();
stmt.close();
// Retorna a lista
return professores;
}
catch(SQLException e)
{
e.printStackTrace();
return null;
}
}
private Professor montaProfessor(ResultSet rs) throws SQLException
{
int id = rs.getInt("id");
String nome = rs.getString("nome");
String matricula = rs.getString("matricula");
String titulacao = rs.getString("titulacao");
Professor p = new Professor();
p.setId(id);
p.setNome(nome);
p.setMatricula(matricula);
p.setTitulacao(titulacao);
return p;
}
public String atualizaProfessor(Professor professor)
{
// Monta base do SQL
String sql = "UPDATE professor set nome=";
String msg = null;
// Adiciona valores do professor
sql += "'"+professor.getNome()+"'";
sql += ",matricula="+professor.getMatricula();
sql += ",titulacao=";
sql += "'"+professor.getTitulacao()+"'";
sql += " where id="+professor.getId();
System.out.println(sql);
try
{
// Recupera conexão com o banco
Connection con = DBUtil2.getConnection();
// Cria um statement
Statement stmt = con.createStatement();
// Executa o sql
stmt.executeUpdate(sql);
// Termina o statement
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
msg = "Erro na execução do SQL. Contacte o Administrador";
}
return msg;
}
public int obtemUltimaMatricula()
{
// Monta base do SQL
String sql = "SELECT max(matricula) FROM professor";
// Recupera conexão com o banco
Connection con = DBUtil2.getConnection();
try
{
// Cria um statement
Statement stmt = con.createStatement();
// Executa o sql
ResultSet rs = stmt.executeQuery(sql);
// Direciona o ResultSet para o primeiro registro
rs.next();
// Última matrícula
int mat = rs.getInt("max");
// Termina o resultset e o statement
rs.close();
stmt.close();
// Retorna o professor
return mat;
}
catch(SQLException e)
{
e.printStackTrace();
return -1;
}
}
public int obtemIdProfComUsername(String username)
{
// Monta base do SQL
String sql = "SELECT id FROM professor, usuario WHERE professor.id = usuario.idprof and usuario.userid = '" + username + "'";
// Recupera conexão com o banco
Connection con = DBUtil2.getConnection();
try
{
// Cria um statement
Statement stmt = con.createStatement();
// Executa o sql
ResultSet rs = stmt.executeQuery(sql);
// Direciona o ResultSet para o primeiro registro
rs.next();
// Última matrícula
int id = rs.getInt("id");
// Termina o resultset e o statement
rs.close();
stmt.close();
// Retorna o professor
return id;
}
catch(SQLException e)
{
e.printStackTrace();
return -1;
}
}
ArrayList lista = new ArrayList();
public void inserir(Professor pl)
{
lista.add(pl);
}
// public boolean removerPorMatricula(String matricula)
// {
// for (int i=0; i<lista.size() ; i++)
// {
// Professor pl = (Professor)lista.get(i);
//
// if (matricula.equals( pl.getMatricula() ))
// {
// lista.remove(pl);
// return true;
// }
// }
//
// return false;
// }
public boolean remover (Professor p){
boolean achei = false;
for (int i=0; i<lista.size(); i++){
Professor aux = (Professor) lista.get(i);
if (aux.getMatricula().equals(p.getMatricula())){
achei=true;
lista.remove(i);
}
}
return achei;
}
public ArrayList listar()
{
return lista;
}
public Professor consultar (String matricula){
Professor prof = null;
for (int i=0; i<lista.size(); i++){
Professor aux = (Professor) lista.get(i);
if (aux.getMatricula().equals(matricula)){
prof = aux;
}
}
return prof;
}
}
academicNet3/src/java/dao/ProfessorDAOOld.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 dao;
import business.Professor;
import java.util.ArrayList;
/**
*
* @author Administrador
*/
public class ProfessorDAOOld {
private ArrayList professores = new ArrayList();
public boolean inserir (Professor p){
return professores.add(p);
}
public boolean remover (Professor p){
boolean achei = false;
for (int i=0; i<professores.size(); i++){
Professor aux = (Professor) professores.get(i);
if (aux.getMatricula().equals(p.getMatricula())){
achei=true;
professores.remove(i);
}
}
return achei;
}
public ArrayList listar (){
return professores;
}
public Professor consultar (String matricula){
Professor prof = null;
for (int i=0; i<professores.size(); i++){
Professor aux = (Professor) professores.get(i);
if (aux.getMatricula().equals(matricula)){
prof = aux;
}
}
return prof;
}
}
academicNet3/src/java/servlets/AlunoServlet.java
package servlets;
import java.io.IOException;
import java.util.ArrayList;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import
javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import business.Aluno;
import dao.AlunoDAO;
public class AlunoServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet
{
// Atributos
AlunoDAO dao = new AlunoDAO();
// Metodos
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
String comando = request.getParameter("comando");
if (comando != null)
{
if (comando.equals("inserir"))
{
comandoInserir(request,response);
}
else if (comando.equals("remover"))
{
comandoRemover(request,response);
}
else if (comando.equals("listar"))
{
comandoListar(request,response);
}
}
}
public void comandoInserir(HttpServletRequest request,
HttpServletResponse response)
throws IOException,ServletException
{
// Recupera os Parametros
String nome = request.getParameter("nome");
String matr = request.getParameter("matr");
// Cria um Aluno com os Parametros
Aluno al = new Aluno();
al.setNome(nome);
al.setMatricula(matr);
// Insere o Aluno no Banco
dao.inserir(al);
// Avisa o Usu�rio
response.sendRedirect("alunoInserir.jsp?msg=Aluno Inserido.");
}
public void comandoRemover(HttpServletRequest request,
HttpServletResponse response)
throws IOException,ServletException
{
// Recupera os parametros
String matr = request.getParameter("matr");
// Remove o aluno
if(dao.removerPorMatricula(matr))
response.sendRedirect("alunoRemover.jsp?msg=Aluno Removido.");
else
response.sendRedirect("alunoRemover.jsp?msg=Aluno Inexistente.");
}
public void comandoListar(HttpServletRequest request,
HttpServletResponse response)
throws IOException,ServletException
{
// Pede os alunos para o DAO
ArrayList lista = dao.listar();
// Guarda como atributo de requisito
request.setAttribute("lista",lista);
// Redireciona a requisito internamente para a pagina
RequestDispatcher rd = request.getRequestDispatcher("alunoListar.jsp");
rd.forward(request, response);
}
}
academicNet3/src/java/servlets/LoginServlet.java
package servlets;
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.Servlet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class LoginServlet extends HttpServlet implements Servlet
{
protected void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
doPost(request,response);
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
String username = request.getParameter("username");
String password = request.getParameter("password");
if(username.equals("admin") && password.equals("admin"))
{
HttpSession session = request.getSession();
session.setAttribute("username",username);
RequestDispatcher rd = request.getRequestDispatcher("index.jsp");
rd.forward(request,response);
}
else
{
response.sendRedirect("login.jsp");
}
}
}
academicNet3/src/java/servlets/LogoutServlet.java
package servlets;
import java.io.IOException;
import javax.servlet.Servlet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class LogoutServlet extends HttpServlet implements Servlet
{
protected void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
doPost(request,response);
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
HttpSession session = request.getSession();
session.invalidate();
response.sendRedirect("login.jsp");
}
}
academicNet3/src/java/servlets/PessoaServlet.java
package servlets;
import java.io.IOException;
import java.util.ArrayList;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import business.Pessoa;
import dao.PessoaDAO;
public class PessoaServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet
{
// Atributos
PessoaDAO dao = new PessoaDAO();
// M�todos
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
String comando = request.getParameter("comando");
if (comando != null)
{
switch (comando) {
case "inserir":
comandoInserir(request,response);
break;
case "remover":
comandoRemover(request,response);
break;
case "consultar":
comandoConsultar(request,response);
break;
case "listar":
comandoListar(request,response);
break;
case "listalterar":
comandoListAlterar(request,response);
break;
case "alterar":
comandoAlterar(request,response);
break;
case "alteracao":
comandoAlteracao(request,response);
break;
}
}
}
public void comandoInserir(HttpServletRequest request,
HttpServletResponse response)
throws IOException,ServletException
{
// Recupera os Parametros
int matricula = Integer.parseInt(request.getParameter("matricula"));
String nomepessoa = request.getParameter("nomepessoa");
// Cria um Aluno com os Parametros
Pessoa p = new Pessoa();
p.setMatricula(matricula);
p.setNomePessoa(nomepessoa);
// Insere o Aluno no Banco
dao.inserir(p);
// Avisa o Usuario
response.sendRedirect("pessoaInserir.jsp?msg=Pessoa Inserida.");
}
public void comandoRemover(HttpServletRequest request,
HttpServletResponse response)
throws IOException,ServletException
{
// Recupera os parametros
int matricula = Integer.parseInt(request.getParameter("matricula"));
// Remove o aluno
if(dao.remover(matricula))
response.sendRedirect("pessoaRemover.jsp?msg=Pessoa Removido.");
else
response.sendRedirect("pessoaRemover.jsp?msg=Pessoa Inexistente.");
}
public void comandoConsultar (HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
int matricula = Integer.parseInt(request.getParameter("matricula"));
Pessoa p = dao.consultar(matricula);
String
msg = " ";
if (p != null) {
msg = "Pessoa Localizado!";
request.setAttribute("pessoa", p);
} else {
msg = "Pessoa não encontrada!";
}
//RequestDispatcher prox = request.getRequestDispatcher("professorConsultar.jsp?msg="+msg+"&matr="+prof.getMatricula()+"&nome="+prof.getNome()+"&titulacao="+prof.getTitulacao());
RequestDispatcher prox = request.getRequestDispatcher("pessoaConsultar.jsp?msg="+msg);
prox.forward(request, response);
}
public void comandoListar(HttpServletRequest request,
HttpServletResponse response)
throws IOException,ServletException
{
// Pede os alunos para o DAO
ArrayList lista = dao.listar();
// Guarda como atributo de requisi��o
request.setAttribute("lista",lista);
// Redireciona a requisi��o internamente para a p�gina
RequestDispatcher rd = request.getRequestDispatcher("pessoaListar.jsp");
rd.forward(request, response);
}
public void comandoListAlterar(HttpServletRequest request,
HttpServletResponse response)
throws IOException,ServletException
{
// Pede os alunos para o DAO
ArrayList lista = dao.listar();
// Guarda como atributo de requisi��o
request.setAttribute("lista",lista);
// Redireciona a requisi��o internamente para a p�gina
RequestDispatcher rd = request.getRequestDispatcher("pessoaListarAlterar.jsp");
rd.forward(request, response);
}
public void comandoAlterar (HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
// Recupera os Parametros
int matricula = Integer.parseInt(request.getParameter("codigo"));
Pessoa p = dao.consultar(matricula);
if (p != null) {
request.setAttribute("pessoaalterar", p);
}
RequestDispatcher rd = request.getRequestDispatcher("pessoaAlterar.jsp");
rd.forward(request, response);
}
public void comandoAlteracao(HttpServletRequest request,
HttpServletResponse response)
throws IOException,ServletException
{
int mat = Integer.parseInt(request.getParameter("mat"));
String nome = request.getParameter("nome");
Pessoa p = new Pessoa();
p.setMatricula(mat);
p.setNomePessoa(nome);
if (dao.alterar(p)) {
response.sendRedirect("pessoaserv?comando=listalterar");
}
else
{
response.sendRedirect("pessoaAlterar.jsp?msg=Erro ao alterar !");
}
}
}
academicNet3/src/java/servlets/ProfessorServlet.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 servlets;
import business.Professor;
import dao.ProfessorDAO;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author Administrador
*/
public class ProfessorServlet extends HttpServlet {
private ProfessorDAO dao = new ProfessorDAO();
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code>
* methods.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String opcao = request.getParameter("comando");
if (opcao.equals("inserir")){
inserir(request, response);
} else if (opcao.equals("remover")){
remover(request, response);
} else if (opcao.equals("listar")){
listar(request, response);
} else if (opcao.equals("consultar")){
consultar(request, response);
}
}
public void inserir (HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String nome = request.getParameter("nome");
String mat = request.getParameter("matr");
String tit = request.getParameter("titl");
Professor p = new Professor();
p.setMatricula(mat);
p.setNome(nome);
p.setTitulacao(tit);
//Usando o ProfessorDAO Old, sem Banco de Dados
//boolean ok = dao.inserir(p);
//String msg = " ";
//RequestDispatcher rd;
//if (ok){
// msg = "Professor Inserido";
//} else {
// msg = "Erro na Inserção";
//}
//Usando o novo ProfessorDAO, com Banco de Dados
String msg = dao.adicionarProfessor(p);
RequestDispatcher rd;
rd = request.getRequestDispatcher("professorInserir.jsp?msg="+msg);
rd.forward(request, response);
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
private void remover(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String mat = request.getParameter("matr");
Professor p = new Professor();
p.setMatricula(mat);
boolean ok = dao.remover(p);
String msg = " ";
RequestDispatcher proxPag;
if (ok){
msg = "Professor Removido com Sucesso!";
} else {
msg = "Professor não encontrada!";
}
proxPag = request.getRequestDispatcher("professorRemover.jsp?msg="+msg);
proxPag.forward(request, response);
}
public void listar (HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
ArrayList listaProf = dao.listar();
request.setAttribute("lista", listaProf);
RequestDispatcher prox = request.getRequestDispatcher("professoresListar.jsp");
prox.forward(request,
response);
}
public void consultar (HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String mat = request.getParameter("matr");
Professor prof = dao.consultar(mat);
String msg = " ";
if (prof != null) {
msg = "Professor Localizado!";
request.setAttribute("professor", prof);
} else {
msg = "Professor não encontrada!";
}
//RequestDispatcher prox = request.getRequestDispatcher("professorConsultar.jsp?msg="+msg+"&matr="+prof.getMatricula()+"&nome="+prof.getNome()+"&titulacao="+prof.getTitulacao());
RequestDispatcher prox = request.getRequestDispatcher("professorConsultar.jsp?msg="+msg);
prox.forward(request, response);
}
}
academicNet3/src/java/Util/DBUtil2.java
package util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBUtil2
{
private DBUtil2()
{
}
private static Connection con;
public static Connection getConnection()
{
// Se a conex�o n�o existe ainda
if (con == null)
{
try
{
// Carrega a classe do driver JDBC
//Class.forName("org.postgresql.Driver");
Class.forName("oracle.jdbc.driver.OracleDriver");
// Cria uma conex�o atrav�s do Driver
//con = DriverManager.getConnection("jdbc:postgresql://localhost:5432/academicNet","postgres","adsumus");
con = DriverManager.getConnection("jdbc:oracle:thin:@10.12.116.2:1521:cnova01", "javafabio", "senha");
//con = DriverManager.getConnection("jdbc:oracle:oci8:@cnova01", "javafabio", "senha");
// con = DriverManager.getConnection("jdbc:oracle:thin:javafabio/senha@//localhost:1521/cnova01");
}
catch(ClassNotFoundException e)
{
System.out.println("O driver n�o foi importado");
e.printStackTrace();
}
catch(SQLException e)
{
System.out.println("Erro de conex�o com o banco");
e.printStackTrace();
}
}
// Retorna a conex�o
return con;
}
}
academicNet3/web/_footer.jsp
</div>
<div id="footer">
<address>Desenvolvido por Rafael, Jean, Paulo e Marcelo. Copyright 2005. Adaptado por Fábio Marcos 2008</address>
</div>
</div>
</body>
</html>
academicNet3/web/_header.jsp
[Principal]
[Alunos]
[Docentes]
[Pessoas]
[Logout]
academicNet3/web/alunoInserir.jsp
<%@include file="_header.jsp" %>
<h1 id="title">Inserir Aluno</h1>
<hr/>
<form action="alunoserv" method="get">
<input type="hidden" name="comando" value="inserir" />
Nome: <input type="text" name="nome" /> <br />
Matrícula: <input type="text" name="matr" /> <br />
<br />
<input type="submit" value="Inserir" />
</form>
<%
String mensagem = request.getParameter("msg");
if (mensagem != null)
{
out.write("<hr/>");
out.write("<h3>"+mensagem+"</h3>");
}
%>
<%@include file="_footer.jsp" %>
academicNet3/web/alunoListar.jsp
<%@include file="_header.jsp" %>
<%@page import="business.Aluno" %>
<%@page import="java.util.ArrayList" %>
<h1 id="title">Listagem de Alunos</h1>
<hr/>
<%
ArrayList alunos = (ArrayList)request.getAttribute("lista");
for (int i=0 ; i<alunos.size() ; i++)
{
Aluno a1 = (Aluno)alunos.get(i);
out.print("Aluno "+(i+1)+"<br/>");
out.print("Nome: "+a1.getNome()+"<br/>");
out.print("Matricula: "+a1.getMatricula()+"<br/>"+"<br/>");
}
%>
<%@include file="_footer.jsp" %>
academicNet3/web/alunoRemover.jsp
<%@include file="_header.jsp" %>
<h1 id="title">Remover Aluno</h1>
<hr/>
<form action="alunoserv" method="get">
<input type="hidden" name="comando" value="remover" />
Matrícula: <input type="text" name="matr" /> <br />
<br />
<input type="submit" value="Remover" />
</form>
<%
String mensagem = request.getParameter("msg");
if (mensagem != null)
{
out.write("<hr/>");
out.write("<h3>"+mensagem+"</h3>");
}
%>
<%@include file="_footer.jsp" %>
academicNet3/web/alunos.jsp
<%@include file="_header.jsp" %>
<img src="include/sections/student.png" align="bottom" /><h1 id="title">Alunos</h1>
<p id="text">
Neste módulo é possível administrar os dados
referentes a alunos. Estão disponíveis as opções de inserção,
remoção, alteração e listagem de alunos.
</p>
<a href="alunoInserir.jsp" class="option">Adicionar</a><br />
<a href="alunoRemover.jsp" class="option">Remover</a><br />
<a href="alunoserv?comando=listar" class="option">Listar Alunos</a><br />
<%@include file="_footer.jsp" %>
academicNet3/web/include/common/banner.jpg
academicNet3/web/include/common/bgcontent.png
academicNet3/web/include/common/bgEsquerda.jpg
academicNet3/web/include/common/bgform1.gif
academicNet3/web/include/common/bgform2.jpg
academicNet3/web/include/common/bgli.png
academicNet3/web/include/common/bglih.png
academicNet3/web/include/common/bgTopo.jpg
academicNet3/web/include/common/forward.gif
academicNet3/web/include/common/seta.gif
academicNet3/web/include/displaytag/forward.gif
academicNet3/web/include/estilo.css
BODY {
padding: 0;
MARGIN: 0;
FONT-FAMILY: Verdana, Helvetica, sans-serif;
FONT-SIZE: medium;
BACKGROUND-COLOR: rgb(0,105,163);
TEXT-ALIGN: center;
}
p,body {
COLOR: #000;
}
IMG {
border: 0;
}
.hide {
display: none;
}
.form {
BACKGROUND-IMAGE: url('common/bgform1.gif');
}
.form2 {
BACKGROUND-IMAGE: url('common/bgform2.jpg');
}
.form, .form2 {
border: #90bc8b 1px solid;
BACKGROUND-REPEAT: repeat-x;
}
#container {
border: 3px solid #000;
padding: 0;
BACKGROUND-IMAGE: url('common/banner.jpg');
BACKGROUND-REPEAT: no-repeat;
BACKGROUND-COLOR: white;
BACKGROUND-POSITION: left top;
WIDTH: 760px;
TEXT-ALIGN: left;
margin:auto;
}
#banner {
BORDER-BOTTOM: #000 2px solid;
height: 57px;
}
#content {
BACKGROUND-POSITION: 50% bottom;
BACKGROUND-REPEAT: no-repeat;
BACKGROUND-COLOR: #fff;
padding: 0px 85px 0px 20px;
FONT-SIZE: 0.8em;
LINE-HEIGHT: 150%;
WIDTH: 500px;
float:left;
}
#content input[type=text] {
border: 1px solid black;
margin-bottom: 5px;
width:300px;
height:25px;
-moz-border-radius: 4px;
-webkit-border-radius: 4px;
display:block;
}
#content input[type=submit]{
border: 1px solid black;
padding: 8px 20px;
border-radius:2px;
margin-top: 6px;
}
#content input[type=submit]:hover{
background: #ccc;
}
#menu LI {
COLOR: #fff;
LIST-STYLE-TYPE: square;
}
H1,H2,H3 {
FONT-WEIGHT: normal;
COLOR: #993366;
FONT-SIZE: 14pt;
COLOR: #006699;
FONT-FAMILY: Arial, Helvetica, sans-serif;
LETTER-SPACING: 3px;
}
h1#title {
display: inline;
margin-left: 10px;
}
a.option {
text-align: center;
display:block;
font-size: 1em;
color: #3d639c;
text-decoration: none;
background: #eee;
padding: 5px 0;
margin-bottom: 6px;
-moz-border-radius: 4px;
-webkit-border-radius: 4px;
}
a.option:hover {
//border-bottom: 1px solid black;
background: #ddd;
}
#sidebar-a {
padding: 20px 0 0 0;
FLOAT: left;
WIDTH: 150px;
BACKGROUND-COLOR: #fff;
}
#menu {
display: block;
width: 150px;
}
#menu a {
font-family: Verdana, Arial, sans-serif;
FONT-WEIGHT: bold;
FONT-SIZE: 0.8em;
COLOR: rgb(0,105,163);
LINE-HEIGHT: 180%;
TEXT-DECORATION: none;
}
#menu a:hover, #menu a.active {
COLOR: rgb(161,210,251);
BORDER-BOTTOM: #999966 1px dotted;
}
#menu UL {
padding: 0;
MARGIN: 0;
}
#menu LI {
BACKGROUND-IMAGE: url('common/bglih.png');
BACKGROUND-REPEAT: repeat-x;
MARGIN-BOTTOM: 3px;
LIST-STYLE-TYPE: none;
}
#menu LI:hover {
BACKGROUND-IMAGE: url('common/bgli.png');
BACKGROUND-REPEAT: repeat-x
}
#footer {
padding: 10px 0 10px 0;
font-family: Verdana, Arial, sans-serif;
CLEAR: both;
MARGIN-TOP: 15px;
COLOR: #000;
BACKGROUND-REPEAT: repeat-x;
BACKGROUND-COLOR: white;
TEXT-ALIGN: center;
}
#footer ADDRESS {
FONT-SIZE: 0.7em;
COLOR: #000;
FONT-STYLE: normal;
}
.tg {border-collapse:collapse;border-spacing:0;border-color:#999;width:100%;text-align: center }
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:0px;overflow:hidden;word-break:normal;border-color:#999;color:#444;background-color:#F7FDFA;border-top-width:1px;border-bottom-width:1px;}
.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:0px;overflow:hidden;word-break:normal;border-color:#999;color:#fff;background-color:#26ADE4;border-top-width:1px;border-bottom-width:1px;}
.tg .tg-yw4l{vertical-align:top}
.tg .tg-6k2t{background-color:#D2E4FC;vertical-align:top}
academicNet3/web/include/forms/consultar-original.gif
academicNet3/web/include/forms/consultar.gif
academicNet3/web/include/forms/edit.gif
academicNet3/web/include/forms/editar-original.gif
academicNet3/web/include/forms/editar.gif
academicNet3/web/include/forms/remover-original.gif
academicNet3/web/include/forms/remover.gif
academicNet3/web/include/forms/seta-original.gif
academicNet3/web/include/forms/seta.gif
academicNet3/web/include/index/academicNetLogo.jpg
academicNet3/web/include/index/biblioteca.jpg
academicNet3/web/include/index/certificacoes.jpg
academicNet3/web/include/index/eventos.jpg
academicNet3/web/include/index/projetos.jpg
academicNet3/web/include/sections/diploma.jpg
academicNet3/web/include/sections/projetos.jpg
academicNet3/web/include/sections/student.png
academicNet3/web/index.html
TODO write content
academicNet3/web/index.jsp
<%@include file="_header.jsp" %>
<h1 id="title">Academic.Net</h1>
<p id="text">
Bem-Vindo ao Academic NET. Escolha as opções de cadastro de alunos, docentes,
e pessoa no menu ao lado.
</p>
<%@include file="_footer.jsp" %>
academicNet3/web/login.jsp
Login:
Senha:
Área restrita. Entre com nome e senha");
}
%>
academicNet3/web/META-INF/MANIFEST.MF
Manifest-Version: 1.0
Class-Path:
academicNet3/web/pessoa.jsp
<%@include file="_header.jsp" %>
<img src="include/sections/student.png" align="bottom" /><h1 id="title">Pessoa</h1>
<p id="text">
Neste módulo é possível administrar os dados
referentes aos Pessoas. Estão disponíveis as opções de inserção,
remoção, alteração e listagem de Pessoas.
</p>
<a href="pessoaInserir.jsp" class="option">Adicionar</a><br />
<a href="pessoaRemover.jsp" class="option">Remover</a><br />
<a href="pessoaConsultar.jsp" class="option">Consultar</a><br/>
<a href="pessoaserv?comando=listar" class="option">Listar Pessoas</a><br />
<a href="pessoaserv?comando=listalterar" class="option">Aterar Pessoas</a><br />
<%@include file="_footer.jsp" %>
academicNet3/web/pessoaAlterar.jsp
<%@include file="_header.jsp" %>
<%@page import="business.Pessoa"%>
<%
String mensagem = request.getParameter("msg");
if (mensagem != null)
{
out.write("<hr/>");
out.write("<h3>"+mensagem+"</h3>");
}
else{
%>
<%Pessoa p = (Pessoa)request.getAttribute("pessoaalterar"); %>
<h1 id="title">Alterar Pessoa</h1>
<hr/>
<form action="pessoaserv" method="get">
<input type="hidden" name="comando" value="alteracao" />
<input type="hidden" name="mat" value="<%out.print(p.getMatricula());%>"/>
<p>Matricula: <%out.print(p.getMatricula());%> </p><br />
Nome pessoa: <input type="text" name="nome" value="<%out.print(p.getNomePessoa());%>"/> <br />
<br />
<input type="submit" value="Alterar" />
</form>
<%} %>
<%@include file="_footer.jsp" %>
academicNet3/web/pessoaConsultar.jsp
<%@include file="_header.jsp" %>
<%@page import="business.Pessoa" %>
<h1 id="title">Consultar Pessoas</h1>
<hr/>
<form action="pessoaserv" method="get">
<input type="hidden" name="comando" value="consultar" />
Matricula: <input type="text" name="matricula" /> <br />
<br />
<input type="submit" value="Consultar" />
</form>
<%
String mensagem = request.getParameter("msg");
Pessoa p = (Pessoa)request.getAttribute("pessoa");
if (mensagem != null)
{
out.write("<hr/>");
out.write("<h3>" + mensagem + "</h3>");
out.write("<p>");
if (p != null) {
out.write("Matricula: "+ p.getMatricula()+ "<br/>");
out.write("Nome pessoa: "+ p.getNomePessoa()+ "<br/>");
}
out.write("</p>");
}
%>
<%@include file="_footer.jsp" %>
academicNet3/web/pessoaInserir.jsp
<%@include file="_header.jsp" %>
<h1 id="title">Inserir Pessoa</h1>
<hr/>
<form action="pessoaserv" method="get">
<input type="hidden" name="comando" value="inserir" />
Matricula: <input type="text" name="matricula" /> <br />
Nome pessoa: <input type="text" name="nomepessoa" /> <br />
<br />
<input type="submit" value="Inserir" />
</form>
<%
String mensagem = request.getParameter("msg");
if (mensagem != null)
{
out.write("<hr/>");
out.write("<h3>"+mensagem+"</h3>");
}
%>
<%@include file="_footer.jsp" %>
academicNet3/web/pessoaListar.jsp
<%@include file="_header.jsp" %>
<%@page import="business.Pessoa" %>
<%@page import="java.util.ArrayList" %>
<h1 id="title">Listagem de Pessoas</h1>
<hr/>
<%
ArrayList listaPessoas = (ArrayList)request.getAttribute("lista");
out.print("<table class='tg'>");
out.print("<tr>");
out.print("<th class='tg-yw4'>Matricula</th>");
out.print("<th class='tg-yw4l'>Nome</th>");
out.print("</tr>");
for (int i=0 ; i<listaPessoas.size() ; i++)
{
Pessoa p = (Pessoa)listaPessoas.get(i);
out.print("<tr>");
out.print("<td class='tg-6k2t'>"+p.getMatricula()+"</td>");
out.print("<td class='tg-6k2t'>"+p.getNomePessoa()+"</td>");
out.print("</tr>");
}
out.print("</table>");
%>
<%@include file="_footer.jsp" %>
academicNet3/web/pessoaListarAlterar.jsp
<%@include file="_header.jsp" %>
<%@page import="business.Pessoa" %>
<%@page import="java.util.ArrayList" %>
<img src="include/forms/editar.gif" alt=""/>
<h1 id="title">Alteração de Pessoas</h1>
<hr/>
<%
ArrayList listaPessoas = (ArrayList)request.getAttribute("lista");
out.print("<table class='tg'>");
out.print("<tr>");
out.print("<th class='tg-yw4'>Matricula</th>");
out.print("<th class='tg-yw4l'>Nome</th>");
out.print("<th class='tg-yw4l'>...</th>");
out.print("</tr>");
for (int i=0 ; i<listaPessoas.size() ; i++)
{
Pessoa p = (Pessoa)listaPessoas.get(i);
out.print("<tr>");
out.print("<td class='tg-6k2t'>"+p.getMatricula()+"</td>");
out.print("<td class='tg-6k2t'>"+p.getNomePessoa()+"</td>");
out.print("<td class='tg-6k2t'><a href=pessoaserv?comando=alterar&codigo="+p.getMatricula()+"><img src='include/forms/edit.gif'/></a></td>");
out.print("</tr>");
}
out.print("</table>");
%>
<%@include file="_footer.jsp" %>
academicNet3/web/pessoaRemover.jsp
<%@include file="_header.jsp" %>
<h1 id="title">Remover Pessoa</h1>
<hr/>
<form action="pessoaserv" method="get">
<input type="hidden" name="comando" value="remover" />
Matricula: <input type="text" name="matricula" /> <br />
<br />
<input type="submit" value="Remover" />
</form>
<%
String mensagem = request.getParameter("msg");
if (mensagem != null)
{
out.write("<hr/>");
out.write("<h3>"+mensagem+"</h3>");
}
%>
<%@include file="_footer.jsp" %>
academicNet3/web/professorConsultar.jsp
<%@include file="_header.jsp" %>
<%@page import="business.Professor" %>
<h1 id="title">Consultar Professor</h1>
<hr/>
<form action="profserv" method="get">
<input type="hidden" name="comando" value="consultar" />
Matrícula: <input type="text" name="matr" /> <br />
<br />
<input type="submit" value="Consultar" />
</form>
<%
String mensagem = request.getParameter("msg");
Professor prof = (Professor)request.getAttribute("professor");
if (mensagem != null)
{
out.write("<hr/>");
out.write("<h3>" + mensagem + "</h3>");
out.write("<br/>");
if (prof != null) {
out.write("Nome: "+ prof.getNome() + "<br/>");
out.write("Matrícula: "+ prof.getMatricula() + "<br/>");
out.write("Titulação: "+ prof.getTitulacao() + "<br/>");
}
}
%>
<%@include file="_footer.jsp" %>
academicNet3/web/professores.jsp
<%@include file="_header.jsp" %>
<img src="include/sections/student.png" align="bottom" /><h1 id="title">Professores</h1>
<p id="text">
Neste módulo é possível administrar os dados
referentes a professores. Estão disponíveis as opções de inserção,
remoção, alteração e listagem de professores.
</p>
<a href="professorInserir.jsp" class="option">Adicionar</a><br />
<a href="professorRemover.jsp" class="option">Remover</a><br />
<a href="profserv?comando=listar" class="option">Listar Professores</a><br />
<a href="professorConsultar.jsp" class="option">Consultar</a><br />
<%@include file="_footer.jsp" %>
academicNet3/web/professoresListar.jsp
<%@include file="_header.jsp" %>
<%@page import="business.Professor" %>
<%@page import="java.util.ArrayList" %>
<h1 id="title">Listagem de Professores</h1>
<hr/>
<%
ArrayList professores = (ArrayList)request.getAttribute("lista");
for (int i=0 ; i<professores.size() ; i++)
{
Professor p1 = (Professor)professores.get(i);
out.print("Professor "+(i+1)+"<br/>");
out.print("Nome: "+p1.getNome()+"<br/>");
out.print("Matricula: "+p1.getMatricula()+"<br/>"+"<br/>");
out.print("Titulação: "+p1.getTitulacao()+"<br/>"+"<br/>");
}
%>
<%@include file="_footer.jsp" %>
academicNet3/web/professorInserir.jsp
<%--
Document : professorInserir
Created on : 01/09/2015, 19:37:01
Author : Administrador
--%>
<%@include file="_header.jsp" %>
<h1 id="title">Inserir Professor</h1>
<hr/>
<form action="profserv" method="get">
<input type="hidden" name="comando" value="inserir" />
Nome: <input type="text" name="nome" /> <br />
Matrícula: <input type="text" name="matr" /> <br />
Titulação: <input type="text" name="titl" /> <br />
<br />
<input type="submit" value="Inserir" />
</form>
<%
String mensagem = request.getParameter("msg");
if (mensagem != null)
{
out.write("<hr/>");
out.write("<h3>"+mensagem+"</h3>");
}
%>
<%@include file="_footer.jsp" %>
academicNet3/web/professorRemover.jsp
<%--
Document : professorRemover
Created on : 08/09/2015, 19:34:57
Author : Administrador
--%>
<%@include file="_header.jsp" %>
<h1 id="title">Remover Professor</h1>
<hr/>
<form action="profserv" method="get">
<input type="hidden" name="comando" value="remover" />
Matrícula: <input type="text" name="matr" /> <br />
<br />
<input type="submit" value="Remover" />
</form>
<%
String mensagem = request.getParameter("msg");
if (mensagem != null)
{
out.write("<hr/>");
out.write("<h3>"+mensagem+"</h3>");
}
%>
<%@include file="_footer.jsp" %>
academicNet3/web/WEB-INF/web.xml
academicnet03
LoginServlet
LoginServlet
servlets.LoginServlet
LogoutServlet
LogoutServlet
servlets.LogoutServlet
AlunopServlet
AlunoServlet
servlets.AlunoServlet
ProfessorServlet
servlets.ProfessorServlet
PessoaServlet
servlets.PessoaServlet
LoginServlet
/login
LogoutServlet
/logout
AlunoServlet
/alunoserv
ProfessorServlet
/profserv
PessoaServlet
/pessoaserv
login.jsp
index.jsp
default.htm
index.htm
default.jsp
default.html
academicNet3.zip
academicNet3/build.xml
Builds, tests, and runs the project academicNet3.
academicNet3/nbproject/ant-deploy.xml
<!DOCTYPE
<!-- <!DOCTYPE
<sun-web-app
--> <sun-web-app
<!DOCTYPE
<!-- <!DOCTYPE
<glassfish-web-app
--> <glassfish-web-app
academicNet3/nbproject/build-impl.xmlCompartilhar
Perguntas relacionadas
Compartilhar