String [] result = request.getParameterValues("wo");
int [] result2={0,0,0};
int j=0;
for(int i=0;i<result.length;i++)
{
j=Integer.parseInt(result[i]);
result2[j-1]=j;
}
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =DriverManager.getConnection("jdbc:odbc:news");
Statement stat = con.createStatement();
stat.executeUpdate("insert into result (col1,col2,col3) values("+result2[0]+","+result2[1]+","+result2[2]+")");
}
catch(Exception ex){
ex.printStackTrace();
}
sql 如下:
create table result
(
col1 int default 0 not null,
col2 int default 0 not null,
col3 int default 0 not null,
)