Пытаюсь разобраться...

stmt = connection.createStatement();
rs = stmt.executeQuery("SELECT * from biznes");
 
System.out.println("---------------Вывод результата 1:---------------");
while(rs.next())
{
int theid= rs.getInt("id");
String str = rs.getString("name");
System.out.println("id= " + theid + " ---> name = " + str);
System.out.println("_________________________________");
}
 
stmt.executeUpdate("INSERT INTO biznes (name) values (Русский-Englysh)", Statement.RETURN_GENERATED_KEYS);
stmt.executeUpdate("INSERT INTO biznes (name) values (переменная А)", Statement.RETURN_GENERATED_KEYS);

try {
ps = c.prepareStatement("INSERT INTO biznes (name) values (?)");
ps.setString(1, doc.getItemValueString("name"));
} catch (SQLException se) {
System.out.println("We got an exception while preparing a statement:" +
"Probably bad SQL.");
se.printStackTrace();
System.exit(1);
}
 
try {
ps.executeUpdate();
} catch (SQLException se) {
System.out.println("We got an exception while executing an update:" +
"possibly bad SQL, or check the connection.");
se.printStackTrace();
System.exit(1);
}

public java.util.Vector dataconection(String id) {
java.util.Vector retVar;
//...
while(rs.next()) {
//получекние читабельного результата в консоль
retVar.add(/*что-то нужное */);
}
return retVar;
}

import java.util.HashMap;
....
HashMap info = new HashMap(); // лист со значениями полей из запроса
...
 
while(rs.next())
{
for (int i = 1; i <= numberOfColumns; i++) {
sValue ="тут вот значение поля из запроса"
info.put( rsMetaData.getColumnName(i).toString(), sValue );
}
}

public class workcard extends AgentBase {
 
public void createdoc(String fio,String addres, String email, String textobr){
try {
Session s = getSession();
AgentContext agentContext = s.getAgentContext();
Database db = agentContext.getCurrentDatabase();
Document doc = db.createDocument();
doc.replaceItemValue("Form", "rlo");
doc.replaceItemValue("FIO", fio);
doc.replaceItemValue("Address", addres);
doc.replaceItemValue("email", email);
doc.replaceItemValue("Annotation", textobr);
doc.computeWithForm(false, false);
if (doc.save())
System.out.println("Документ сохранен");
else
System.out.println("Документ не сохранен");
} catch(Exception e) {
e.printStackTrace();
}
}

import lotus.domino.*;
import java.util.Vector;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
public class JavaAgent extends AgentBase {
public void main(String id) {
try {
Session session = getSession();
AgentContext agentContext = session.getAgentContext();
Statement stmt = null;
ResultSet rs = null;
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch (Exception ex)
{
System.out.println("SQLException: " + ex.getMessage());
}
 
try {
conn = DriverManager.getConnection("jdbc:mysql://host_port_db_login_passw);
}
catch (SQLException ex)
{
System.out.println("On connect SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
System.out.println("Соединение успешно");
try {
stmt = conn.createStatement();
id = "4isNNEkEA8kNhn9B";
String Query = "SELECT * FROM pr_data WHILE auth=" + "+ id +";
 
try {
rs = stmt.executeQuery(Query);
}
catch(SQLException ex)
{
System.out.println("on JOIN SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
Database db = agentContext.getCurrentDatabase();
Document doc = db.createDocument();
doc.appendItemValue("Form", "ProductReport");
Vector vauth = new Vector();
Vector vfio = new Vector();
Vector vaddress = new Vector();
Vector vemail = new Vector();
Vector vmessage = new Vector();
 
 
while (rs.next()) {
// retrieve and print the values for the current row
int theid= rs.getInt("id");
String fname = rs.getString("fname");
String mname = rs.getString("mname");
String lname = rs.getString("lname");
String message = rs.getString("message");
String email = rs.getString("email");
String auth = rs.getString("auth");
String pindex = rs.getString("pindex");
String pregion = rs.getString("pregion");
String plocality = rs.getString("plocality");
String pstreet = rs.getString("pstreet");
String phome = rs.getString("phome");
String pcorps = rs.getString("pcorps");
String pflat = rs.getString("pflat");
System.out.println("Переменные присвоены");
System.out.println("auth_code= " + auth );
System.out.println("id= " + theid + " ---> ФИО = " + fname + " " + mname +" "+ lname);
System.out.println("id= " + theid + " ---> Почтовый адрес = " + pindex +" "+ pregion +" "+ plocality +" "+ pstreet +" "+ phome +" "+ pcorps +" "+ pflat);
System.out.println("id= " + theid + " ---> Электронныйый адрес = " + email);
System.out.println("id= " + theid + " ---> Текст обращения = " + message );
System.out.println("_________________________________");
 
vauth.addElement(auth);
vfio.addElement(fname + " " + mname +" "+ lname);
vaddress.addElement(pindex +" "+ pregion +" "+ plocality +" "+ pstreet +" "+ phome +" "+ pcorps +" "+ pflat);
vemail.addElement(email);
vmessage.addElement(message);
 
}
doc.replaceItemValue("Form", "rlo");
doc.appendItemValue("FIO", vfio);
doc.appendItemValue("Address", vaddress);
doc.appendItemValue("email", vemail);
doc.appendItemValue("Annotation", vmessage);
doc.computeWithForm(false, false);
doc.save();
} finally {
if (rs != null) {
try {
rs.close();
} catch(SQLException ex) {}
rs = null;
} //if
if (stmt != null) {
try {
stmt.close();
} catch(SQLException ex) {}
stmt = null;
} //if
} //finally
 
 
} catch(Exception e) {
e.printStackTrace();
}
}
}