?? usersqldao.java
字號(hào):
/*
* Created on Oct 3, 2005
*
* TODO To change the template for this generated file go to
* Window - Preferences - Java - Code Style - Code Templates
*/
package com.softeem.jdbc.dao.af.sqlserver;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.util.List;
import com.softeem.jdbc.dao.af.*;
import com.softeem.jdbc.dao.af.dto.*;
/**
* @author gelly
*
* TODO To change the template for this generated type comment go to Window -
* Preferences - Java - Code Style - Code Templates
*/
public class UserSQLDAO implements UserDAO{
private Connection conn;
private final String SQL_SELECT_USER = "SELCET * FROM JDBC_USER WHERE USERID=?";
private final String SQL_UPDATE_USER = "UPDATE JDBC_USER SET USERNAME=?, ADDRESS=?, WHERE USERID=?";
private final String SQL_ADD_USER = "INSERT INTO JDBC_USER VALUES(?,?,?)";
public UserSQLDAO(Connection conn){
this.conn = conn ;
}
/**
*
* @param user
* @return
*/
public boolean add(UserDTO user) {
boolean flag = true ;
try {
PreparedStatement pstmt = conn.prepareStatement(SQL_SELECT_USER);
pstmt.setString(0, user.getId());
pstmt.setString(1, user.getUserName());
pstmt.setString(2, user.getPassword());
flag = pstmt.execute();
pstmt.close();
conn.close();
} catch (SQLException e) {
flag = false ;
}
return flag;
}
/**
*
* @param userId
* @return
*/
public UserDTO find(String userId) {
UserDTO user = null;
try {
PreparedStatement pstmt = conn.prepareStatement(SQL_SELECT_USER);
ResultSet rset = pstmt.executeQuery();
if (rset.next()) {
user = new UserDTO();
user.setId(rset.getString(0));
user.setUserName(rset.getString(1));
user.setPassword(rset.getString(2));
}
rset.close();
pstmt.close();
conn.close();
} catch (SQLException e) {
//;
}
return user;
}
public boolean edit(UserDTO user){
return false;
}
public boolean delete(String id){
return false;
}
public List findAll(){
return null;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -