JAVA JDBC访问数据库标准代码

 package edu.zzu.jdbc.Test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import com.ambow.jdbc.entity.Student;
public class TestDBConn{
 
 public static void main(String args[]){
  
  String url="jdbc:sqlserver://localhost:1433;databaseName=zzu";
  String username="sa";
  String password="123456";
  Connection conn =null;
  Statement stmt =null;
  ResultSet rs =null;
  
     try {
      //1、加载驱动
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
   //2、通过DriverManagee获取连接包括(数据库连接字符串,用户名,密码)
   conn = DriverManager.getConnection(url, username, password);
   //3、通过 Connection 对象来创建 createStatement
   stmt = conn.createStatement();
   //4、自定义 SQL 语句
//   String sql = " select * from student "; 
   String sql = "insert into student values (?,?,?) "; 
   //5、通过 statement 对象来执行 SQL 语句，并且返回结果给 ResultSet
   rs =stmt.executeQuery(sql);
   while(rs.next()){
    System.out.print(rs.getInt("id")+" ");
    System.out.print(rs.getString("name")+" ");
    System.out.println(rs.getString("password"));
   }
  } catch (Exception e) {
   e.printStackTrace();
  } finally{
   try{
    if(conn!=null){
     conn.close();
     conn=null;
    }
    if(stmt!=null){
     stmt.close();
     stmt=null;
   &n