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 的直才可以是动态的啊?
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 的直才可以是动态的啊?
pstmt.setString(2,"第二个值");
pstmt.setString(3,"第三个值");
pstmt.setString(4,"第四个值");
pstmt.execute();原理请参看API