公共数据库访问连接javabean开发

最新推荐文章于 2021-06-11 21:01:33 发布

haiwei_sun

最新推荐文章于 2021-06-11 21:01:33 发布

阅读量924

点赞数

分类专栏： java 文章标签：数据库 string stylesheet null exception import

本文链接：https://blog.csdn.net/helen_shw/article/details/4694387

版权

java 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

package JavaBean;
import java.io.PrintWriter;
import java.sql.*;

public class DB_Conn {
private String driverName = "com.mysql.jdbc.Driver";
private String userName = "root";
private String userPwd = "123456";
private String dbName = "netvii3d";
private String url = "jdbc:mysql://localhost/"+dbName+
     "?user="+userName+"&password="+userPwd;
private Connection conn = null;
public Statement sm = null;
private PrintWriter out = null;

public void ConnectDB()
{
   try
   {
   Class.forName(driverName).newInstance();
   conn = DriverManager.getConnection(url);
   sm = conn.createStatement();
   }
   catch (Exception ex)
   {
    ex.printStackTrace();
    out.print("数据库连接失败！");
   }

}

public void CloseDB()
{
   try{
    if(sm!=null)
    {
     sm.close();

    }
    conn.close();
   }
   catch(SQLException ex)
   {
    ex.printStackTrace();
    out.print("数据库关闭失败");
   }
}
}

test.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="JavaBean.DB_Conn" %>
<jsp:useBean id="db" class="JavaBean.DB_Conn" scope="page" />
<jsp:setProperty name="db" property="*" />

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

    <title>My JSP 'test.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>

<body> 
    <%
    db.ConnectDB();
    java.sql.ResultSet rs = db.sm.executeQuery("select * from video_info limit 20");
    while(rs.next())
    {
    out.print(rs.getString("name"));
    out.print("<br>");
    }
     %>
</body>
</html>