preptrans.java

这是一个关于jsp的学习文档.为学习jsp的朋友提供方便

import java.sql.*;

public class PrepTrans {
	public static void main(String args[]) {
		String serverName = "192.168.100.139";
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");			
			String            url  = "jdbc:oracle:thin:@"+serverName+":1521:ora9";
			Connection        connOracle  = DriverManager.getConnection(url,"scott","tiger");
			Statement         stmt = connOracle.createStatement();
			ResultSet         rs   = stmt.executeQuery("select * from stock");
				   
		    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	
		    Connection        connAccess = DriverManager.getConnection("jdbc:odbc:Test","","");
			PreparedStatement pstmt = connAccess.prepareStatement("insert into stock values(?,?,?,?,?,?,?)");;
		   	while(rs.next()) { 			  
		    	  pstmt.setString(1,rs.getString("stockid"));
				  pstmt.setString(2,rs.getString("stockname"));
				  pstmt.setDouble(3,rs.getFloat("shoupan"));
				  pstmt.setDouble(4,rs.getFloat("zhangdie"));
				  pstmt.setDouble(5,rs.getFloat("stockmax"));
				  pstmt.setDouble(6,rs.getFloat("stockmin"));
				  pstmt.setDouble(7,rs.getFloat("stocknum"));			 
				  pstmt.executeUpdate();
 			}
			rs.close();
			stmt.close();
			pstmt.close();
			connOracle.close();
			connAccess.close();
		}catch(Exception e){
		 		e.printStackTrace();
		}
	}
}