JSP调用SQL server 2000存储过程

时间:2010-01-21 08:23:17  来源:第二电脑网  作者:第二电脑网

  第二电脑网导读:) ON [PRIMARY]GO 2.新建存储过程: 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.o...
  正文:

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.新建存储过程: 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"; //创建一个CallableStatement 对象来调用数据库存储过程 //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.执行结果: This is a test for procedure. 1 cc 1234 cs 2 dd 4567 bj 3 ee 1245 ca


"JSP调用SQL server 2000存储过程"由第二电脑网原创提供,转载请注明:http://www.002pc.com/master/College/Programming/JSP/12132.html


关键字:

关于《JSP调用SQL server 2000存储过程》文章的评论

站内搜索: 高级搜索

热门搜索: Windows style 系统 tr IP QQ CPU 安装 function 注册 if td