学步园

DbConnMysql.java

--------------------------------------

package conn;
import java.sql.*;

public class DbConnMysql
{
 private Connection conn;     //连接对象
 private PreparedStatement psm ;    //执行对象
 private ResultSet rs ;      //结果集

 private String MysqlDriver ;    //mysql驱动
 private String MysqlURL ;     //mysql连接路径

 //server：mysql所在服务器
 //dbname：数据库名
 //user：数据库用户名
 //pass：数据库密码
 //port：数据库端口号
 public Connection getConnToMysql(String server,String dbname,String user,String pass,String port)
 {
  MysqlDriver = "org.gjt.mm.mysql.Driver";
  MysqlURL = "jdbc:mysql://";
  try
  {
   MysqlURL = MysqlURL+server+":"+port+"/"+dbname+"?user="+user+"&password="+pass+"&userUnicode=true&characterEncoding=gb2312";
   Class.forName(MysqlDriver);
   conn = DriverManager.getConnection(MysqlURL);
  }
  catch (Exception e)
  {
   System.out.println("数据库连接出错！");
   System.out.println(e.getMessage());
  }
  return conn;
 }

 public void close()
 {
  try
  {
   conn.close();
  }
  catch (SQLException sqlexeception)
  {
   System.out.println("数据库关闭失败");
   System.out.println(sqlexeception.getMessage());
  }
 }
}

====================================================

测试jsp文件

test.jsp

--------------------------------------

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import = "java.sql.*" %>
<jsp:useBean id="DBConn" scope="page" class="conn.DbConnMysql" />

<%

 String server = "localhost" ;
 String dbname = "tang";
 String user = "root" ;
 String pass = "admin" ;
 String port = "3306" ;

 Connection conn = null;
 PreparedStatement psm = null;
 ResultSet rs = null;
 String sql = null;
 conn = DBConn.getConnToMysql(server,dbname,user,pass,port);
 
 sql = "select * from test";
 psm = conn.prepareStatement(sql);
 rs = psm.executeQuery();

 while(rs.next())
 {
%>
  <%=rs.getString(2)%> <br />
<%
 }
 
 rs.close();
 psm.close();
 DBConn.close();
%>