jdbcinserttest.java

java 北大青鸟 java 北大青鸟

/** (c)北大青鸟APTECH
* 版权所有
  */

import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;

/** 这个类演示访问数据库需遵循的不同步骤.
* @version 1.0, 2005 年 8 月 26 日
* @author Ben
  */

class JdbcInserttest{

/** 构造方法. */

protected JdbcInserttest() {
    }

/** 这是 main 方法.
 *  它演示访问数据库的不同步骤
 *  @param args 被传递至 main 方法
 */

public static void main(String [] args) {

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    } catch (ClassNotFoundException ce) {
System.out.println(ce);
    }
try {
        String url = "jdbc:odbc:test";
Connection con = DriverManager.getConnection(url);
        Statement stmt = con.createStatement(
        ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("select * from friends ");
        rs.moveToInsertRow();
        rs.updateString("Name", "Jack");
        rs.updateString("Address", "Tokyo");
        rs.updateInt("salary", 65000);
        rs.insertRow();
        rs.beforeFirst();
System.out.println("插入一行后的 FRIENDS 表:");
        while (rs.next()) {
String name = rs.getString("Name");
String address = rs.getString("Address");
            int salary = rs.getInt("Salary");
            System.out.print(name + "\t" + address + "\t" + salary);
System.out.println(" ");
    }
rs.close();
stmt.close();
con.close();
    } catch (SQLException ce) {
        ce.printStackTrace();
System.out.println(ce);
    }
    }
}