網(wǎng)絡(luò)編程教程模板無(wú)憂(yōu)>建站教程>網(wǎng)絡(luò)編程>JSP教程>

JSP調(diào)用SQL server 2000存儲(chǔ)過(guò)程_JSP教程

教程Tag：暫無(wú)Tag,歡迎添加,賺取U幣!

推薦：使用FileWriter可以寫(xiě)UTF-8的解決方法
FileWriter不能寫(xiě)utf-8，相信好呢多新手都遇到過(guò)吧，今天我們就來(lái)解決這個(gè)問(wèn)題，看下面的例子。 package cn.yethyeth.sample.io; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.Outp

1.新建表：

CREATE TABLE [mytest] (
[id] [int] NOT NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[phone] [varchar] (13) COLLATE Chinese_PRC_CI_AS NULL ,
[addr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

2.新建存儲(chǔ)過(guò)程：

create procedure get_info @name varchar(50),@phone varchar(13),@addr varchar(50)
as
select *
from mytest
go

3.JSP代碼：

<%@ page language="java" pageEncoding="UTF-8" import="java.sql.*,tools.Database"%>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" divfix="bean" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-html" divfix="html" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" divfix="logic" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-tiles" divfix="tiles" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html:html locale="true">
<head>
<html:base />
<title>proc_test.jsp</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
</head>
<body>
This is a test for procedure. <br>
<%
String username="sa";
String password = "123456";
String url = "jdbc:microsoft:sqlserver://192.168.1.112:1433;DatabaseName=test";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection conn = DriverManager.getConnection(url, username, password);
String sql = "execute get_info";
//創(chuàng)建一個(gè)CallableStatement 對(duì)象來(lái)調(diào)用數(shù)據(jù)庫(kù)存儲(chǔ)過(guò)程
//CallableStatement comm = conn.divpareCall(sql);
Statement stmt = conn.createStatement();

ResultSet res = stmt.executeQuery(sql);
while(res.next())...{
%>
<table>
<tr>
<td><%=res.getString("id")%></td>
<td><%=res.getString("name")%></td>
<td><%=res.getString("phone")%></td>
<td><%=res.getString("addr")%></td>
</tr>
</table>
<%}
res.close();
stmt.close();
conn.close();
%>
</body>
</html:html>

4.執(zhí)行結(jié)果：

This is a test for procedure.
1 cc 1234 cs
2 dd 4567 bj
3 ee 1245 ca

分享：關(guān)于Jsp頁(yè)面的幾種傳參方式
1.JavaScript傳參:這種傳參方式用opener關(guān)鍵字, 可以實(shí)現(xiàn)跨頁(yè)傳參.其用法就是用opener關(guān)鍵字調(diào)用父窗體的一個(gè)組件. 舉例: opener.myform.txt.value = document.myform.txt.value; 優(yōu)點(diǎn): 簡(jiǎn)單,對(duì)網(wǎng)絡(luò)傳輸限制比較底. 缺點(diǎn): 不靈活,對(duì)與大量的傳參不現(xiàn)實(shí),也不