??xml version="1.0" encoding="utf-8" standalone="yes"?> 来源 Q?http://blog.csdn.net/cm4ever/ <%@ page contentType="text/html;charset=gb2312"%> <%@ page contentType="text/html;charset=gb2312"%> <%@ page contentType="text/html;charset=gb2312"%> <%@ page contentType="text/html;charset=gb2312"%> <%@ page contentType="text/html;charset=gb2312"%> <%@ page contentType="text/html;charset=gb2312"%> <%@ page contentType="text/html;charset=gb2312"%> 下面是简单的数据库操作Javabean的代?
一、jspq接Oracle8/8i/9i数据库(用thin模式Q?br>testOracle.jsp如下Q?
<%@ page import="java.sql.*"%>
<%
String result = ""; // 查询l果字符?/font>
String sql = "select * from test"; // SQL 字符?/font>
// q接字符Ԍ格式Q?"jdbc:数据库驱动名U?q接模式:@数据库服务器ip:端口?数据库SID"
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String username = "scott"; // 用户?/font>
String password = "tiger"; //密码
// 创徏oracle数据库驱动实?/font>
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
// 获得与数据库的连?/font>
Connection conn = DriverManager.getConnection(url, username, password);
// 创徏执行语句对象
Statement stmt = conn.createStatement();
// 执行sql语句Q返回结果集
ResultSet rs = stmt.executeQuery(sql);
while ( rs.next() )
{
result += "\n W一个字D内容:(x)" + rs.getString(1) + "<BR>";
}
rs.close(); // 关闭l果?/font>
stmt.close(); // 关闭执行语句对象
conn.close(); // 关闭与数据库的连?/font>
%>
<HTML>
<BODY>
<%=result%>
</BODY>
</HTML>
二、jspq接Sql Server7.0/2000数据?/strong>
testSqlServer.jsp如下
<%@ page import="java.sql.*"%>
<%
String sql = "select * from test";
// q接字符Ԍ格式Q?"jdbc:公司名称:数据库驱动名U?//数据库服务器ip:端口?DatabaseName=数据库名U?
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String username = "scott";
String password = "tiger";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(sql);
%>
<HTML>
<BODY>
<%
while ( rs.next() )
{
%>
W一个字D内容ؓ(f)Q?font color=#993300><%=rs.getStrisng(1)%><BR>
<%
}
rs.close();
stmt.close();
conn.close();
%>
</BODY>
</HTML>
三、jspq接DB2数据?/strong>
testDB2.jsp如下Q?br>
<%@ page import="java.sql.*"%>
<%
String sql = "select * from test";
// q接字符Ԍ格式Q?"jdbc:数据库驱动名U?//数据库服务器ip:端口?数据库名U?
String url = "jdbc:db2://localhost:5000/sample";
String username = "scott";
String password = "tiger";
Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance();
Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(sql);
rs.close();
stmt.close();
conn.close();
%>
四、jspq接Informix数据?
testInformix.jsp如下Q?br>
<%@ page import="java.sql.*"%>
<%
String sql = "select * from test";
// q接字符Ԍ格式Q?"jdbc:数据库驱动名U?//数据库服务器ip:端口?数据库名U?INFORMIXSERVER=服务器名;user=用户?password=密码"
String url = "jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver;user=testuser;password=testpassword";
Class.forName("com.informix.jdbc.IfxDriver").newInstance();
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(sql);
rs.close();
stmt.close();
conn.close();
%>
五、jspq接Sybase数据?
testSybase.jsp如下Q?
<%@ page import="java.sql.*"%>
<%
String sql = "select * from test";
// q接字符Ԍ格式Q?"jdbc:公司名称:数据库驱动名U?数据库服务器ip:端口?数据库名U?
String url = "jdbc:sybase:Tds:localhost:5007/tsdata";
Properties prop = System.getProperties();
prop.put("user", "userid"); // 用户?/font>
prop.put("password", "user_password"); // 密码
Class.forName("com.sybase.jdbc.SybDriver").newInstance();
Connection conn = DriverManager.getConnection(url, prop);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(sql);
rs.close();
stmt.close();
conn.close();
%>
六、jspq接MySQL数据?
testMySQL.jsp如下Q?
<%@ page import="java.sql.*"%>
<%
String sql = "select * from test";
// q接字符Ԍ格式Q?"jdbc:数据库驱动名U?//数据库服务器ip/数据库名U?user=用户?amp;password=密码&使用Unicode=布尔?amp;字符~码=~码"
String url = "jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1";
String username = "scott";
String password = "tiger";
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(sql);
rs.close();
stmt.close();
conn.close();
%>
七、jspq接PostgreSQL数据?/font>
testPostgreSQL.jsp如下Q?
<%@ page import="java.sql.*"%>
<%
String sql = "select * from test";
// q接字符Ԍ格式Q?"jdbc:数据库驱动名U?//数据库服务器ip/数据库名U?
String url = "jdbc:postgresql://localhost/soft";
String username = "scott";
String password = "tiger";
Class.forName(""org.postgresql.Driver").newInstance();
Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(sql);
rs.close();
stmt.close();
conn.close();
%>
DbWrapper.java
import java.sql.*;import java.util.*;publicclass DbWrapper
{// 定义q接池对象ؓ(f)?rn)态变量,一直存在,直到工作目录关闭?/font>privatestatic DataSource ds =null;
// 1.用连接池的方式获得连?/font>// 如果不是做多数据库程序,推荐使用此方?/font>// 相关内容Q?a target=_blank>在tomcat理界面配置q接?/font>publicstatic Connection openConnection()throws Exception
{// 只需要初始化1?/font>if( ds ==null){
Context initContext =newInitialContext();
Context envContext =(Context) initContext.lookup("java:/comp/env");
DataSource ds =(DataSource) envContext.lookup("jdbc/MyDataSource");}return ds.getConnection();}// 2.用jdbc驱动获得q接// 相关内容Q?a target=_blank>JSP数据库连接大?/font>publicstatic Connection openConnection(
String driver,
String url,
String username,
String password)throws Exception
{
Class.forName(driver).newInstance();return DriverManager.getConnection(url, username, password);}publicstaticvoidcloseConnection(Connection conn)throws Exception
{if( conn !=null){
conn.close();}}
publicstaticintexecuteUpdate(String sql)throws Exception
{int count =0;
Connection conn =null;
Statement stmt =null;try{
conn =openConnection();
stmt = conn.createStatement();
count = stmt.executeUpdate(sql);}catch( Exception e ){throw e;}finally{closeConnection(conn);}return count;}publicstatic List executeQuery(String sql)throws Exception
{
List list =newArrayList();
Connection conn =null;
Statement stmt =null;
ResultSet rs =null;try{
conn =openConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();while( rs.next()){
Map map =newHashMap();for(int i =1; i <= rsmd.getColumnCount(); i++){
map.put(rsmd.getColumnName(i), rs.getObject(i));}
list.add(map);}
}catch( Exception e ){
e.printStackTrace();}finally{if( rs !=null) rs.close();closeConnection(conn);}return list;
}}
// 1.对于insert, update, delete语句
int count = DbWrapper.executeUpdate(sql);
// 2.对于selete语句
java.util.List list = DbWrapper.executeQuery(sql);
// Ҏ(gu)一:按名字取|注意大小写是严格区分?/font>for(int i =0; i < list.size(); i++){
java.util.Map map =(java.util.Map)list.get(i);
out.println(mag.get("column_name").toString());}
// Ҏ(gu)二:(x)遍历取?/font>for(int i =0; i < list.size(); i++){
java.util.Map map =(java.util.Map)list.get(i);
for(java.util.Iterator it = map.keySet().iterator(); it.hasNext();){
String column_name = it.next().toString());
// 取?/font>时注意null判断
out.println(column_name +" = "+ map.get(column_name) ==null?"": map.get(column_name).toString());}}
]]>
否则?x)提CZ一个错误信?nbsp;"引用的元素ؓ(f)I或者不是对?
---------------------------------------------------------------------
对象属?br>document.title //讄文档标题{h(hun)于HTML?lt;title>标签
document.bgColor //讄面背景?br>document.fgColor //讄前景?文本颜色)
document.linkColor //未点击过的链接颜?br>document.alinkColor //Ȁz链?焦点在此链接?的颜?br>document.vlinkColor //已点击过的链接颜?br>document.URL //讄URL属性从而在同一H口打开另一|页
document.fileCreatedDate //文g建立日期Q只d?br>document.fileModifiedDate //文g修改日期Q只d?br>document.fileSize //文g大小Q只d?br>document.cookie //讄和读出cookie
document.charset //讄字符?nbsp;体中?gb2312
---------------------------------------------------------------------
对象Ҏ(gu)
document.write() //动态向面写入内容
document.createElement(Tag) //创徏一个html标签对象
document.getElementById(ID) //获得指定ID值的对象
document.getElementsByName(Name) //获得指定Name值的对象
---------------------------------------------------------------------
images集合(面中的图象)
a)通过集合引用
document.images //对应面上的<img>标签
document.images.length //对应面?lt;img>标签的个?br>document.images[0] //W??lt;img>标签
document.images[i] //Wi-1?lt;img>标签
b)通过nane属性直接引?br><img name="oImage">
document.images.oImage //document.images.name属?br>
c)引用囄的src属?br>document.images.oImage.src //document.images.name属?src
d)创徏一个图?br>var oImage
oImage = new Image()
document.images.oImage.src="http://www.webjx.com/1.jpg"
同时在页面上建立一?lt;img>标签与之对应可以显C?br>
<html>
<img name=oImage>
<script language="javascript">
var oImage
oImage = new Image()
document.images.oImage.src="http://www.webjx.com/1.jpg"
</script>
</html>
----------------------------------------------------------------------
forms集合(面中的表单)
a)通过集合引用
document.forms //对应面上的<form>标签
document.forms.length //对应面?lt;form>标签的个?br>document.forms[0] //W??lt;form>标签
document.forms[i] //Wi-1?lt;form>标签
document.forms[i].length //Wi-1?lt;form>中的控g?br>document.forms[i].elements[j] //Wi-1?lt;form>中第j-1个控?br>
b)通过标签name属性直接引?br><form name="Myform"><input name="myctrl"></form>
document.Myform.myctrl //document.表单?控g?br>
-----------------------------------------------------------------------
<html>
<!--Text控g相关Script-->
<form name="Myform">
<input type="text" name="oText">
<input type="password" name="oPswd">
<form>
<script language="javascript">
//获取文本密码框的?br>document.write(document.Myform.oText.value)
document.write(document.Myform.oPswd.value)
</script>
</html>
-----------------------------------------------------------------------
<html>
<!--Select控g相关Script-->
<form name="Myform">
<select name="oSelect">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select>
</form>
<script language="javascript">
//遍历select控g的option?br> var length
length=document.Myform.oSelect.length
for(i=0;i<length;i++)
document.write(document.Myform.oSelect[i].value)
</script>
<script language="javascript">
//遍历optionƈ且判断某个option是否被选中
for(i=0;i<document.Myform.oSelect.length;i++){
if(document.Myform.oSelect[i].selected!=true)
document.write(document.Myform.oSelect[i].value)
else
document.write("<font color=red>"+document.Myform.oSelect[i].value+"</font>")
}
</script>
<script language="javascript">
//Ҏ(gu)SelectedIndex打印出选中的option
//(0到document.Myform.oSelect.length-1)
i=document.Myform.oSelect.selectedIndex
document.write(document.Myform.oSelect[i].value)
</script>
<script language="javascript">
//动态增加select控g的option?br> var oOption = document.createElement("OPTION");
oOption.text="4";
oOption.value="4";
document.Myform.oSelect.add(oOption);
</script>
<html>
-----------------------------------------------------------------------
<Div id="oDiv">Text</Div>
document.all.oDiv //引用囑ֱoDiv
document.all.oDiv.style
document.all.oDiv.style.display="" //囑ֱ讄为可?br>document.all.oDiv.style.display="none" //囑ֱ讄为隐?br>/*document.all表示document中所有对象的集合
只有ie支持此属性,因此也用来判断浏览器的种c?/
click() 对象.click() 使对象被点击?br>closed 对象.closed 对象H口是否已关闭true/false
clearTimeout(对象) 清除已设|的setTimeout对象
clearInterval(对象) 清除已设|的setInterval对象
confirm("提示信息") 弹出认框,定q回true取消q回false
cursor:样式 更改鼠标样式 hand crosshair text wait help default auto e/s/w/n-resize
event.clientX q回最后一ơ点击鼠标X坐标|
event.clientY q回最后一ơ点击鼠标Y坐标|
event.offsetX q回当前鼠标(zhn)停X坐标?br>event.offsetY q回当前鼠标(zhn)停Y坐标?br>
document.write(document.lastModified) |页最后一ơ更新时?br>document.ondblclick=x 当双击鼠标生事?br>document.onmousedown=x 单击鼠标键生事?br>
document.body.scrollTop; q回和设|当前竖向滚动条的坐标|M函数配合,
document.body.scrollLeft; q回和设|当前横向滚动务的坐标|M函数配合Q?br>document.title document.title="message"; 当前H口的标题栏文字
document.bgcolor document.bgcolor="颜色?; 改变H口背景颜色
document.Fgcolor document.Fgcolor="颜色?; 改变正文颜色
document.linkcolor document.linkcolor="颜色?; 改变联接颜?br>document.alinkcolor document.alinkcolor="颜色?; 改变正点击联接的颜色
document.VlinkColor document.VlinkColor="颜色?; 改变已访问联接的颜色
document.forms.length q回当前form表单?br>document.anchors.length q回当前锚的数?br>document.links.length q回当前联接的数量
document.onmousedown=x 单击鼠标触发事g
document.ondblclick=x 双击鼠标触发事g
defaultStatus window.status=defaultStatus; 状态栏讄默认昄
function function xx(){...} 定义函数
isNumeric 判断是否是数?br>innerHTML xx=对象.innerHTML 输入某对象标{中的html源代?br>innerText divid.innerText=xx 以div定位以id命名的对象D为XX
location.reload(); 使本刷斎ͼtarget可等于一个刷新的|页
Math.random() 随机涉|,只能??之间的数,如果要得到其它数,可以?10,再取?br>Math.floor(number) 对象number转ؓ(f)整数Q舍取所有小?br>Math.min(1,2) q回1,2哪个?br>Math.max(1,2) q回1,2哪个?br>
navigator.appName q回当前览器名U?br>navigator.appVersion q回当前览器版本号
navigator.appCodeName q回当前览器代码名?br>navigator.userAgent q回当前览器用户代标志
onsubmit onsubmit="return(xx())" 使用函数q回?br>opener opener.document.对象 控制原打开H体对象
prompt xx=window.prompt("提示信息","预定?); 输入语句
parent parent.框架?对象 控制框架面
return return false q回?br>random 随机参数Q??之间Q?br>reset() form.reset(); 使form表单内的数据重置
split("") string.split("") string对象字符以逗号隔开
submit() form对象.submit() 使form对象提交数据
String对象?nbsp;charAt(x)对象 反回指定对象的第多少位的字母
lastIndexOf("string") 从右到左询找指定字符Q没有返?1
indexOf("string") 从左到右询找指定字符Q没有返?1
LowerCase() 对象全部{为小?br>UpperCase() 对象全部{为大?br>substring(0,5) string.substring(x,x) q回对象中从0?的字W?br>setTimeout("function",time) 讄一个超时对?br>setInterval("function",time) 讄一个超时对?br>
toLocaleString() x.toLocaleString() 从x旉对象中获取时_(d)以字W串型式存在
typeof(变量? (g)查变量的cdQ值有QString,Boolean,Object,Function,Underfined
window.event.button==1/2/3 鼠标键左键等?右键{于2两个键一h?
window.screen.availWidth q回当前屏幕宽度(I白I间)
window.screen.availHeight q回当前屏幕高度(I白I间)
window.screen.width q回当前屏幕宽度(分L率?
window.screen.height q回当前屏幕高度(分L率?
window.document.body.offsetHeight; q回当前|页高度
window.document.body.offsetWidth; q回当前|页宽度
window.resizeTo(0,0) 窗口设|宽?br>window.moveTo(0,0) 窗口移到某位置
window.focus() 使当前窗口获得焦?br>window.scroll(x,y) H口滚动条坐标,y控制上下UdQ须与函数配?br>window.open() window.open("地址","名称","属?)
属?toolbar(工具?,location(地址?,directions,status(状态栏),
menubar(菜单?,scrollbar(滚动?,resizable(改变大小), width(?,height(?,fullscreen(?nbsp;?,scrollbars(全屏时无滚动条无?nbsp;?channelmode(宽屏),left(打开H口x坐标),top(打开H口y坐标)
window.location = 'view-source:' + window.location.href 应用事g查看|页源代?
a=new Date(); //创徏aZ个新的时期对?br>y=a.getYear(); //y的gؓ(f)从对象a中获取年份?nbsp;两位数年?br>y1=a.getFullYear(); //获取全年份数 四位数年?br>m=a.getMonth(); //获取月䆾?br>d=a.getDate(); //获取日期?br>d1=a.getDay(); //获取当前星期?br>h=a.getHours(); //获取当前时?br>m1=a.getMinutes(); //获取当前分钟?br>s=a.getSeconds(); //获取当前U钟?br>
对象.style.fontSize="文字大小";
单位Qmm/cm/in英寸/pc?pt?px象素/em文字?br>1in=1.25cm
1pc=12pt
1pt=1.2px(800*600分辩率下)
文本字体属性:(x)
fontSize大小
family字体
color颜色
fontStyle风格Q取gؓ(f)normal一?italic斜体,oblique斜体且加_?br>fontWeight加粗,取gؓ(f)100?00不等,900最_?light,normal,bold
letterSpacing间距,更改文字间距?取gؓ(f),1pt,10px,1cm
textDecoration:文字修饰;取?none不修?underline下划U?overline上划U?br>background:文字背景颜色,
backgroundImage:背景囄,取gؓ(f)囄的插入\?br>
点击|页正文函数调用触发器:(x)
1.onClick 当对象被点击
2.onLoad 当网|开,只能书写在body?br>3.onUnload 当网关闭或d?只能书写在body?br>4.onmouseover 当鼠标?zhn)于其上?br>5.onmouseout 当鼠标离开对象?br>6.onmouseup 当鼠标松开
7.onmousedown 当鼠标按下键
8.onFocus 当对象获取焦Ҏ(gu)
9.onSelect 当对象的文本被选中?br>10.onChange 当对象的内容被改?br>11.onBlur 当对象失ȝ?br>onsubmit=return(ss())表单调用时返回的?br>
直线 border-bottom:1x solid black
虚线 border-bottom:1x dotted black
点划U?nbsp;border-bottom:2x dashed black
双线 border-bottom:5x double black
槽状 border-bottom:1x groove black
脊状 border-bottom:1x ridge black
1.边缘高光glow(color=颜色,strength=亮光大小)
]]>
4Q?在弹出的“Add JRE”画面中,选择JRE的目录,
是选择你所在的JDK的目录,
在JRE名称一栏中Q填下想取的名称Q我q里?#8220;JDK”Q?br> 然后“OK”定
tomcat也要使用jdk而不是jre否则?x)无法编译文?/p>
5Q?q回到设|框中,刚刚配|的JRE选中
6Q?开始配|MyEclipseQ?br> 左侧MyEclipse节点?#8220;Application Server”中有TomcatQ?br> 选择自己安装的版本,
Tomcat Server设ؓ(f)可用Qƈ讄Tomcat的安装目?br>7Q?在Tomcat的JDK中选择刚刚配置的JDK