testdml.java

来自「JDBC连接数据库的简单源码 可以下载后来指点下有什么不足」· Java 代码 · 共 32 行

import java.sql.*;
public class TestDML {
public static void main(String[] args) {
     Statement stmt = null;
     Connection conn = null;
     try{
    	 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    	 conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bujianhu","sa","gui");
    	 stmt= conn.createStatement();
    	 String sql = "insert into student values('96009','小燕','dS','45',25,'女')";
    	 stmt.executeUpdate(sql);
     }catch (ClassNotFoundException e){
    	 e.printStackTrace();
     }catch (SQLException e){
    	 e.printStackTrace();
     }finally{
    	 try {
    		 if(stmt!=null){
    			 stmt.close();
    			 stmt = null;
    		 }
    		 if(conn!=null){
    			 conn.close();
    			 conn = null;
    		 }
    	 }catch (SQLException e){
    		 e.printStackTrace();
    	 	}
     	}
	}
}