returnmsg.java

1.和servlet一起用,实现从Tomcat服务器上下载信息到手机上 2.实现手机的网络功能

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

public class returnMsg extends HttpServlet
{
 public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
 {
  res.setContentType("text/html; charset=gb2312");//设置返回的类型
  
  ServletOutputStream out = res.getOutputStream();//得到输出流
  
  
  DataOutputStream dos = new DataOutputStream(out);
    
  dos.writeUTF("这是测试结果");
  dos.writeUTF("下面是数据信息");
  Connection conn = null;
  ResultSet rs = null;
  Statement stmt = null;
  
 
  try
  {
   
   String drname = "sun.jdbc.odbc.JdbcOdbcDriver";//这些是连接数据库的驱动
   
   Class.forName(drname);
   
   String url = "jdbc:odbc:mydata";
   
   conn = DriverManager.getConnection(url);
   
   stmt = conn.createStatement();
   rs = stmt.executeQuery("select * from user");//查询数据库表 表名为user
   
   while(rs.next())
   {
    dos.writeUTF("用户ID:"+rs.getString("ID"));//得到字段ID 和字段name 内容
    dos.writeUTF("用户名:"+rs.getString("name"));
    // out.print(rs.getString("ID"));
   }
   rs.close();
   stmt.close();
   conn.close();

 

  }catch(Exception e)
  {
   
  }
 }
}