Statement实现使用封装后的jdbc工具完成一次查询和修改

1、首先需要安装MySQL数据库，具体安装见文档：

https://blog.csdn.net/lijia111111/article/details/80185288

2、安装Navicat软件连接MySQL数据库并且新建数据内容，如何连接略

3、将mysql-connector-java-5.1.18.jar包直接复制到lib下

4、src下新建JDBCtest的java文件，进行插入学生信息代码如下：

package test;  
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCtest {    //code by 李佳
		public  static  void  main(String args[]){
		Connection conn = null;
		Statement stmt = null;
		int  k ;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			 conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/MySQL", "root", "root");
			 stmt = conn.createStatement();
			 String sql = "insert into student(name,id,age) values('lijia','5005','20')";
			 k =  stmt.executeUpdate(sql);			  
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try {
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
	}

}

5、运行结果如下：

6、查询学生信息代码如下：

package test;  
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCtest {    //code by 李佳
		public  static  void  main(String args[]){
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null ;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			 conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/MySQL", "root", "root");
			 stmt = conn.createStatement();
			 String sql = "select * from student";
			 rs =  stmt.executeQuery(sql);	
			 while(rs.next())
			 {
				 System.out.println(rs.getString("name"));
			 }
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try {
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
	}

}

7、运行结果：