📄 servletdb.java

📁 《jsp网站开发技术》中的源代码(清华大学出版社)

💻 JAVA

字号:

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class servletDB extends HttpServlet
{ 
public void doGet (HttpServletRequest req,HttpServletResponse resp)
  throws ServletException, IOException
{
PrintWriter out;
String title="Servlet connecting to ODBC DB";

resp.setContentType("text/html;charset=GB2312");
out = resp.getWriter();

out.println("<HTML><HEAD><TITLE>");
out.println(title);
out.println("</TITLE></HEAD><BODY>");
out.println("<H1>" + title + "</H1>");
out.println("<P>This is output from SimpleServlet.</P>");
out.println("ID NAME AGE");
out.println("<br>");
String driverName="sun.jdbc.odbc.JdbcOdbcDriver";

Connection con;
Statement stmt;
ResultSet results;

try{
Class.forName(driverName).newInstance();
con=DriverManager.getConnection("jdbc:odbc:MyDB","admin","admin"); 
stmt=con.createStatement(); 
String sqlstr="select * from class"; 
results=stmt.executeQuery(sqlstr); 

ResultSetMetaData rsmd = results.getMetaData();
int numCols = rsmd.getColumnCount();

while (results.next()){
for(int i=1;i<=numCols;i++)
{out.println(results.getString(i));}
out.println("<br>");
}

stmt.close();
con.close();
}catch (Exception e)
{
out.println("error: " + e.toString()+"here");        
} 

out.println("</BODY></HTML>");
out.close();
}
 
}

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -