package com.javakc.jee3.login.util;
import java.sql.Connection;
import java.sql.DriverManager;
/**
* 获取数据库工厂类
*/
public class ConnectionUtil {
//声明数据库连接 四要素
private final static String DRIVER = "oracle.jdbc.driver.OracleDriver";
private final static String URL = "jdbc:oracle:thin:@localhost:1521/orclpdb";
private final static String NAME = "javakc";
private final static String PASS = "javakc77";
/**
* 获取数据库连接
* @return 连接
*/
public static Connection getConnection()
{
Connection connection = null;
try {
Class.forName(DRIVER);
connection = DriverManager.getConnection(URL,NAME,PASS);
} catch (Exception e) {
e.printStackTrace();
}
return connection;
}
}
package com.javakc.jee3.login.dao;
import com.javakc.jee3.login.util.ConnectionUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 登录数据库层方法
*/
public class LoginDao {
/**
* 登录方法
*
* @param username
* @param password
* @return 登录状态
*/
public static int login(String username, String password)
{
String sql = "select count(1) from servlet_user where name =? and pass =?";
Connection connection = ConnectionUtil.getConnection();//获得数据连接
PreparedStatement ps = null;
ResultSet rs = null;
int result = 0;
try {
ps = connection.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
rs = ps.executeQuery();
while (rs.next()) {
result = rs.getInt(1);
}
} catch (SQLException e