import java.sql.*;
import java.lang.String;public class DemoTest{

Connection con;
Statement sta;
ResultSet rs;

String driver_server;
String url_server;
//在连接sql server2000时候使用的变量


String au_id;
String title_id;
String au_ord;
String royaltyper;
//sql server2000中titleauthor表的字段名



String Url_oracle; 
String user_oracle; 
String password_oracle; 
Connection c;
Statement stb;
//连接oracle时候用到的变量 
       

public DemoTest(){ 

driver_server="sun.jdbc.odbc.JdbcOdbcDriver";
url_server="jdbc:odbc:db1";
//连接sql server2000时候的驱动方式与数据源


Url_oracle = "jdbc:oracle:thin:@WINXP:1521:jcx";
    user_oracle = "system";
    password_oracle = "database";
    //连接oracle数据库的驱动方式和用户名,密码,
 init();

}
public void init(){
try{
Class.forName(driver_server);
System.out.println("ok");
con=DriverManager.getConnection(url_server);
System.out.println("ok");
sta=con.createStatement();
rs=sta.executeQuery("select * from titleauthor");



        Class.forName("oracle.jdbc.OracleDriver");
        System.out.println("驱动加载成功");
        c = DriverManager.getConnection(Url_oracle,user_oracle,password_oracle);
        System.out.println("连接成功");




while(rs.next())
{//System.out.println(rs.getString(1)+"         "+rs.getString(2)+"          ");
   au_id=rs.getString(1);
   title_id=rs.getString(2);
   au_ord=rs.getString(3);
   royaltyper=rs.getString(4);
   
   stb=c.createStatement();
   stb.executeQuery("insert into titleauthor values(au_id,title_id,au_ord,royaltyper)");
   //stb.executeQuery("insert into titleauthor values('au_id','title_id','au_ord','royaltyper')");
   System.out.println(au_id+"            "+title_id+"          "+au_ord+"            "+royaltyper);
   
  



}




}
catch(Exception e ){System.out.println(e.toString());}

}
public static void main(String args[])
{new DemoTest();}

}
请问上面的sql语句需要怎么样写,values 的直才可以是动态的啊?