javaee连接mysql_JavaEE连接数据库练习

登录端

Insert title here卡号：
密码：>

连接请求端

Insert title here

String password=request.getParameter("password1");if(cardid==null||password==null||cardid.equals("") || password.equals(""))

{

out.write("请正确登录系统");

}else{//检查登录信息

cardDAO cd=newcardDAO();if(cd.checklogin(cardid, password))

{

out.write("登录成功");

}else{

out.write("登录失败");

}

}%>

Java代码类

package com.web;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class cardDAO {

ComboPooledDataSource cpd=new ComboPooledDataSource("helloc3p0");

public boolean checklogin(String cardid,String password)

{

boolean boo=false;

try {

Connection conn=cpd.getConnection();

PreparedStatement ps=conn.prepareStatement(

"select * from bank where ba_card=? and ba_password=?");

ps.setString(1, cardid);

ps.setString(2, password);

ResultSet rs=ps.executeQuery();

boo=rs.next();

rs.close();

ps.close();

conn.close();

cpd.close();

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

return boo;

}

}