📄 queryapp.java
字号:
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);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -