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 + -
显示快捷键?