Statement语句实现数据库的增删改查操作

 DButil.java

import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

import com.mysql.jdbc.Connection;

public class DButil {
		/*
		 * 打开数据库
		 */
	    private static String driver;//连接数据库的驱动
	    private static String url;
	    private static String username;
	    private static String password;
	    
	    static {
	    	driver="com.mysql.jdbc.Driver";//需要的数据库驱动
	    	url="jdbc:mysql://localhost:3306/test";//数据库名路径
	    	username="root";
	    	password="root";
	    }
		public static Connection open()
		{
			try {
				Class.forName(driver);
				return (Connection) DriverManager.getConnection(url,username, password);
			} catch (Exception e) {
				System.out.println("数据库连接失败！");
				// TODO Auto-generated catch block
				e.printStackTrace();
			}//加载驱动

			return null;
		}
        
		/*
		 * 关闭数据库
		 */
		public static void close(Connection conn)
		{
			if(conn!=null)
			{
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}

}

TestData.java

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class TestData {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
         // CreateTable();
		//insert();
		//update();
		//delete();
		query();
		//Query()
	}
	
	static void CreateTable()
	{
		Connection conn=DButil.open();
		String sql="create table UserTable(id int not null primary key auto_increment,name varchar(20) not null)";
		try {
			Statement stmt=(Statement) conn.createStatement();
			stmt.execute(sql);//执行该条语句
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			DButil.close(conn);
		}
	}
	
	static void insert()
	{
		Connection conn=DButil.open();
		String sql="insert into UserTable(id,name) value (1001,'zhangsan'),(1002,'lisi') ,(1003,'wangwu'),(1004,'liliu')";
		try {
			Statement stmt=(Statement) conn.createStatement();
			stmt.executeUpdate(sql);//执行更新该表
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			DButil.close(conn);
		}
	}
	
	static void update()
	{
		Connection conn=DButil.open();
		String sql="update UserTable set name='Haige' where id=1003";
		try {
			Statement stmt=(Statement) conn.createStatement();
			stmt.executeUpdate(sql);//执行更新该表
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			DButil.close(conn);
		}
	}
	
	static void delete()
	{
		Connection conn=DButil.open();
		String sql="delete from UserTable where id=1004";
		try {
			Statement stmt=(Statement) conn.createStatement();
			stmt.executeUpdate(sql);//执行更新该表
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			DButil.close(conn);
		}
	}
	
	static void query()
	{
		Connection conn=DButil.open();
		String sql="select * from UserTable";
		try {
			Statement stmt=(Statement) conn.createStatement();
			ResultSet rs=stmt.executeQuery(sql);//执行查询该表
			while(rs.next())
			{
				int id=rs.getInt(1);
				String name=rs.getString(2);
				System.out.println(id+","+name);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			DButil.close(conn);
		}
	}
	/*
	 * 集合类封装输出查询结果
	 */
	static List<User> Query()
	{
		Connection conn=DButil.open();
		String sql="select * from UserTable";
		try {
			Statement stmt=(Statement) conn.createStatement();
			ResultSet rs=stmt.executeQuery(sql);//执行查询该表
			List<User> list=ArrayList<User>();
			while(rs.next())
			{
				int id=rs.getInt(1);
				String name=rs.getString(2);
				//System.out.println(id+","+name);
				User user=new User();
				user.setId(id);
				user.setName(name);
				list.add(user);
			}
			System.out.println(list);
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			DButil.close(conn);
		}
		
		return null;
	}

}

User.java

public class User {
	 private int id;
	 private String name;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	 @Override
	public String toString() {
		// TODO Auto-generated method stub
		return id+":"+name;
	}
}

 操作过程截图：