在java中有关sql注入的问题

package web;

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import util.DBUtil;

public class LoginServlet extends HttpServlet{ 
		public void service(HttpServletRequest req,HttpServletResponse res)
				throws ServletException,IOException{  
			Connection conn =null;			
		 try{
			conn = DBUtil.getConnection();
			Statement stat = conn.createStatement();
			
			String username = req.getParameter("username");
			String pwd =req.getParameter("pwd");
			
			//System.out.println("pwd的值:"+pwd);
			//将pwd的值定义为:ddd' or '1'='1 就可以注入sql语句了。
			//select * from t_u where username='zs' and pwd='ddd' or '1'='1' 
			String sql="select * from t_u where username='"+username+"' and pwd='"+pwd+"'";
			//SQL注入--因为sql注入的问题,在java中尽量避免使用Statement来创建sql语句封装对象
			//String sql="select * from t_u where username='"+username+"' and pwd='"+pwd+"' or 1 = 1";
			System.out.println(sql);
			ResultSet rst= stat.executeQuery(sql);
			
			if(rst.next()){
				System.out.println("success");
			 }else{
				System.out.println("fail");
			      }
			
		}catch(Exception e){
				e.printStackTrace();
				throw new ServletException(e);
			}
			
			
		}


}



package com.tarena.dingdang.filter; 02 03 import java.io.IOException; 04 import java.util.Enumeration; 05 06 import javax.servlet.Filter; 07 import javax.servlet.FilterChain; 08 import javax.servlet.FilterConfig; 09 import javax.servlet.ServletException; 10 import javax.servlet.ServletRequest; 11 import javax.servlet.ServletResponse; 12 import javax.servlet.http.HttpServletRequest; 13 14 public class AntiSqlInjectionfilter implements Filter { 15 16 public void destroy() { 17 // TODO Auto-generated method stub 18 } 19 20 public void init(FilterConfig arg0) throws ServletException { 21 // TODO Auto-generated method stub 22 } 23 24 public void doFilter(ServletRequest args0, ServletResponse args1, 25 FilterChain chain) throws IOException, ServletException { 26 HttpServletRequest req=(HttpServletRequest)args0; 27 HttpServletRequest res=(HttpServletRequest)args1; 28 //获得所有请求参数名 29 Enumeration params = req.getParameterNames(); 30 String sql = ""; 31 while (params.hasMoreElements()) { 32 //得到参数名 33 String name = params.nextElement().toString(); 34 //System.out.println("name===========================" + name + "--"); 35 //得到参数对应 36 String[] value = req.getParameterValues(name); 37 for (int i = 0; i < value.length; i++) { 38 sql = sql + value[i]; 39 } 40 } 41 //System.out.println("============================SQL"+sql); 42 //有sql关键字,跳转到error.html 43 if (sqlValidate(sql)) { 44 throw new IOException("您发送请求的参数含有非法字符"); 45 //String ip = req.getRemoteAddr(); 46 } else { 47 chain.doFilter(args0,args1); 48 } 49 } 50 51 //效验
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值