JAVA中显示找不到符号是指_求解!!运行javac老是提示找不到符号,求教 UserDAO 的正确写法...

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

UserDAO 我是先写了一个接口

package com.cn.pioneer.servers;

public interface UserDAO {

// 登录方法

public User login(String username,String password);

}

以下是我的实现方法

package com.cn.pioneer.servers;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import org.apache.http.impl.cookie.DateUtils;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class UserDAOImpl implements UserDAO {

private final String DRIVER = "com.mysql.jdbc.Driver";

/**

* 子类可以修改url、username以及pwd的值

*/

private String url ="jdbc:mysql://localhost:3306/musicdream";

private String username = "root";

private String password = "123456";

public User login (String account, String password) {

String querySql = " select id,username,password "+

" from usertable "+

" where username=? and password=? ";

Connection connection=null;

DBUtil util = new DBUtil();

Connection conn = util.openConnection();

try {

//装载数据库驱动

Class.forName(DRIVER);

//建立数据库连接

connection = DriverManager.getConnection(url,username,password);

PreparedStatement state = conn.prepareStatement(querySql);

state.setString(1, username);

state.setString(2, password);

ResultSet result = state.executeQuery();

if (result.next()) {

int id = result.getInt(1);

String name = result.getString(4);

User user = new User();

user.setId(id);

user.setName(username);

user.setPassword(password);

return user;

}

}catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return null;

}

public void setUrl(String url) {

this.url = url;

}

public void setUsername(String username) {

this.username = username;

}

public void setPwd(String password) {

this.password = password;

}

};

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值