?? midletuserdataservlet.java
字號:
import java.sql.*;
import javax.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import db.* ;
public class MIDletUserDataServlet extends HttpServlet
{
protected void doGet(HttpServletRequest request,HttpServletResponse response)
throws IOException, ServletException
{
response.setContentType("text/plain;charset=UTF-8");
DataOutputStream dos = new DataOutputStream(response.getOutputStream());
Connection conn = null ;
ResultSet rs = null ;
Statement stmt = null ;
try
{
AccessDAO da = new AccessDAO("enterprisedata") ;
conn = da.getConnection() ;
stmt = conn.createStatement() ;
String command = "select * from user" ;
rs = stmt.executeQuery(command) ;
while(rs.next())
{
StringBuffer s = new StringBuffer("") ;
s.append(rs.getString("id")) ;
s.append(",") ;
s.append(rs.getString("password")) ;
s.append(",") ;
s.append(rs.getString("description")) ;
s.append(";") ;
dos.writeUTF(s.toString()) ;
dos.flush() ;
}
dos.close() ;
rs.close() ;
stmt.close() ;
conn.close() ;
}catch(Exception e)
{
}
}
}
//取得參數的方式
//String xxx = request.getParameter("xxx");
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -