一、用到的包
c3p0-0.9.1.1.jar
commons-dbutils-1.7.jar
mysql-connector-java-5.1.17.jar
servlet-api.jar
注:包一定要放到 WebContent/WEB-INF/lib 在放入libray里面才会真正在服务器中生效
二、创建实体
一般放在domain包下
如我的:AppleX
package domain;
public class AppleX {
private int id;
private String name;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Override
public String toString() {
return "id="+id+"\nname="+name;
}
}
三、使用c3p0连接数据库
在src下创建一个名为 c3p0-config.xml 的文档添加如下代码
<c3p0-config>
<default-config>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/test?</property>
<property name="username">root</property>
<property name="password"></property>
</default-config>
</c3p0-config>
四、创建servlet
一、配置servlet
在web.xml里加入如下代码:
<servlet>
<servlet-name>Login</servlet-name>
<servlet-class>servlets.Login</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Login</servlet-name>
<url-pattern>/servletLogin</url-pattern>
</servlet-mapping>
二、编写servlet代码:
在dopost/doget里加入代码:
response.setContentType("text/html;charset=UTF-8"); //解决中文乱码
//获取页面用户输入数据
String id = request.getParameter("id");
String name = request.getParameter("name");
//查找数据库
ComboPooledDataSource dataSource = new ComboPooledDataSource();//连接数据库
QueryRunner runner = new QueryRunner(dataSource);//获得Dubtils查询对象
String sql = "select * from apple where id=? and name=?";
AppleX apple10 = null;
try {
apple10 = runner.query(sql, new BeanHandler<AppleX>(AppleX.class),id,name);//查询数据
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(apple10!=null){
response.getWriter().write("登陆成功!!!!!");
}
else{
response.getWriter().write("登陆失败!!!!!");
}