时间: 2021-07-31 作者:daque
1.传播表单参数: string name = new string(request.getparameter("name")); 2.数据库贯穿: ~~mysql //树立数据库的url string url = "jdbc:mysql://localhost:3306/jspsky"; try //加载启动步调 class.forname("org.gjt.mm.mysql.driver").newinstance(); //创造贯穿 java.sql.connection connection = java.sql.drivermanager.getconnection(url); java.sql.statement statement = connection.createstatement(); //sql语句 string sqlstringi ="insert into commu(name,tel,mobile,oicq,email)values(‘"+name+"’,‘"+tel+"’,‘"+mobile+"’,‘"+oicq+"’,‘"+email+"’)"; //运转sql语句,并创造截止集 java.sql.resultset rsi = statement.executequery(sqlstringi); //在屏幕上输入库中的实质 while(rss.next()) { string a_name = rss.getstring(1); out.println(a_name); {} //封闭贯穿 connection.close(); } //捕获特殊 catch(java.sql.sqlexception e) out.println(e.getmessage()); {} catch(classnotfoundexception e) out.println(e.getmessage()); {} ~~db2 //设置数据库的url string url = "jdbc:db2:portal"; try //加载启动步调 class.forname("com.ibm.db2.jdbc.app.db2driver"); //创造贯穿, java.sql.connection connection = java.sql.drivermanager.getconnection(url,"user","password"); java.sql.statement statement = connection.createstatement(); //sql语句 string sqlstring = "select * from client"; //实行sql语句 java.sql.resultset rs = statement.executequery(sqlstring); //在屏幕上表露所连表中的实质 while(rs.next()) { string name = rs.getstring(1); out.println(name); {} //封闭贯穿 connection.close(); } //捕获特殊 catch(java.sql.sqlexception e) out.println(e.getmessage()); {} catch(classnotfoundexception e) out.println(e.getmessage()); {} 3.文献操纵 ~~将一个字符串写到一个指定的文献中,即使该文献不生存,则兴建一个文献,并实行写入;即使生存,则用此字符串掩盖原文献的一切实质 import java.io.*; string str = "print me 雪峰!"; //设置好打字与印刷的目的文献名 //博得暂时长机寄存web页面包车型的士一致路途 string hostdir = system.getproperty("user.dir"); //博得暂时长机所沿用的路途分割符 string filebar = system.getproperty("file.separator"); //抄写完备的目的文献寄存路途 string nameoffile=hostdir+filebar+"test.html"; try //范例化一个文献输入流东西 fileoutputstream afile = new fileoutputstream(nameoffile); //将文献输入流,创造一个打字与印刷输入流东西 printwriter pw = new printwriter(afile); pw.println(str); //clean up pw.close(); {} catch(ioexception e) out.println(e.getmessage()); {} ~~列出指定目次下的文献列表 import java.io.*; string cdur = system.getproperty("user.dir"); string filebar = system.getproperty("file.separator"); string mydir =cdur+filebar+"doc"+filebar+"jspsky"; file my = new file(mydir); string d[] = my.list(); int i; int l=d.length; for(i=0;i out.print(d); {} 4.计数器 integer count = null; synchronized (application) count =(integer) application.getattribute("d"); if (count ==null) count =new integer("0"); count = new integer(count.intvalue()+1); application.setattribute("d",count); {} out.println(count); // 开始设置一个整形东西,并初始化为:null, // 取回application对像的属性d的值,并强迫变化为整形东西,赋给count // 确定count能否为空,为空时,将o赋给count东西, // 要不,经过count。intvalue()本领,实行count东西加1,并赋值给count // 结果,将count东西生存在application东西的d变量中