SERVLET PRATICE

最新推荐文章于 2025-09-07 20:32:33 发布

转载最新推荐文章于 2025-09-07 20:32:33 发布 · 104 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/anstoner/p/6284316.html

文章标签：

#java #数据库

本文介绍了一个Java程序中实现数据库连接的具体方法，并通过一个简单的JSP页面展示了如何使用Struts框架进行基本的Web应用开发。

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DBConnection
{
    private static final String DBDRIVER = "com.mysql.jdbc.Driver" ;
    private static final String DBURL = "jdbc:mysql://localhost:3306/db_Struts1;
                                        private static final String DBUSER = "root" ;
                                        private static final String DBPASSWORD = "123456";
                                        public static Connection getConnection()
                                    {
                                        Connection conn = null;
                                        try
                                    {
                                        Class.forName(DBDRIVER);
                                        conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
                                    }
                                        catch (ClassNotFoundException e)
                                    {
                                        e.printStackTrace();
                                    }
                                        catch (SQLException e)
                                    {
                                        e.printStackTrace();
                                    }
                                        return conn;
                                    }
                                        public static void close(Connection conn)
                                        if(conn != null)
                                    {
                                        try
                                    {
                                        conn.close();
                                    }
                                        catch (SQLException e)
                                    {
                                        e.printStackTrace();
                                    }
                                    }
                                    }
                                        public static void close(PreparedStatement pstmt)
                                    {
                                        if(pstmt != null)
                                    {
                                        try
                                    {
                                        pstmt.close();
                                    }
                                        catch (SQLException e)
                                    {
                                        e.printStackTrace();
                                    }
                                    }
                                    }
                                        public static void close(ResultSet rs)
                                    {
                                        if(rs != null)
                                    {
                                        try
                                    {
                                        rs.close();
                                    }
                                        catch (SQLException e)
                                    {
                                        e.printStackTrace();
                                    }
                                    }
                                    }
                                    }

Jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'index.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">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
  
  <body>
    <a href="firstAction">访问action</a>
  </body>
</html>

转载于:https://www.cnblogs.com/anstoner/p/6284316.html