static void add()
{
try{
connection=DriverManager.getConnection("jdbc:odbc:students","","");
statement=connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
resultset=statement.executeQuery("select * from 成绩表");
//////////////////数据库连接
while(resultset.next())
{
s_add
="update 成绩表 set 学号="+DemandFrame.matter[i][0]+
",姓名="+DemandFrame.matter[i][1]+
",出生年月="+DemandFrame.matter[i][2]+
",语文="+DemandFrame.matter[i][3]+
",数学="+DemandFrame.matter[i][4]+
",外语="+DemandFrame.matter[i][5]+" where 学号="+j+"";
statement.executeUpdate(s_add);
j++;i++;
}
connection.close();
i=0;
}catch(SQLException e)
{
e.getStackTrace();
System.out.println(e);
}
}
{
try{
connection=DriverManager.getConnection("jdbc:odbc:students","","");
statement=connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
resultset=statement.executeQuery("select * from 成绩表");
//////////////////数据库连接
while(resultset.next())
{
s_add
="update 成绩表 set 学号="+DemandFrame.matter[i][0]+
",姓名="+DemandFrame.matter[i][1]+
",出生年月="+DemandFrame.matter[i][2]+
",语文="+DemandFrame.matter[i][3]+
",数学="+DemandFrame.matter[i][4]+
",外语="+DemandFrame.matter[i][5]+" where 学号="+j+"";
statement.executeUpdate(s_add);
j++;i++;
}
connection.close();
i=0;
}catch(SQLException e)
{
e.getStackTrace();
System.out.println(e);
}
}
where 学号="+j+"";
你这边好像""应当在第二行吧
eg:
学号='"+DemandFrame.matter[i][0]+ "'"