Description: package dao
import java.sql.Connection
import java.sql.PreparedStatement
import java.sql.ResultSet
import java.sql.Statement
import java.util.ArrayList
import java.util.List
import util.DBUtil
import entity.Picture
import entity.User
public class UserDAOJdbcImp implements UserDAO {
public void save(User user) throws Exception {
Connection con=DBUtil.open()
String sql="insert into w_user(username,name,password,age,sex,tel) values (?,?,?,?,?,?)"
PreparedStatement psmt=con.prepareStatement(sql)
psmt.setString(1, user.getUsername())
psmt.setString(2, user.getName())
psmt.setString(3, user.getPassword())
psmt.setInt(4, user.getAge())
psmt.setString(5, user.getSex())
psmt.setString(6, user.getTel())
psmt.executeUpdate()
DBUtil.close(con, psmt, null)
}
public List<User> findAll() throws Exception {
Connection con = null
Statement st = null
ResultSet rs =
To Search:
File list (Check if you may need any files):
makefriends\.project
...........\.mymetadata
...........\.classpath
...........\.settings\org.eclipse.core.resources.prefs
...........\.........\org.eclipse.jdt.ui.prefs
...........\.........\com.genuitec.jboss.ide.eclipse.xdoclet.run.prefs
...........\.........\com.genuitec.eclipse.j2eedt.core.prefs
...........\WebRoot\index.jsp
...........\.......\addEmp.html
...........\.......\detail.jsp
...........\.......\emplist.html
...........\.......\emplist.jsp
...........\.......\friend.jsp
...........\.......\login.jsp
...........\.......\regist.jsp
...........\.......\updateEmp.html
...........\.......\img\bullet_green.gif
...........\.......\...\footer_bg.gif
...........\.......\...\nane.gif
...........\.......\...\Thumbs.db
...........\.......\...\bg.gif
...........\.......\...\top_left.gif
...........\.......\...\tableheader-bg.gif
...........\.......\...\tableheader-bg-grey.gif
...........\.......\...\content_bg.gif
...........\.......\...\button.gif
...........\.......\...\bullet_grey.gif
...........\.......\...\footer.gif
...........\.......\css\style1.css
...........\.......\...\style.css
...........\.......\META-INF\MANIFEST.MF
...........\.......\WEB-INF\web.xml
...........\.......\.......\classes\db.properties
...........\.......\.......\.......\dao.properties
...........\.......\.......\.......\SQL Editor (0).sql
...........\.......\.......\.......\dao\UserDAOJdbcImp.class
...........\.......\.......\.......\...\UserDAO.class
...........\.......\.......\.......\entity\User.class
...........\.......\.......\.......\......\Picture.class
...........\.......\.......\.......\util\LoginFilter.class
...........\.......\.......\.......\....\DBUtil.class
...........\.......\.......\.......\....\DAOFactory.class
...........\.......\.......\.......\....\CommentFilter.class
...........\.......\.......\.......\web\UserServlet.class
...........\.......\.......\.......\...\CheckCodeServlet.class
...........\src\dao.properties
...........\...\db.properties
...........\...\SQL Editor (0).sql
...........\...\web\UserServlet.java
...........\...\...\CheckCodeServlet.java
...........\...\util\DAOFactory.java
...........\...\....\DBUtil.java
...........\...\....\LoginFilter.java
...........\...\....\CommentFilter.java
...........\...\entity\User.java
...........\...\......\Picture.java
...........\...\dao\UserDAO.java
...........\...\...\UserDAOJdbcImp.java
...........\WebRoot\WEB-INF\classes\dao
...........\.......\.......\.......\entity
...........\.......\.......\.......\test
...........\.......\.......\.......\util
...........\.......\.......\.......\web
...........\.......\.......\classes
...........\.......\.......\lib
...........\.......\upload
...........\.......\path
...........\.......\img
...........\.......\css
...........\.......\META-INF
...........\.......\WEB-INF
...........\src\web
...........\...\util
...........\...\test
...........\...\entity
...........\...\dao
...........\.settings
...........\.myeclipse
...........\WebRoot
...........\src
makefriends