java excel数据删除数据_更删改excel中的内容

inquireExcel.jsp

Connection con;                                  //修改message中的“缆线”为“电缆线”

Statement sql;

ResultSet rs;

//当应用程序试图使用以下方法通过字符串名加载类时，抛出该异常,Class 类中的 forName 方法,加载驱动。

try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch(ClassNotFoundException e){}

//该异常提供关于数据库访问错误或其他错误的信息。

try{ con=DriverManager.getConnection("jdbc:odbc:star","","");

sql=con.createStatement();

sql.executeUpdate("update message set 品名='电缆线' where 货号='ED56G'");

rs=sql.executeQuery("select * from message");

out.print("

out.print("

");

out.print("

"+"货号");

out.print("

"+"品名");

out.print("

"+"单位");

out.print("

"+"单价");

out.print("

"+"库存");

out.print("

");

//储存格

(须与列并用)

while(rs.next()){

out.print("

");

out.print("

"+rs.getString(1)+"");

out.print("

"+rs.getString(2)+"");

out.print("

"+rs.getString(3)+"");

out.print("

"+rs.getString(4)+"");

out.print("

"+rs.getString(5)+"");

out.print("

");

}

out.print("

");

con.close();

}

catch(SQLException el) {}

%>

posted on 2009-05-03 11:17 鹏凌 阅读(86) 评论(0)  编辑  收藏