insertrows.java

来自「j2EE」· Java 代码 · 共 53 行

import java.sql.*;

public class InsertRows
{
  	public static void main(String args[]) 
	{
	        Connection con;
	        Statement stmt;
    	try 
	{
       		 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         	}
	 catch(java.lang.ClassNotFoundException e) 
	{
        		System.err.print("ClassNotFoundException: "); 
		System.err.println(e.getMessage());
    	}
    
	try {
		        con = DriverManager.getConnection("jdbc:odbc:test1");
		        stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
		        ResultSet.CONCUR_UPDATABLE);
		        ResultSet uprs = stmt.executeQuery("SELECT * FROM emp");
		        uprs.moveToInsertRow();
		        uprs.updateString(1, "Amit");
		        uprs.updateString(2,"30");
		        uprs.updateInt(3, 6500);
		        uprs.insertRow();

		        uprs.beforeFirst();
	
		        System.out.println("Table Emp after insertion:");
		        while (uprs.next()) 
			{
			            String name = uprs.getString(1);
			            String age = uprs.getString(2);
			            int Salary= uprs.getInt(3);
		                      
			            System.out.print(name + "\t" + age + "\t " + Salary);
		
			}        

        uprs.close();
        stmt.close();
        con.close();

    } catch(SQLException ex) 
	{
	        System.err.println("SQLException: " + ex.getMessage());
    	}

}
}