jspconnsqlserver.txt
来自「实现jsp与sqlserver数据库的链接」· 文本 代码 · 共 32 行
TXT
32 行
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<html>
<head>
<title>My JSP 'connnector.jsp' starting page</title>
</head>
<body>
<%
String DBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String DBUrl = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=yjscjgl";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
Class.forName(DBDriver);
}catch(Exception exc){
System.out.println(exc.getMessage());
}
conn = DriverManager.getConnection(DBUrl,"sa","");
stmt = conn.createStatement();
String sql = "select * from TB_CRS_KIND";
rs = stmt.executeQuery(sql);
while(rs.next()){
out.print(rs.getInt("CRS_KIND_NUM") + " " + rs.getString("CRS_KIND_NAM") + "<br>");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?