?? jdbc.java
字號:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class jdbc extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
res.setContentType("text/html");
PrintWriter pw=res.getWriter();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
pw.println("Driver Loaded");
con=DriverManager.getConnection("jdbc:odbc:sri","scott","tiger");
pw.println("Connection Established");
stmt=con.createStatement();
pw.println("Statement Prepared");
String qry="select * from books where title like 'a%' ";
pw.println(qry);
pw.println("Statement Under Execcution.....");
rs=stmt.executeQuery(qry);
pw.println("<ul>");
while(rs.next())
{
pw.println("<li>"+rs.getString("title")+" "+rs.getString("author"));
}
pw.println("<ul>");
}
catch(ClassNotFoundException e){}
catch(SQLException e){}
finally
{
try
{ if (con!=null)
con.close();
}catch(SQLException e){}}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -