用JavaBean连接MySQL

最新推荐文章于 2021-03-14 18:01:38 发布

wobuzhidaoni

最新推荐文章于 2021-03-14 18:01:38 发布

阅读量934

点赞数

文章标签： mysql string exception sql null class

本文链接：https://blog.csdn.net/wobuzhidaoni/article/details/6464452

版权

连接MySQL

DbMySQL.java

/**
*
*/
package bean;
import java.sql.*;
/**
* @author
*
*/
public class DbMySQL
{
String user ="root";
String pass = "mylove";
String url = "jdbc:mysql://localhost/stums";

Connection con = null;
Statement stm =null;
ResultSet rs = null;

public Connection getCon() throws ClassNotFoundException, SQLException
{
  Class.forName("com.mysql.jdbc.Driver");
  con =DriverManager.getConnection(url,user,pass);
  return con;
}

public ResultSet executeQuery(String sql) throws ClassNotFoundException, SQLException
{
  try
  {
   con = getCon();
   stm = con.createStatement();
   rs = stm.executeQuery(sql);
  }
  catch(Exception sqle)
    {
     sqle.printStackTrace();
    }

   return rs;
}

public void close() throws SQLException
{
  if(rs!=null) rs.close();
  if(stm!=null) stm.close();
  if(con!=null) con.close();
}
}

conMySQL.jsp

<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="gb2312"%>
<%@ page import= "java.sql.*"%>
<jsp:useBean id="db" class="bean.DbMySQL" scope="page"></jsp:useBean>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>使用JavaBean连接MySQL使用示例</title>
</head>
<body>
<h2 align="center" style="color:red"><strong>使用JavaBean连接MySQL使用示例</strong></h3>
<hr>
<%
String sql = "select * from student";
ResultSet rs = db.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
%>
<table border="1" align="center">
<%
out.println("<tr>");
for(int i=1;i<=rsmd.getColumnCount(); i++)
{
out.println("<th>"+rsmd.getColumnName(i) +"</th>");
}
while(rs.next())
{
out.print("<tr>");
   out.println("<td>"+rs.getString(1)+"</td>");
     out.println("<td>"+rs.getString(2)+"</td>");
     out.println("<td>"+rs.getString(3)+"</td>");
     out.println("<td>"+rs.getString(4)+"</td>");
     out.println("<td>"+rs.getString(5)+"</td>");
     out.println("<td>"+rs.getString(6)+"</td>");
     out.println("<td>"+rs.getString(7)+"</td>");
     out.println("<td>"+rs.getString(8)+"</td>");
     out.println("</tr>");
}
db.close();

%>
</table>

</body>
</html>