12.4
今天继续写昨天的web 系统，谢了servlet 层,没有遇到什么问题，明天计划继续写web 系统,吧jsp页面做一部分。
代码部分:
package servlet;
import java.io.IOException;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.newjavaweb.User;
import Dao.userdao;
/**
* Servlet implementation class Servlet
*/
@WebServlet("/Servlet")
public class Servlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public Servlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
request.setCharacterEncoding("utf-8");
response.setContentType("textml;charset=utf-8");
userdao dao=new userdao();
java.util.List<User> list= new ArrayList<User>();
String p[] = new String[5];//获得条件
String s[] = new String[5];//获得内容
String g[] = new String[5];//获得关系
String f[] = new String[5];//获得精确或者模糊
String number = null;
//String number1 = null;
number=request.getParameter("number1");
//number1=request.getParameter("number2");
int n = Integer.parseInt(number);//接收条件的个数
//int n1 = Integer.parseInt(number1);// յĹ ϵ ĸ
for(int i=1;i<=n;i++){
p[i]= (String) request.getParameter("s"+i);
s[i]=(String)request.getParameter("shuru"+i);
f[i]=(String)request.getParameter("c"+i);
System.out.println("精确还是模糊 "+f[i]);
System.out.println("条件 "+p[i]);
System.out.println("输入 "+s[i]);
if(p[i].equals("学号")){
p[i] = "id";
}
else if(p[i].equals("姓名")){
p[i] = "name";
}else if(p[i].equals("班级"))
{
p[i] = "clas";
}else if(p[i].equals("课程")){
p[i] = "ke";
}else if(p[i].equals("分数")){
p[i] = "score";
}
}
for(int i=1;i<n;i++){
g[i]=(String) request.getParameter("g"+i);
if(g[i].equals("且")) {
g[i]="and";
}else if(g[i].equals("或")) {
g[i]="or";
}
System.out.println("且或"+g[i]);
}
String sql="where ";
for(int i=1;i<n;i++){
if(s[i].equals("")){
continue;
}
if(f[i].equals("精确")){
sql=sql+p[i]+"='"+s[i]+"'"+" "+g[i]+" ";
}else if(f[i].equals("模糊")){
sql=sql+p[i]+" "+"LIKE"+" "+"'%"+s[i]+"%'"+" "+g[i]+" ";
}
}
if(f[n].equals("精确")) {
sql = sql + p[n]+"="+"'"+s[n]+"'";
}
else {
sql = sql + p[n]+" "+"LIKE"+" "+"'%"+s[n]+"%'";
}
if(n==1&&s[1].equals("")){
System.out.println("什么也没传！");
sql="";
}
list = dao.loadview(sql);
if(list.size()!=0) {
request.setAttribute("allthing",list);
request.setAttribute("message", "查询成功");
request.getRequestDispatcher("checkall.jsp").forward(request,response);
}
else {
request.setAttribute("message", "查询失败");
request.getRequestDispatcher("selectmore.jsp").forward(request,response);
}
// HttpSession session = request.getSession();
// session.setAttribute("tiaojian", list);
//// int servletid=1;
//// request.setAttribute("list", list);
//// request.setAttribute("servletid", servletid);
// try {
//// request.getRequestDispatcher("/admin/123.jsp").forward(request, response);
// response.sendRedirect(request.getContextPath()+"ow.jsp");
// } catch (IOException e) {
// // TODO Զ ɵ catch
// e.printStackTrace();
// }
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
package servlet;
import java.io.IOException;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.JOptionPane;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import com.newjavaweb.User;
import Dao.userdao;
import util.DBUtil;
import java.util.List;
/**
* Servlet implementation class UserServlet
*/
@WebServlet("/UserServlet")
public class UserServlet extends HttpServlet {
static String wen;
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public UserServlet() {
super();
// TODO Auto-generated constructor stub
}
userdao dao = new userdao();
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
String method = req.getParameter("method");
if ("add".equals(method))
{
add(req, resp);
}
else if("search".equals(method))
{
search(req, resp);
}
else if("delete".equals(method))
{
delete(req,resp);
}
else if("allall".equals(method))
{
allall(req,resp);
}
else if("look".equals(method))
{
look(req,resp);
}
else if("update".equals(method))
{
update(req,resp);
}
else if("deletecheck".equals(method))
{
deletecheck(req,resp);
}
else if("paixu".equals(method))
{
paixu(req,resp);
}
}
private void search(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
// TODO Auto-generated method stub
req.setCharacterEncoding("utf-8");
String zhanghu = req.getParameter("zhanghu");
String psw = req.getParameter("psw");
String rpassword = dao.search(zhanghu);
String yanzheng1=req.getParameter("code");
String yanzheng=(String)req.getSession().getAttribute("code");
if(!yanzheng1.equals(yanzheng))
{
req.setAttribute("message", "验证码错误");
req.getRequestDispatcher("login.jsp").forward(req,resp);
}
if(psw.equals(rpassword)) {
//JOptionPane.showMessageDialog(null,"登陆成功！");
req.setAttribute("message", "登陆成功！");
req.getRequestDispatcher("NewFile.jsp").forward(req,resp);
}
else {
//JOptionPane.showMessageDialog(null,"账号不存在或密码错误！");
req.setAttribute("message", "账号不存在或密码错误！");
req.getRequestDispatcher("login.jsp").forward(req,resp);
}
}
private void add(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
// TODO Auto-generated method stub
String id=req.getParameter("id");
String name=req.getParameter("name");
String clas=req.getParameter("clas");
String ke=req.getParameter("ke");
String score=req.getParameter("score");
User user= new User(id,name,clas,ke,score);
String rusername = dao.find(name);
if(!name.equals(rusername)) {
dao.add(user);
req.setAttribute("message", "添加成功!");
req.getRequestDispatcher("UserServlet?method=allall").forward(req, resp);
}else {
req.setAttribute("message", "账户重复，请重新输入!");
req.getRequestDispatcher("zc.jsp").forward(req, resp);
}
}
private void deletecheck(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException
{
req.setCharacterEncoding("utf-8");
String name =req.getParameter("name4");
String rusername = dao.find(name);
if(!name.equals(rusername))
{
req.setAttribute("message", "用户不存在请重新输入");
req.getRequestDispatcher("delete.jsp").forward(req, resp);
return;
}
List<User> Thething1 =dao.examine(name);
req.setAttribute("Thething1", Thething1);
req.getRequestDispatcher("deletecheck2.jsp").forward(req, resp);
}
private void delete(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException{
req.setCharacterEncoding("utf-8");
String name=req.getParameter("name");
boolean wen=dao.delete(name);
if(wen)
{
req.setAttribute("message", "删除成功！");
req.getRequestDispatcher("delete1.jsp").forward(req,resp);
}
else
{
req.setAttribute("message", "此用户不存在，删除失败");
req.getRequestDispatcher("delete.jsp").forward(req,resp);
}
}
private void paixu(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException
{
req.setCharacterEncoding("utf-8");
List<User> things =dao.paixu();
req.setAttribute("things", things);
req.getRequestDispatcher("examine2.jsp").forward(req, resp);
}
private void allall(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException
{
req.setCharacterEncoding("utf-8");
List<User> allthing = dao.theall();
req.setAttribute("allthing", allthing);
req.getRequestDispatcher("checkall.jsp").forward(req,resp);
}
private void look(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException
{
req.setCharacterEncoding("utf-8");
String name5 = req.getParameter("name5");
wen=name5;
String q1=dao.find(name5);
if(q1.equals("@"))
{
req.setAttribute("message", "此用户不存在，不能进行修改");
req.getRequestDispatcher("updatesome.jsp").forward(req,resp);
return;
}
User user3 = dao.getUserbyzhanghu(name5);
req.setAttribute("user3", user3);
req.getRequestDispatcher("updatesome1.jsp").forward(req,resp);
}
private void update(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException
{
req.setCharacterEncoding("utf-8");
String id=req.getParameter("id6");
String name = req.getParameter("name6");
String clas=req.getParameter("clas6");
String ke=req.getParameter("ke6");
String score=req.getParameter("score6");
User user= new User(id,name,clas,ke,score);
dao.update(user,name);
req.setAttribute("message", "修改成功");
req.getRequestDispatcher("updatesome2.jsp").forward(req,resp);
}
}