有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

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) 个答案