141、JAVA 多线程编程。 用 JAVA 写一个多线程程序,如写四个线程,二个加 1,二个对一
个变量减一,输出。
希望大家补上,谢谢
142、可能会让你写一段 Jdbc连Oracle 的'程序,并实现数据查询.
答:程序如下:
package ;
import .*;
public class jdbc
{
String dbUrl="jdbc:oracle:thin:@:orcl";
String theUser="admin";
String thepw="manager";
Connection c=null;
Statement conn;
ResultSet rs=null;
public jdbc()
{
try{
ame("leDriver")nstance();
c = onnection(dbUrl,theUser,thepw); conn=teStatement();
}catch(Exception e){
tStackTrace();
}
}
public boolean executeUpdate(String sql)
{
---------- 16 ----------
*** JAVA面试题 ***
try
{
uteUpdate(sql);
return true;
}
catch (SQLException e)
{
tStackTrace();
return false;
}
}
public ResultSet executeQuery(String sql)
{
rs=null;
try
{
rs=uteQuery(sql);
}
catch (SQLException e)
{
tStackTrace();
}
return rs;
}
public void close()
{
try
{ e();
e();
}
catch (Exception e)
{
tStackTrace();
}
}
public static void main(String[] args)
{
ResultSet rs;
jdbc conn = new jdbc();
rs=uteQuery("select * from test");
try{
while (())
{
tln(tring("id"));
tln(tring("name"));
}
}catch(Exception e)
{
tStackTrace();
}
}
}
143、ORACLE 大数据量下的分页解决方法。一般用截取 ID方法,还有是三层嵌套方法。
答:一种分页方法
<%< b="">
int i=1;
int numpages=14;
String pages = arameter("page") ;
int currentpage = 1;
currentpage=(pages==null)?(1):{eInt(pages)}
sql = "select count(*) from tables";
ResultSet rs = uteQuery(sql) ;
while(()) i = nt(1) ;
int intpageCount=1;
intpageCount=(i%numpages==0)?(i/numpages):(i/numpages+1);
int nextpage ;
int uppage;
nextpage = currentpage+1; if (nextpage>=intpageCount) nextpage=intpageCount;
uppage = currentpage-1;
if (uppage<=1) uppage=1;
---------- 17 ----------
*** JAVA面试题 ***
e();
sql="select * from tables";
rs=uteQuery(sql);
i=0;
while((i
%>
//输出内容
//输出翻页连接
合计:<%=currentpage%>/<%=intpagecount%>
上一页
<%< b="">
for(int j=1;j<=intpagecount;j++){< b="">
if(currentpage!=j){
%>
<%< b="">
}else{
tln(j);
}
}
%>
最后页
144、用 jdom解析xml 文件时如何解决中文问题?如何解析?
答:看如下代码,用编码方式加以解决
package test;
import .*;
public class DOMTest
{
private String inFile = "c:";
private String outFile = "c:";
public static void main(String args[])
{
new DOMTest();
}
public DOMTest()
{
try
{
mentBuilder builder =
nstance()ocumentBuilder();
ment doc = ocument();
ent root = teElement_x("老师");
ent wang = teElement_x("王");
ent liu = teElement_x("刘");
ndChild(teTextNode("我是王老师"));
ndChild(wang);
ndChild(root);
sformer transformer =
nstance()ransformer();
utputproperty(DING, "gb2312");
utputproperty(NT, "yes");
sform(new ource(doc),
new
amResult(outFile));
---------- 18 ----------
*** JAVA面试题 ***
}
catch (Exception e)
{
tln (essage());
}
}
}
145、编程用JAVA 解析 XML 的方式.
答:用 SAX方式解析XML,XML文件如下:
王小明
信息学院
6258113
事件回调类
import .*;
import table;
import .*;
public class SAXHandler extends HandlerBase
{
private Hashtable table = new Hashtable(); private String currentElement = null;
private String currentValue = null;
public void setTable(Hashtable table)
{
e = table;
}
public Hashtable getTable()
{
return table;
}
public void startElement(String tag, AttributeList attrs)
throws SAXException
{
currentElement = tag;
}
public void characters(char[] ch, int start, int length)
throws SAXException
{
currentValue = new String(ch, start, length);
}
public void endElement(String name) throws SAXException
{
if (ls(name))
(currentElement, currentValue);
}
} JSp内容显示源码,:
剖析XML文件
<%@ page errorpage=""
contentType="text/html;charset=GB2312" %>
<%@ page="" import=".*">
<%@ page="" import="table">
<%@ page="" import=".*">
<%@ page="" import=".*">
<%@ page="" import="arserFactory">
<%@ page="" import="arser">
<%@ page="" import="SAXHandler">
<%< b="">
File file = new File("c:");
FileReader reader = new FileReader(file);
parser parser;
SAXparserFactory spf = nstance();
SAXparser sp = AXparser();
SAXHandler handler = new SAXHandler();
e(new InputSource(reader), handler);
---------- 19 ----------
*** JAVA面试题 ***
Hashtable hashTable = able();
tln("
教师信息表");
tln("
姓名" + "
" + |
(String)(new String("name")) + "");
tln("
学院" + "
" + |
(String)(new String("college"))+"");
tln("
电话" + "
" + |
(String)(new String("telephone&