?? 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 + -