Question

如何使用jsp servlet调用jdbc

Answer 1

你可以新建一个class，来写数据库连接 ，然后再调用，这样方便点

Answer 2

新建一个servlet文件，代码如下：
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.naming.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.*;
import java.util.Properties;

public class Example1 extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

PrintWriter out=response.getWriter();
out.println("
This is a servlet test.
");
//out.flush();

DataSource ds = null;
Context ctx = null;
Connection myConn = null;
try {
/* 获得WebLogic ServerJNDI初始上下文信息*/

ctx = getInitialContext();
/* 建立数据源对象*/

ds = (javax.sql.DataSource)
ctx.lookup("myDataSource");
}
catch (Exception E) {
System.out.println("Init Error: " + E);
}
Statement myStatement=null;
ResultSet myResultSet=null;
try {
//建立连接
myConn = ds.getConnection();
// 建立语句对象
myStatement = myConn.createStatement();
//建立结果集对象
myResultSet = myStatement.executeQuery(
"SELECT tname from tab where rownum<=1"
);
//遍历结果集对象，访问每一条记录，输出full_name字段
while(myResultSet.next())
{
out.println("table name： " + myResultSet.getString("tname"));
}
//关闭结果集
myResultSet.close();
}
catch (SQLException e) {
out.println("Error code = " + e.getErrorCode());
out.println("Error message = " + e.getMessage());
}
finally {
try {
// close the Statement object using the close() method
if (myStatement != null) {
myStatement.close();
}
// close the Connection object using the close() method
if (myConn != null) {
myConn.close();
}
}
catch (SQLException e) {
out.println("Error code = " + e.getErrorCode());
out.println("Error message = " + e.getMessage());
}
}
}
private static Context getInitialContext() throws Exception {
String url = "t3://localhost:7001";
String user = "weblogic";
String password = "weblogic";
Properties properties = null;
try {
properties = new Properties();
properties.put(Context.INITIAL_CONTEXT_FACTORY,
"weblogic.jndi.WLInitialContextFactory");
properties.put(Context.PROVIDER_URL, url);
if (user != null) {
properties.put(Context.SECURITY_PRINCIPAL, user);
properties.put(Context.SECURITY_CREDENTIALS, password == null ? "" : password);
}
return new InitialContext(properties);
}
catch(Exception e) {
throw e;
}
}
}
代码