📄 jspconnsqlserver.txt
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -