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

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);
		}
	}
}