代码:ublic double[][] getValue(){Connection conn = Connectmysql.getConnection();
try {
Statement stmt = conn.createStatement();
Statement stmt1 = conn.createStatement();
Statement stmt2 = conn.createStatement();
ResultSet rs;
ResultSet rs1;
ResultSet rs2; int n;
int m;
rs=stmt.executeQuery("SELECT * FROM companyinformation ");
while(rs.next())
{ n++;}
rs1=stmt1.executeQuery("SELECT * FROM userinformation ");while(rs1.next())
{ m++;}
double value[][]=new double[m][n];
rs2=stmt2.executeQuery("SELECT id,companyid,value FROM userevaluate");
while(rs2.next()){
w=rs2.getInt(1);
e=rs2.getInt(2);
value[w][e]=rs3.getDouble(3); <-----这句报错java.sql.SQLException: Bad format for number '4,1' in column 3. }
catch(Exception e){
e.printStackTrace();
}
return value;
}
请问各位大侠,怎么改?
try {
Statement stmt = conn.createStatement();
Statement stmt1 = conn.createStatement();
Statement stmt2 = conn.createStatement();
ResultSet rs;
ResultSet rs1;
ResultSet rs2; int n;
int m;
rs=stmt.executeQuery("SELECT * FROM companyinformation ");
while(rs.next())
{ n++;}
rs1=stmt1.executeQuery("SELECT * FROM userinformation ");while(rs1.next())
{ m++;}
double value[][]=new double[m][n];
rs2=stmt2.executeQuery("SELECT id,companyid,value FROM userevaluate");
while(rs2.next()){
w=rs2.getInt(1);
e=rs2.getInt(2);
value[w][e]=rs3.getDouble(3); <-----这句报错java.sql.SQLException: Bad format for number '4,1' in column 3. }
catch(Exception e){
e.printStackTrace();
}
return value;
}
请问各位大侠,怎么改?
列 名 数据类型 可否为空 键
id VRACHAR(10) NOT NULL 主键
companyid VRACHAR(10) NOT NULL 主键
value VRACHAR(20) NOT NULL
number VRACHAR(10) NOT NULL