?? servletconnect.java
字號:
import java.net.*;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class ServletConnect extends HttpServlet
{
public void service(ServletRequest rq,ServletResponse rp) throws ServletException,IOException
{
Connection con = null; //定義數據庫連接對象
Statement stmt = null; //定義數據庫聲明對象
ResultSet rset = null; //定義記錄結果集對象
String sSQLCmd = null; //存放T-SQL語句
String Recordset1 = null;
String Recordset2 = null;
String Recordset3 = null;
String ResponseStr = null;
String ResponseStr_chs = null;
rp.setContentType("text/html"); //定義反饋信息的輸出格式
ServletOutputStream out = rp.getOutputStream(); //定義輸出流對象
sSQLCmd = rq.getParameter("ssqlcmd");
if (sSQLCmd == null || sSQLCmd.length() < 1)
{
/* 如果前天提交的查詢命令有錯誤,則返回error */
out.print("error");
}
else
{
/* 開始查詢,并將查詢結果反饋給前臺的Applet */
try
{
/* 利用JDBC-ODBC橋建立數據庫連接 */
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
con = DriverManager.getConnection("jdbc:odbc:DemoDB","demo","demo");
stmt = con.createStatement ();
rset = stmt.executeQuery (sSQLCmd);
while(rset.next())
{
Recordset1 = rset.getString(1);
Recordset2 = rset.getString(2);
Recordset3 = rset.getString(3);
Recordset1 = (Recordset1 == null) ? "不限" : Recordset1;
Recordset2 = (Recordset2 == null) ? "不限" : Recordset2;
Recordset3 = (Recordset3 == null) ? "不限" : Recordset3;
ResponseStr = Recordset1 + "," + Recordset2 + "," + Recordset3;
ResponseStr_chs = new String(ResponseStr.getBytes("iso-8859-1")); //轉換中文字符
System.out.print("<" + ResponseStr + "> ... ");
out.print(ResponseStr_chs);
System.out.print("... has been sent.\n");
}
rset.close();
con.close();
}
catch(SQLException e)
{
System.out.println("!程序在運行是出現例外:" + e.toString());
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -