Java对数据库进行增删该查操作

悠悠 2022-01-30 07:41 257阅读 0赞

package com.itcast.test;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    import com.itcast.util.JDBCUtil;
    
    import java.sql.Connection;
    public class Test1 {
    
    	
    
    	public static void main(String[] args) {
    		ResultSet rs = null;
    		Connection conn = null;
    		Statement st = null;
    		
    		try {
    			//注册驱动
    			//DriverManager.registerDriver(new com.mysql.jdbc.Driver());
    			//建立连接：参数1：协议+访问数据库 参数2：用户名 参数3：密码
    			 conn=DriverManager.getConnection("jdbc:mysql://localhost/teacher","root","");
    			//创建statement
    			 st=conn.createStatement();
    			//执行添加，得到结果集
    			/*String sql="INSERT INTO t_teacher VALUES (null,'aobama',21)";
    			 int result=st.executeUpdate(sql);
    			 if(result>0) {
    				System.out.println("添加成功");
    			}else{
    			    System.out.println("添加失败");
    			}
    			*/
    			 //执行删除
    			 /*String sql ="delete from t_teacher where name='lala' ";
    			 int result=st.executeUpdate(sql);
    			 if(result>0) {
    					System.out.println("删除成功");
    				}else {
    			System.out.println("删除失败");
    				}
    				*/
    			 //修改
    			 String sql ="update t_teacher set age=100 where name='lisi' ";
    			 int result=st.executeUpdate(sql);
    			 if(result>0) {
    					System.out.println("修改成功");
    				}else {
    			System.out.println("修改失败");
    				}
    		
    		} catch (SQLException e) {
    			// TODO 自动生成的 catch 块
    			e.printStackTrace();
    		}
    		finally {
    			JDBCUtil.release(rs, st, conn);
    		}
    	}
    }