java select*进入查询executeUpdate()
我将postgresql与jdbc结合使用。当我尝试使用下面这行代码时,它并没有执行
int suc = stins.executeUpdate("select * into kmeans_cluster"+i+" from kmeans_emp where sno="+sno);
if(suc>0)System.out.println("success");
else System.out.println("fail");
输出总是“失败”
下面是代码片段
package kmeans;
import java.sql.*;
import java.util.*;
public class Kmeans{
Connection con;Statement st,stins;ResultSet rs;Scanner s;
public Kmeans(){
try{
con = DriverManager.getConnection("jdbc:postgresql://localhost/kmeans","postgres","naren");
st = con.createStatement();
stins = con.createStatement();
s=new Scanner(System.in);
System.out.println("Enter no.of clusters");
int nc = s.nextInt();
float cc[]=new float[nc];
rs = st.executeQuery("select * from kmeans_emp");
for(int i=0;i<nc;i++){
rs.next();
cc[i]=Float.parseFloat(rs.getString(3));
int sno = Integer.parseInt(rs.getString(1));
int suc = stins.executeUpdate("select * into kmeans_cluster"+i+" from kmeans_emp where sno="+sno);
if(suc>0)System.out.println("success");
else System.out.println("fail");
}
float a,b;
.
.
...
共 (0) 个答案