queryapp.java

来自「J2EE指南」· Java 代码 · 共 26 行

import java.sql.*;
public class QueryApp
{
	public static void main(String args[])
	{
		ResultSet result;
		
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:mydatabase","","");
			Statement stat=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
			result=stat.executeQuery("select * from jobs");
		result.next();
		result.updateInt("min_lvl",25);
		//更新数据库
        result.updateRow();

		}
	
		catch(Exception e)
		{
			System.out.println("Could not execute the query"+e);
		}
	}
}