Question

这段代码什么意思 最好分步解释下 谢谢！ 新手

request.setCharacterEncoding("utf-8");
String moviesname=request.getParameter("moviesname");
String moviestype=request.getParameter("moviestype");
String imageurl=request.getParameter("imageurl");
String moviesfrom=request.getParameter("moviesfrom");
String moviesplayers=request.getParameter("moviesplayers");
String moviescontent=request.getParameter("moviescontent");
String pricetype=request.getParameter("pricetype");
String display=request.getParameter("display");
String moviesCount=request.getParameter("moviesCount");
int count = Integer.parseInt(moviesCount);

java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date currentTime = new java.util.Date();
String str_date = formatter.format(currentTime);

//String strSQL="insert into test.t_3(test) value('"+ moviescontent+"')";
String strSQL=" INSERT INTO movie_client.moviesinfo (movies_server_id , moviesname , moviestype , moviesplayers , pricetype , moviesfrom , moviescontent , imageurl , addtime , count , display , update_date,update_state,update_code,is_lock) VALUES (1, '" + moviesname + "', '" + moviestype + "', '" + moviesplayers + "', '" + pricetype + "', '" + moviesfrom+ "' , '" + moviescontent + "', '" + imageurl + "', '" + str_date + "', 0, '" + display + "' , '" + str_date + "',0,'',0)";
InsertBean.executeUpdate(strSQL);
String sql="select * from movie_client.moviesinfo where moviesname='" + moviesname + "'";
ResultSet rs=InsertBean.executeQuery(sql);
String moviesid="";
if(rs.next()){
moviesid=rs.getString("moviesid");
rs.close();
}
for(int i=0; i<count;i++){
int num = i+1;
strSQL = "INSERT INTO movie_client.moviesplay ( moviesid , number , movies_server_id , url,local_md5,remote_md5,update_state)VALUES( '" + moviesid + "', '" + num + "', 1, '" + moviesname + "/0" + num + ".rmvb','','',0 )";
InsertBean.executeUpdate(strSQL);
}
InsertBean.closeStmt();
InsertBean.closeConn();

Answer 1

request.setCharacterEncoding("utf-8");
//将编码设置为UTF-8
String moviesname=request.getParameter("moviesname");
String moviestype=request.getParameter("moviestype");
String imageurl=request.getParameter("imageurl");
String moviesfrom=request.getParameter("moviesfrom");
String moviesplayers=request.getParameter("moviesplayers");
String moviescontent=request.getParameter("moviescontent");
String pricetype=request.getParameter("pricetype");
String display=request.getParameter("display");
String moviesCount=request.getParameter("moviesCount");
int count = Integer.parseInt(moviesCount);//转换为整形
//以上是获取页面传过来的参数值

java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//创建日期格式为"yyyy-MM-dd HH:mm:ss"的对象formatter
java.util.Date currentTime = new java.util.Date();
//取得当前系统时间
String str_date = formatter.format(currentTime);
//将当前时间转换为"yyyy-MM-dd HH:mm:ss"的格式

//String strSQL="insert into test.t_3(test) value('"+ moviescontent+"')";
String strSQL=" INSERT INTO movie_client.moviesinfo (movies_server_id , moviesname , moviestype , moviesplayers , pricetype , moviesfrom , moviescontent , imageurl , addtime , count , display , update_date,update_state,update_code,is_lock) VALUES (1, '" + moviesname + "', '" + moviestype + "', '" + moviesplayers + "', '" + pricetype + "', '" + moviesfrom+ "' , '" + moviescontent + "', '" + imageurl + "', '" + str_date + "', 0, '" + display + "' , '" + str_date + "',0,'',0)";
//向表中插入页面中获取的那些字段，依次对应
InsertBean.executeUpdate(strSQL);
//执行插入操作
String sql="select * from movie_client.moviesinfo where moviesname='" + moviesname + "'";
//查询moviesname=？的结果
ResultSet rs=InsertBean.executeQuery(sql);
//获得结果集
String moviesid="";//定义变量
if(rs.next()){ //如果结果集中有值，不为空，循环此操作。
moviesid=rs.getString("moviesid");//将表中的id赋值给moviesid
rs.close();//关闭结果集
}
for(int i=0; i<count;i++){
int num = i+1;
strSQL = "INSERT INTO movie_client.moviesplay ( moviesid , number , movies_server_id , url,local_md5,remote_md5,update_state)VALUES( '" + moviesid + "', '" + num + "', 1, '" + moviesname + "/0" + num + ".rmvb','','',0 )";
InsertBean.executeUpdate(strSQL);
//同上述描述
}
InsertBean.closeStmt();//关闭数据库操作
InsertBean.closeConn(); //关闭数据库连接
//以上是JSP/servelet获取页面值并与数据库交互的步骤。LZ可以查阅相关的与数据库交互的知识。

Answer 2

到这行止 int count = Integer.parseInt(moviesCount); 前面都是获取页面参数 而这行就是将moviesCount强制转换成int型

java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date currentTime = new java.util.Date();
String str_date = formatter.format(currentTime);
//将当前时间format成yyyy-MM-dd HH:mm:ss格式

String strSQL = 。。。这句是写插入的sql语句
InsertBean.executeUpdate(strSQL); 执行insert语句
下面 String sql 这句是将 名为 moviesname 的查询出来
查询出来之后再将某些信息插入到moviesplay 表中
最后两句是关闭statement 和connection

Answer 3

request.setCharacterEncoding("utf-8"); //设置编码格式为utf-8
String moviesname=request.getParameter("moviesname");
String moviestype=request.getParameter("moviestype");
String imageurl=request.getParameter("imageurl");
String moviesfrom=request.getParameter("moviesfrom");
String moviesplayers=request.getParameter("moviesplayers");
String moviescontent=request.getParameter("moviescontent");
String pricetype=request.getParameter("pricetype");
String display=request.getParameter("display");
String moviesCount=request.getParameter("moviesCount");
//以上这一串都是去页面对应参数名字的值
int count = Integer.parseInt(moviesCount); //将这个参数进行转换成int类型

java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//设置日期格式
java.util.Date currentTime = new java.util.Date();
String str_date = formatter.format(currentTime);
//将当前时间设为前面设置的日期格式
//String strSQL="insert into test.t_3(test) value('"+ moviescontent+"')"; //SQL语句，插入语句。
String strSQL=" INSERT INTO movie_client.moviesinfo (movies_server_id , moviesname , moviestype , moviesplayers , pricetype , moviesfrom , moviescontent , imageurl , addtime , count , display , update_date,update_state,update_code,is_lock) VALUES (1, '" + moviesname + "', '" + moviestype + "', '" + moviesplayers + "', '" + pricetype + "', '" + moviesfrom+ "' , '" + moviescontent + "', '" + imageurl + "', '" + str_date + "', 0, '" + display + "' , '" + str_date + "',0,'',0)"; //SQL语句。
InsertBean.executeUpdate(strSQL);//执行此SQL语句
String sql="select * from movie_client.moviesinfo where moviesname='" + moviesname + "'";
ResultSet rs=InsertBean.executeQuery(sql); //执行此SQL语句
String moviesid="";
if(rs.next()){ //将执行SQL 输出得到的结果进行循环
moviesid=rs.getString("moviesid"); //赋值
rs.close(); //关闭resultSet
}
for(int i=0; i<count;i++){
int num = i+1;
strSQL = "INSERT INTO movie_client.moviesplay ( moviesid , number , movies_server_id , url,local_md5,remote_md5,update_state)VALUES( '" + moviesid + "', '" + num + "', 1, '" + moviesname + "/0" + num + ".rmvb','','',0 )";
InsertBean.executeUpdate(strSQL); //执行sql插入操作
}
InsertBean.closeStmt(); //关闭 stmt
InsertBean.closeConn(); //关闭连接

Answer 4

request.setCharacterEncoding("utf-8"); //设置请求的字符集为utf-8
String moviesname=request.getParameter("moviesname"); //获得传递过来的参数moviesname,这个参数对应的是上一个页面的某个元素的name
String moviestype=request.getParameter("moviestype"); //同上
String imageurl=request.getParameter("imageurl");//同上
String moviesplayers=request.getParameter("moviesplayers");//同上
String moviescontent=request.getParameter("moviescontent");//同上
String pricetype=request.getParameter("pricetype");//同上
String display=request.getParameter("display");//同上
String moviesCount=request.getParameter("moviesCount");//同上
int count = Integer.parseInt(moviesCount); //把moviesCount转换成int类型

java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); //定制一个时间输出格式
java.util.Date currentTime = new java.util.Date(); //获取当前时间
String str_date = formatter.format(currentTime); //将当前时间设置成之前定制的格式

//String strSQL="insert into test.t_3(test) value('"+ moviescontent+"')";
String strSQL=" INSERT INTO movie_client.moviesinfo (movies_server_id , moviesname , moviestype , moviesplayers , pricetype , moviesfrom , moviescontent , imageurl , addtime , count , display , update_date,update_state,update_code,is_lock) VALUES (1, '" + moviesname + "', '" + moviestype + "', '" + moviesplayers + "', '" + pricetype + "', '" + moviesfrom+ "' , '" + moviescontent + "', '" + imageurl + "', '" + str_date + "', 0, '" + display + "' , '" + str_date + "',0,'',0)"; //sql语句,不用解释了吧,用于数据库操作
InsertBean.executeUpdate(strSQL); //执行上面的sql
String sql="select * from movie_client.moviesinfo where moviesname='" + moviesname + "'";
ResultSet rs=InsertBean.executeQuery(sql); //获取结果集
String moviesid="";
if(rs.next()){ //遍历结果集
moviesid=rs.getString("moviesid");
rs.close();
}
for(int i=0; i<count;i++){
int num = i+1;
strSQL = "INSERT INTO movie_client.moviesplay ( moviesid , number , movies_server_id , url,local_md5,remote_md5,update_state)VALUES( '" + moviesid + "', '" + num + "', 1, '" + moviesname + "/0" + num + ".rmvb','','',0 )";
InsertBean.executeUpdate(strSQL);
}
InsertBean.closeStmt();
InsertBean.closeConn(); //关闭资源