就在servlet里访问数据库查询用户信息咯,不是要我整个servlet写出来吧....
解决方案 »
- Freemarker Template 的高手来看看吧
- 有沒有方法實現根據database產生預約時間表
- 企业门户前台web框架
- Hibernate的配置问题,解决后马上给分
- 求阿信的动态树的jsp版本的代码(急)
- TOMCAT设置问题.
- Spring使用@Component执行计划任务的问题
- 急!谁能告诉我下载j2eetutorial(有sun在线银行的例子)的具体地址连接?
- weblogic+oracle8i 的连接池配置问题,老是配不起来,也查过帖子.....
- 请问tomcat中,将编好的javabean应放在那个目录下?
- 如何html中加入另存为按钮?
- 求抽奖程序,请各位大侠拔刀相助!!!感激不尽!!(100分倾囊相赠)
出手相助。写一个出来啊。
也顺便发给我哦。[email protected]
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;public class DBPhoneLookupReuse extends HttpServlet { private Connection con = null; public void init() throws ServletException {
try {
// Load (and therefore register) the Sybase driver
Class.forName("com.sybase.jdbc.SybDriver");
con = DriverManager.getConnection(
"jdbc:sybase:Tds:dbhost:7678", "user", "passwd");
}
catch (ClassNotFoundException e) {
throw new UnavailableException("Couldn't load database driver");
}
catch (SQLException e) {
throw new UnavailableException("Couldn't get db connection");
}
} public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html");
PrintWriter out = res.getWriter(); out.println("<HTML><HEAD><TITLE>Phonebook</TITLE></HEAD>");
out.println("<BODY>"); HtmlSQLResult result =
new HtmlSQLResult("SELECT NAME, PHONE FROM EMPLOYEES", con); // Display the resulting output
out.println("<H2>Employees:</H2>");
out.println(result);
out.println("</BODY></HTML>");
} public void destroy() {
// Clean up.
try {
if (con != null) con.close();
}
catch (SQLException ignored) { }
}
}
这是书上的一例子,我copy出来,你可以修改下就好了.
import java.io.PrintStream;
import java.sql.*;public class sqlbean
{ String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:down";
Connection conn = null;
ResultSet rs = null; public sqlbean()
{
try
{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println("sqlbean();" + classnotfoundexception.getMessage());
}
} public ResultSet executQuery(String sql)
{
rs=null;
try
{
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException sqlexception)
{
System.err.println("sqlbean.executeUpdate):" + sqlexception.getMessage());
}
return rs;
}
}