数据源与连接池

最新推荐文章于 2023-05-23 13:09:28 发布

fanyuan19901021

最新推荐文章于 2023-05-23 13:09:28 发布

阅读量343

点赞数

文章标签： string vector class import exception null

本文链接：https://blog.csdn.net/fanyuan19901021/article/details/6504150

版权

数据源和连接池（以MySql为例）
1.创建数据库
create database dbtest;
use dbtest;
create table student
(
studentid char(20) not null,
name char(30) not null,
address varchar(200),
constraint primary key(studentid)
);
insert into student(studentid,name,address)values('10','张三','北京');
insert into student(studentid,name,address)values('11','李四','河北');
2.tomcat中配置server.xml
在最后一个</host>前添加以下代码
<Context path="/test1" docBase="D:/java projects/test1/WebRoot"
        debug="5" reloadable="true" crossContext="true">
  <Resource name="jdbc/dbtest" auth="Container" type="javax.sql.DataSource"
               maxActive="100" maxIdle="30" maxWait="10000"
               username="root" password="root" driverClassName="com.mysql.jdbc.Driver"
               url="jdbc:mysql://localhost/dbtest"/>

</Context>
3.配置webapp中web.xml
<resource-ref>
<description>DataSource</description>
<res-ref-name>jdbc/dbtest</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
4.测试程序
新建工程：test1
创建2个.java文件
/DBStudent .java
package db;
import java.io.*;
import java.util.*;
import java.sql.*;
public class DBStudent {
private String studentid;
private String name;
private String address;
public static Vector getAllStudent()
{
  Vector stus=new Vector();
  Connection conn=null;
  Statement stmt=null;
  try{
   conn=DbTestDS.getConnection();
   if(conn!=null)
   {
    stmt=conn.createStatement();
    ResultSet rs=stmt.executeQuery("select * from student");
    while(rs.next())
    {
     String studentid1=rs.getString(1);

     String name1=new String(rs.getString(2));
     String address1=new String(rs.getString(3));
     DBStudent DBstu=new DBStudent();
     DBstu.setStudentid(studentid1);
     DBstu.setName(name1);
     DBstu.setAddress(address1);
     stus.add(DBstu);
    }
    rs.close();
    stmt.close();
   }

  }catch(SQLException e){
   e.printStackTrace();
  }
  return stus;
}
public void setStudentid(String studentid)
{
  this.studentid=studentid;
}
public void setName(String name)
{
  this.name=name;
}
public void setAddress(String address)
{
  this.address=address;
}
public String getStudentid()
{
  return studentid;
}
public String getName()
{
  return name;
}
public String getAddress()
{
  return address;
}
}
//DbTestDS .java
package db;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
public class DbTestDS {
private static DataSource ds=null;
static
{
  init();
}
private static void init()
{
  try{
   Context ctx=new InitialContext();
   if(ctx==null)
   {
    throw new Exception("No Context");
   }
   Context envContext=(Context)ctx.lookup("java:comp/env");
   ds=(DataSource)envContext.lookup("jdbc/dbtest");
  }catch(Exception e)
  {
   e.printStackTrace();
  }

}
private DbTestDS(){}
public static Connection getConnection()throws SQLException{
  if(ds==null)
  {
   throw new SQLException("找不到数据源");
  }
  else
  {
   return ds.getConnection();
  }
}
//index.jsp///
<%@ page language="java" import="java.util.*,java.sql.*,db.*" pageEncoding="GB2312"%>
<%@ page contentType="text/html;charset=gb2312" errorPage=""%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=GB2312">
<title>使用配置数据源</title>
</head>
<body>
<% Vector stus=DBStudent.getAllStudent();
int num=stus.size();
%>

fanyuan19901021

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
2
评论
数据源与连接池

数据源和连接池（以MySql为例）1.创建数据库create database dbtest;use dbtest;create table student( studentid char(20) not null, name char(30) not null, address varchar(200), constraint primary key(st
复制链接

扫一扫