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

比眉伴天荒 2022-05-25 03:53 75阅读 0赞

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

[https://blog.csdn.net/lijia111111/article/details/80185288][https_blog.csdn.net_lijia111111_article_details_80185288]

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

![70][]

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

![70 1][]

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、运行结果如下：

![70 2][]

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、运行结果：

![70 3][]

[https_blog.csdn.net_lijia111111_article_details_80185288]: https://blog.csdn.net/lijia111111/article/details/80185288
[70]: /images/20220525/88201f9d8d3f4098b452d2d2bc170c19.png
[70 1]: /images/20220525/140878c7f23249878d74f07f670c49a1.png
[70 2]: /images/20220525/f6440eb2531445849e9d12e60f93982a.png
[70 3]: /images/20220525/f6a4deeedc1f484ab9db27075e16c090.png