JDBC maven 删除 查询 注入及处理

在数据库创建一个表：

eclipse中结构为：

在pom.xml中添加servlet和MySQL jar包：

这里我直接列出来了：

servlet jar:

<dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>javax.servlet-api</artifactId>
    <version>3.0.1</version>
    <scope>provided</scope>
</dependency>

MySQL jar:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.0.8</version>
</dependency>

这样前期工作就准备好了。

然后开始连接数据库，进行删除：

package com.jd;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class Test {
	public static void main(String[] args) {
		
		Connection connection=null;
		Statement statement=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url="jdbc:mysql://127.0.0.1:3306/test";
			connection=DriverManager.getConnection(url,"root","root");
		     statement=connection.createStatement();
			String sql="delete from user_info where id =123";
			int effect=statement.executeUpdate(sql);
				if(effect>0) {
					System.out.println("YES");
					return;
			}
		}catch (Exception e) {
			
				e.printStackTrace();
			}	finally {//释放资源
			try {
				if(connection!=null) {
					connection.close();
				}
			} catch (SQLException e) {
				
				e.printStackTrace();
			}
			try {
				if(statement!=null) {
					statement.close();
				}
			} catch (SQLException e) {
				
				e.printStackTrace();
			}
		}
		
		}

 
}

 

package com.jd;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Testt {
	
	public static void main(String[] args) {
		Connection connection=null;
		Statement statement=null;
		ResultSet resultSet=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url="jdbc:mysql://127.0.0.1:3306/test";
			connection=DriverManager.getConnection(url,"root","root");
			statement=connection.createStatement();
			String sql="select id,name,mobile,address from user_info";
			resultSet =statement.executeQuery(sql);
			
			while(resultSet.next()) {
				String id =resultSet.getString("id");
				String name =resultSet.getString("name");
				String mobile =resultSet.getString("mobile");
				String address =resultSet.getString("address");
				System.out.println(id+ name+ address+ mobile);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			try {
				if(resultSet!=null) {
					resultSet.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				if(statement!=null) {
					statement.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				if(connection!=null) {
					connection.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
}

package com.jd;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class Test3 {

	public static void main(String[] args) {
		Connection connection = null;
		Statement statement = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url = "jdbc:mysql://127.0.0.1:3306/test";
			connection = DriverManager.getConnection(url, "root", "root");
			statement = connection.createStatement();
			Scanner scanner = new Scanner(System.in);
			String id = scanner.nextLine();
			String sql = "delete from user_info where id='"+id+"'";
			if (statement.executeUpdate(sql) > 0) {
				System.out.println("YES");
				return;
				
			}
			System.out.println("NO");
		} catch (Exception e) {
			e.printStackTrace();
		} finally {

			try {
				if (statement != null) {
					statement.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				if (connection != null) {
					connection.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

}

package com.jd;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Scanner;

public class Test4 {

	public static void main(String[] args) {
		Connection connection = null;
		PreparedStatement prepareStatement=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url = "jdbc:mysql://127.0.0.1:3306/test";
			connection = DriverManager.getConnection(url, "root", "root");
			
			Scanner scanner = new Scanner(System.in);
			String id = scanner.nextLine();
			String sql = "delete from user_info where id=?";
		    prepareStatement =connection.prepareStatement(sql);
			prepareStatement.setObject(1,id);
			if (prepareStatement.executeUpdate() > 0) {
				System.out.println("YES");
				return;
				
			}
			System.out.println("NO");
		} catch (Exception e) {
			e.printStackTrace();
		} finally {

			try {
				if (prepareStatement != null) {
					prepareStatement.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				if (connection != null) {
					connection.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

}