📄 actionservlet.java
字号:
package com.skyhawk.control_1;
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import conn.skyhawk.control_2.DateBase;
import conn.skyhawk.control_2.DateManger;
import conn.skyhawk.vo.Card;
public class ActionServlet extends HttpServlet {
public ResultSet rs=null;
ArrayList list=new ArrayList();
public void doPost(HttpServletRequest request,HttpServletResponse response){
try {
request.setCharacterEncoding("GBK");
} catch (Exception e1) {
e1.printStackTrace();
}
String a=request.getParameter("hi");
HttpSession session=request.getSession();
String id=(String)session.getAttribute("user");
System.out.println("====id===="+id);
if(a.equals("hid")){//名片夹查询
String b=request.getParameter("tex");
System.out.println(b);
System.out.println("====++++++++=======");
DateManger da=new DateManger();
list=(ArrayList)da.getView(b,id);
request.setAttribute("view",list);
try {
System.out.println("nihao");
request.setAttribute("delete",b);
request.getRequestDispatcher("/cardSort_1.jsp").forward(request,response);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
else if(a.equals("add")){//添加名片和名片夹
Card ca=new Card();
DateBase db1=new DateBase();
ResultSet rs1=null;
System.out.println("====hello======");
String text1=request.getParameter("text1");
System.out.println(text1);
String text2=request.getParameter("text2");
String text3=request.getParameter("text3");
String text4=request.getParameter("text4");
String text5=request.getParameter("text5");
String text6=request.getParameter("text6");
String text7=request.getParameter("text7");
String text8=request.getParameter("text8");
String text9=request.getParameter("text9");
String option=request.getParameter("select2");
int i;
if(option.equals("男")){
i=0;
}else{i=1;
}
String option1=request.getParameter("select1");
int u;
if(option1.equals("共享")){u=1;
}else{u=0;
}
String str1="select * from o_cardkind where empid='"+id+"'and kindname='"+text1+"'";
rs1=db1.getSet(str1);
try {
if(rs1.next()){
System.out.println(rs1.getString("cardkindid"));
System.out.println(rs1.getString("kindname"));
ca.setCardkindid(rs1.getString("cardkindid"));
ca.setKindname(rs1.getString("kindname"));
System.out.println(ca.getKindname()+"=======");
System.out.println(ca.getCardkindid());
String str2=ca.getCardkindid();
String str3="insert into o_card values('"+str2+"','"+text2+"','"+text5+"','"+text7+"','"+text8+"','"+text9+"','"+text6+"','"+id+"','"+i+"','"+text4+"','"+text3+"')";
DateBase db2=new DateBase();
db2.setInsert(str3);
try {String str="success";
request.setAttribute("str",str);
request.getRequestDispatcher("/successcq.jsp").forward(request,response);
} catch (ServletException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
} catch (IOException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
}
else{
ResultSet rs=null;
System.out.println("success!!!");
String str4="insert into o_cardkind values(tmp_seq.nextval,'"+text1+"','"+u+"','"+id+"')";
DateBase db3=new DateBase();
db3.setInsert(str4);
DateBase db4=new DateBase();
String str5="select * from o_cardkind where kindname='"+text1+"'";
rs=db4.getSet(str5);
while(rs.next()){
DateBase db5=new DateBase();
String str6=rs.getString("cardkindid");
System.out.println(str6);
String str7="insert into o_card values('"+str6+"','"+text2+"','"+text5+"','"+text7+"','"+text8+"','"+text9+"','"+text6+"','"+id+"','"+i+"','"+text4+"','"+text3+"')";
db5.setInsert(str7);
}
String str="success1";
request.setAttribute("str",str);
try {
request.getRequestDispatcher("/successcq.jsp").forward(request,response);
} catch (ServletException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
} catch (IOException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
}
} catch (SQLException e) {
e.printStackTrace();
}
}
else if(a.equals("delete1")){ //删除名片
System.out.println("delet is success");
String delete=(String)session.getAttribute("delete");
String str="delete from o_card where name='"+delete+"' and empid='"+id+"'";
DateBase db=new DateBase();
db.setInsert(str);
String str1="success2";
request.setAttribute("str",str1);
try {
System.out.println("delete++++++++");
request.getRequestDispatcher("/successcq.jsp").forward(request,response);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
else if(a.equals("update")){//添加名片夹
System.out.println("update"+"=====");
String te=request.getParameter("text1");
String option=request.getParameter("sel");
int u;
if(option.equals("共享")){u=1;
}else{u=0;
}
HttpSession se=request.getSession();
DateBase db=new DateBase();
DateBase db1=new DateBase();
String st="select * from o_cardkind where empid='"+id+"'and kindname='"+te+"'";
rs=db1.getSet(st);
try {
if(rs.next()){
String t="a";
se.setAttribute("he",t);
try {
request.getRequestDispatcher("/error_1.jsp").forward(request,response);
} catch (ServletException e3) {
e3.printStackTrace();
} catch (IOException e3) {
e3.printStackTrace();
}
}else{
String str="insert into o_cardkind values(tmp_seq.nextval,'"+te+"','"+u+"','"+id+"')";
db.setInsert(str);
try {
String str1="success3";
request.setAttribute("str",str1);
request.getRequestDispatcher("/successcq.jsp").forward(request,response);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
} catch (SQLException e2) {
e2.printStackTrace();
}
}
else if(a.equals("up")){
System.out.println("hekkk");
String te=request.getParameter("text1");
System.out.println(te);
String st="select * from o_cardkind where empid='"+id+"'and kindname='"+te+"'";
DateBase da=new DateBase();
String t;
HttpSession se=request.getSession();
rs=da.getSet(st);
System.out.println("========+++++++++++=======");
boolean flag=false;
try {
if(rs.next()){
flag=true;
}
if(flag==false){
t="b";
se.setAttribute("he",t);
try {
request.getRequestDispatcher("/error_1.jsp").forward(request,response);
} catch (ServletException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
} catch (IOException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
}else{
t="a";
se.setAttribute("he",t);
try {
request.getRequestDispatcher("/error_1.jsp").forward(request,response);
} catch (ServletException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
} catch (IOException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else if(a.equals("update1")){
String b=(String)session.getAttribute("delete");
System.out.println("====++++++++=444444======"+b);
DateManger da=new DateManger();
list=(ArrayList)da.getView(b,id);
request.setAttribute("view",list);
try {
request.setAttribute("delete",b);
request.getRequestDispatcher("/updateCard.jsp").forward(request,response);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
else if(a.equals("hid3")){
System.out.println("+++heheh++");
String cardkindid=(String)session.getAttribute("card");
String kindname=(String)session.getAttribute("kindname");
System.out.println("cardkindid====="+cardkindid);
String text1=request.getParameter("text1");
String text2=request.getParameter("text2");
String text3=request.getParameter("text3");
String text4=request.getParameter("text4");
String text5=request.getParameter("text5");
String text6=request.getParameter("text6");
String text7=request.getParameter("text7");
String text8=request.getParameter("text8");
String option=request.getParameter("select2");
System.out.println(text1);
System.out.println(text2);
System.out.println(text3);
System.out.println(text4);
System.out.println(text5);
System.out.println(text6);
System.out.println(text7);
System.out.println(text8);
System.out.println(option);
int i;
if(option.equals("男")){
i=0;
}else{i=1;
}
String option1=request.getParameter("select1");
int u;
if(option1.equals("共享")){u=1;
}else{u=0;
}
System.out.println(i);
System.out.println(u);
DateBase db=new DateBase();
System.out.println("hello!!chenguangwu");
String str="update o_card set name='"+text2+"',mailbox='"+text6+"',position='"+text5+"',perphone='"+text8+"',department='"+text4+"',company='"+text3+"',officephone='"+text7+"',sex='"+i+"'where empid='"+id+"'and cardkindid='"+cardkindid+"'";
db.setInsert(str);
try {
String str1="success4";
request.setAttribute("str",str1);
request.getRequestDispatcher("/successcq.jsp").forward(request,response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else if(a.equals("share")){
String share=(String)request.getParameter("text1");
DateManger db=new DateManger();
ArrayList list1=(ArrayList)db.getView1(share);
request.setAttribute("share",list1);
try {
System.out.println("shareshare");
request.getRequestDispatcher("cardShare_2.jsp").forward(request,response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else if(a.equals("update3")){
String b=request.getParameter("text1");
System.out.println("===b=="+b);
String option=request.getParameter("sel");
int u;
if(option.equals("共享")){u=1;
}else{u=0;}
HttpSession sess=request.getSession();
String amend2=(String)sess.getAttribute("amend2");
DateBase dd=new DateBase();
String str2="select * from o_cardkind where empid='"+id+"'and kindname='"+b+"'and sharer='"+u+"'";
rs=dd.getSet(str2);
boolean pa=false;
DateBase db=new DateBase();
try {
if(rs.next()){
pa=true;
}
if(pa==true){
System.out.println("false");
try {
String str1="success6";
request.setAttribute("str",str1);
request.getRequestDispatcher("/successcq.jsp").forward(request,response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else{
String str="update o_cardkind set kindname='"+b+"',sharer='"+u+"'where cardkindid='"+amend2+"'and empid='"+id+"'";
db.setInsert(str);
try {
String str1="success5";
request.setAttribute("str",str1);
request.getRequestDispatcher("/successcq.jsp").forward(request,response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} catch (SQLException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
}
}
public static void main(String[] args) {
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -