java利用JDBC实现对数据库的增删改查模板！！

数据持久化：增、删、改、查模板

查询语句

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

Scanner input=new Scanner(System.in);
		Connection con=null;
		PreparedStatement pre=null;
		ResultSet resu=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");	con=DriverManager.getConnection("jdbc:mysql://localhost:3306/epet","root","admin");
			String sql="SELECT * FROM master WHERE NAME=? AND `password`=?";//执行查询操
			pre=con.prepareStatement(sql);
			
			pre.setString(1, name);
			pre.setString(2, password);
			
			resu=pre.executeQuery();
			if (resu.next()) {
				System.out.println("查询成功！");
			}else {
				System.out.println("查询失败！");
			}
		} catch (Exception e) {
			// TODO: handle exception
		}finally{
			try {
				resu.close();
				pre.close();
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}

新增语句

Scanner input=new Scanner(System.in);
		Connection con=null;
		PreparedStatement pre=null;
		ResultSet resu=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/epet","root","admin");
			String sql2="INSERT INTO dog(`name`,`health`,`love`,`strain`)VALUES(?,?,?,?)";//执行新增操作
			pre=con.prepareStatement(sql2);
		
			pre.setString(1, "小舞");
			pre.setString(2, "90");
			pre.setString(3, "89");
			pre.setString(4, "杜宾犬");
			
			int result=pre.executeUpdate();
			if (result>0) {
				System.out.println("新增成功！");
			}else {
				System.out.println("新增失败！");
			}
		} catch (Exception e) {
			// TODO: handle exception
		}finally{
			try {
				pre.close();
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}

删除语句

Scanner input=new Scanner(System.in);
		Connection con=null;
		PreparedStatement pre=null;
		ResultSet resu=null;
		try {	
			Class.forName("com.mysql.jdbc.Driver");
			con=DriverManager.getConnection("jdbc:mysql://localhost:3306/epet","root","admin");
			String sql3="delete FROM dog WHERE `id`=?";//执行删除操作
			pre=con.prepareStatement(sql3);
			
			pre.setInt(1, 7);
			
			int result=pre.executeUpdate();
			if (result>0) {
				System.out.println("删除成功！");
			}else {
				System.out.println("删除失败！");
			}
		} catch (Exception e) {
			// TODO: handle exception
		}finally{
			try {
				pre.close();
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}

更改语句

Scanner input=new Scanner(System.in);
		Connection con=null;
		PreparedStatement pre=null;
		ResultSet resu=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			con=DriverManager.getConnection("jdbc:mysql://localhost:3306/epet","root","admin");
			String sql4="UPDATE dog SET `name`=?,`health`=?,`love`=?,`strain`=? WHERE `id`=5";//执行更改操作
			pre=con.prepareStatement(sql4);
			
			pre.setString(1, "小舞");
			pre.setString(2, "90");
			pre.setString(3, "89");
			pre.setString(4, "杜宾犬");
			
			int result=pre.executeUpdate();
			if (result>0) {
				System.out.println("更改成功！");
			}else {
				System.out.println("更改失败！");
			}
		} catch (Exception e) {
			// TODO: handle exception
		}finally{
			try {
				pre.close();
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}