1,mysql驱动jar包:mysql-connector-java-5.1.0-bin.jar 连接文件放到$CATALINA_HOME/lib/下。
2,安装mysql数据库
3,修改$CATALINA_HOME/conf/ context.xml,<Context></Context>之间加入如下内容
<Resource name="jdbc/mldn" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="root" password="admin" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/music_tap?autoReconnect=true" />
此时要注意修改自己的数据库的用户名和密码
数据库:music_tap
用户名:root
密码:admin
5 修改工程目录下的web.xml文件添加如下
<description>MySQL Test App</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/music_tap</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
6,创建数据源:
package com.amigo.dao;
import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
public class BasicDao {
public static DataSource getDS() throws NamingException{
Context ctx = new InitialContext();
return (DataSource) ctx.lookup("java:comp/env/jdbc/music_tap");
}
}
具体例子一个,结合DBUtils:
package com.amigo.dao;
import java.sql.SQLException;
import javax.naming.NamingException;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
import org.apache.commons.dbutils.handlers.BeanHandler;
import com.amigo.bean.loginBean;
public class LoginBeanDaoImpl extends BasicDao implements LoginBeanDao {
public loginBean GetClientLog()
{
QueryRunner run = null;
try {
run = new QueryRunner(getDS());
} catch (NamingException e) {
e.printStackTrace();
}
ResultSetHandler<loginBean> h = new BeanHandler<loginBean>(loginBean.class);
loginBean p = null;
try {
p = run.query("SELECT * FROM login;",h);
} catch (SQLException e) {
e.printStackTrace();
}
return p;
}
}
Bean:
package com.amigo.bean;
public class loginBean {
int id;
String usr_name;
String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsr_name() {
return usr_name;
}
public void setUsr_name(String usrName) {
usr_name = usrName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
打完收工,呵呵