javaJDBC 增删改查一个方法一条龙解决

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

public class onelong {
	//增删改查
	public ArrayList<EMP> oneLong(String sql) {
		ArrayList<EMP> arr = new ArrayList<EMP>();
		
		Connection conn=null;
		PreparedStatement pst=null;
		ResultSet res=null;
		try {
			conn=Mai.getConnection();
			pst=conn.prepareStatement(sql);
			if(sql.contains("SELECT")) {//判断是不是查询语句是查询语句就走下一步
				res =pst.executeQuery();
				while(res.next()) {
					String id = res.getString("id");
					String name = res.getString("name");
					EMP emp =new EMP();
					emp.setId(id);
					emp.setName(name);
					arr.add(emp);
					
				}
			}else {//不是查询语句进行常规操作
				pst.executeUpdate();
			}
			
			
			return arr;
			
		} catch (Exception e) {
			e.printStackTrace();
		}
		return arr;
	}
}

调用方法

import java.util.ArrayList;
import java.util.Scanner;

public class zeng {
	public static void main(String[] args) {
		onelong s1 = new onelong();
		Scanner scan = new Scanner(System.in);
//		String sql="SELECT * FROM `lx`.`xl`";
//		ArrayList<EMP>arr = s1.oneLong(sql);
//		for(int i=0;i<arr.size();i++) {
//			System.out.println(arr.get(i).getId()+" "+arr.get(i).getName());
//		}
		//增
//		String sql = "INSERT INTO `lx`.`xl`VALUES ("+scan.next()+", '3')";
//		s1.oneLong(sql);
		//删
//		String sql = "DELETE FROM `lx`.`xl` WHERE `id` = "+scan.next()+"";
//		s1.oneLong(sql);
		//改
//		String a =scan.next();
//		String b= scan.next();
//		String sql = "UPDATE `lx`.`xl` SET `id` = "+a+" WHERE `id` = "+b+"";
//		s1.oneLong(sql);
//		
	}
}

如果要添加英文需要添加单引号在sql语句后头

+"'"+scan.next()+"'"

因为在数据库中他是这样的 给我们的值后面添加一个字符型单引号即可

EMP类

public class EMP {
	private String id;
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	private String name;
	
}

数据库连接类

import java.net.ConnectException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collection;
import java.util.Comparator;
import java.util.HashMap;
import java.util.Scanner;



public class Mai {
	private static final String DRIVERNAME="com.mysql.jdbc.Driver";
	private static final String URL="jdbc:mysql://127.0.0.1:3306/lx";
	private static final String user="root";
	private static final String pwd="12345678";
	static {
		try {
			Class.forName(DRIVERNAME);
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	public static Connection getConnection() {
		Connection conn= null;
		try {
			return DriverManager.getConnection(URL,user,pwd);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
	}
	public static void main(String[] args) {
		Mai s1 = new Mai();
		System.out.println(s1.getConnection());
	}
	
}