JDBC执行SQL语句——搜索删除

package jdbc.test;

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

import org.junit.Test;

public class JDBCTest01 {
	public static void main(String[]args) {
		//在这里可以按着教程的思路，不错的，先将整个try/catch的结构处理，
		//finally的最起码保险写完在写try，这样的话起码保证了元素的正常关闭
		Connection conn = null;
		Statement stmt = null;
		try
		{
			DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/newdatabase?serverTimezone=GMT%2B8","root","123456");
			stmt = conn.createStatement();
			String sql = "delete from theone where oneno = 1";
			int count = stmt.executeUpdate(sql);
			System.out.println(count==1 ? "保存成功":"保存失败");
		}catch(Exception e) 
		{
			e.printStackTrace();
		}
		finally 
		{
			if(stmt != null) 
			{
				try {
					stmt.close();
				}catch(Exception e) 
				{
					e.printStackTrace();
				}
			}
				
			if(conn != null) 
			{
				try {
					conn.close();
				}catch(Exception e) 
				{						
					e.printStackTrace();
				}
			}	
		}	
	}			
}