使用Java连接数据库，并对数据库进行增删改查

首先添加一个类，用于连接数据库

package database;



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

public class Connect {

	private static Statement stat;
	private static void init() throws ClassNotFoundException, SQLException{
		Class.forName("com.mysql.jdbc.Driver");
		String url="jdbc:mysql://localhost:3306/Test?characterEncoding=utf-8";
		String user = "root";
		String password = "123";
		Connection con = DriverManager.getConnection(url,user,password);
		stat = con.createStatement();
	}
	public static Statement getStat() throws ClassNotFoundException, SQLException{
		if(stat == null) {
			init();
		}
		return stat;
	}
}

再添加一个类，用于对数据库的增删改查

package database;

import java.sql.ResultSet;
import java.sql.SQLException;

public class Link {

	public static void main(String[] args) {
		// TODO 自动生成的方法存根
		 Link1 l=new  Link1();//查询
		Link2 l2=new  Link2();//添加
		 Link3 l3=new Link3();//修改
		 Link4 l4=new Link4();//删除
	}

}
class Link1{//查询表记录
	public Link1() {
		
		System.out.println("查询表内容---------");	
	//String	sql = "select * from ceshi  where  test1='dd' "; 
		String	sql = "select * from ceshi  "; 
	try {
		ResultSet res = Connect.getStat().executeQuery(sql);
		while (res.next()) {
		String s=res.getString(1);
		String s2=res.getString(2);
		String s3=res.getString(3);
		System.out.println("查询到的表内容为为"+s+"  "+s2+"  "+s3);	
		}
		res.close();
	
	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	
	} catch (SQLException e) {
		// TODO 自动生成的 catch 块
		e.printStackTrace();
	}
}
}
class Link2{//添加表记录
	public Link2() {
		System.out.println(" ");	
		System.out.println("添加表内容---------");	
		String s1="1",s2="2",s3="3";
		  String  sql = "insert into ceshi values('"+s1+"','"+s2+"','"+s3+"')";
			
			
			int num;
			try {
				num = Connect.getStat()
						.executeUpdate(sql);
				if (num != 0) {
					System.out.println("添加成功");
			
				} else {
					System.out.println("添加失败");
				
				}	
			} catch (ClassNotFoundException e) {
				// TODO 自动生成的 catch 块
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO 自动生成的 catch 块
				e.printStackTrace();
			}
			
		
	}
}
class Link3{//更改表记录
	public Link3() {
		System.out.println(" ");	
		System.out.println("更改表内容---------");	
		String s1="我被修改了";
		String s2="我也被修改了";
	String	 sql="update ceshi   set    test1    ='"+s1+"', test2    ='"+s2+"'   where test3='9' ";
		
		
		
		try {
		int num = Connect.getStat()
				.executeUpdate(sql);
		if (num != 0) {
			System.out.println("修改成功");

		} else {
			System.out.println("修改失败");

		}
	
	} catch (ClassNotFoundException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	} catch (SQLException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	}
		
	}
}

class Link4{//删除表记录
	public Link4() {
		System.out.println(" ");	
		System.out.println("删除表内容---------");	
	String	  sql="delete from ceshi where test1='dd'";

     		
  		try {
  			int num = Connect.getStat()
  					.executeUpdate(sql);
  			
  			if (num != 0) {
  				System.out.println("删除成功");
  				 Link1 l=new  Link1();//查询
  			} else {
  				System.out.println("删除失败");

  			
  		
  			}	} catch (ClassNotFoundException e1) {
  			// TODO Auto-generated catch block
  			e1.printStackTrace();
  		} catch (SQLException e1) {
  			// TODO Auto-generated catch block
  			e1.printStackTrace();
  		}	
		
		
	}
}
	
	

用到的表结构，

表数据，

最后，代码的运行结果