📄 test1.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*" %>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>数据库连接</title>
</head><%
String sql=" SELECT * FROM Test";
String drivername="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:mydb";
Connection con=null;
Statement state=null;
ResultSet rs=null;
out.print("JDBC-ODBC桥接器连接MS SQL Server 2000<br>");
out.println("<br>");
try{
Class.forName(drivername);
con= DriverManager.getConnection(url);
state=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=state.executeQuery(sql);
while(rs.next()){
int id=rs.getInt(1);
String username=rs.getString(2);
out.print(id+" ");
out.print(username+"<br>");
}
}catch(Exception e){
out.print("Exception>> "+e.getMessage());
}finally{
if(rs!=null) rs.close();
if(rs!=null) state.close();
if(rs!=null) con.close();
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -