我现在有个一个数组
for(int i=0;i<sourceName.length;i++)
{
out.print(sourceName[i]);
}
现在要把sourceName插入到数据库中insert into Movie(MovieName,MovieAdd,Classification,Teacher)values('"+MovieName+"','"+MovieAdd+'/'+"','"+Classification+"','"+Teacher+"')"
其中的MovieName就相当于sourceName[]
我应该怎么写呢?
for(int i=0;i<sourceName.length;i++)
{
out.print(sourceName[i]);
}
现在要把sourceName插入到数据库中insert into Movie(MovieName,MovieAdd,Classification,Teacher)values('"+MovieName+"','"+MovieAdd+'/'+"','"+Classification+"','"+Teacher+"')"
其中的MovieName就相当于sourceName[]
我应该怎么写呢?
{
sql = "insert into Movie(MovieName,MovieAdd,Classification,Teacher)values('"+sourceName[i]+"','"+MovieAdd+'/'+"','"+Classification+"','"+Teacher+"')";db execute(sql)}db close
{
ps.setXXX(1,xxx);
...
ps.addBatch();
}
ps.executeBatch();
进行批量的sql操作
db openfor(int i=0;i<sourceName.length;i++)
{
sql = "insert into Movie(MovieName,MovieAdd,Classification,Teacher)values('"+sourceName[i]+"','"+MovieAdd+'/'+"','"+Classification+"','"+Teacher+"')";db execute(sql)}db close
Top
使用这个方法后报错啊
An error occurred at line: 113 in the jsp file: /web/admin/upload1.jsp
sql cannot be resolved