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
insert into mytest values(1,'cc','dd','ss');
go
insert into mytest values(2,'ss','ll','c');
go
insert into mytest values(3,'nn','l','ii');
go
2.新建存储过程:
create procedure get_info @name varchar(50),@phone varchar(13),@addr varchar(50)
as
select *
from mytest
go
3 t4.jsp
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date" %>
<html>
<head><title>成功添加信息</title></head>
<body>
<%
String username="sa";
String password = "sa";
String url = "jdbc:microsoft:sqlserver://10.0.2.254:1433;DatabaseName=test";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection conn = DriverManager.getConnection(url, username, password);
String sql = "execute get_info cc,dd,ss";
//创建一个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>
4 结果
http://10.0.2.254:8090/test4/t4.jsp
1 | cc | dd | ss |
2 | ss | ll | cc |
3 | nn | l | ii |
评论