make.java

非常常用的几个SQL语言,连接数据库的操作java中JDBC技术经常要用到

import java.lang.*;
import java.io.*;
import java.sql.*;
class HelloWorld{
     public static void main(String args[])throws Exception{           
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          String sourceURL="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="
          +("a.mdb");
          Connection databaseConnection=DriverManager.getConnection(sourceURL);  
          Statement st=databaseConnection.createStatement();
          
          //String sql="Insert INTO abc ";
        //String sql="UPDATE abc SET name='woaini'"+"WHERE id=2";//modify the list
          //String sql="DELETE FROM abc "+"WHERE id=2";
          String sql="INSERT INTO abc"+"(id,num,name)"
          +"VALUES(8,678,'hehe')";// "+"WHERE id=2";
          int i=st.executeUpdate(sql);
         
          String getString="SELECT * FROM abc ";
          //String getString="Select id,num,name FROM abc WHERE id=2";
          
          int id,num;
          String name;          
          ResultSet rs=st.executeQuery(getString);
          while(rs.next()){
          	id=rs.getInt("id");
          	num=rs.getInt("num");
          	name=rs.getString("name");     	
           	System.out.println(id+" "+num+" "+name);
          }
          rs.close();                 
          databaseConnection.close();
          System.out.println("Hello world!");      
                  
     }
     
     
     

}