simplejdbc_wangkj.java

java的团队合作代码

package com.jk.jdbc;

import java.sql.*;
public class simplejdbc_wangkj {
       public static void main(String[] args){
	// 初始化变量
    	   String driver=
    		   "oracle.jdbc.driver.OracleDriver";
    	   String url = 
    		   "jdbc:oracle:thin:@10.22.78.99:1521:XE";
    	   
    	   String userName = "wangkj";
    	   String passwd = "xinxin";
    		   // 定义jdbc操作的变量
    		   
    	Connection conn = null;
    	Statement stmt = null;
    	ResultSet rs = null;
    	try{
    		//1,register a dirvre 
    		Class.forName(driver);
    		//2,get a Connection
    		conn=
    			DriverManager.getConnection(url,userName,passwd);
    		//3,get Statement
    		stmt = conn.
    	   createStatement();
    		String sql = "select id,name from test";
    		
    		//4,execute sql
    		rs = stmt.executeQuery(sql);
    		
    		//5, resultSet
    		while(rs.next()){
    			System.out.print(rs.getInt("id")+" ");
    			System.out.print(rs.getString(2));
    		}
    	}catch(Exception e){
    		e.printStackTrace();
    	}finally{
    		try{
    			if(rs!=null)  rs.close();
    			if(stmt!=null)  stmt.close();
    			if(conn!=null)  conn.close();
    		}catch(Exception e){
    			e.printStackTrace();
    		}
    	}
    	
}
}