JDBC编程

[ctmuziniao]

基于JDBC，编写UserDaoImpl.java, 实现UserDao接口。请直接使用DBUtil.getConnection( )获取数据库连接Connection；使用DBUtil.release(Connection, Statement,ResultSet)释放资源；数据库表名为t_user；
JDBC常用编程接口：DriverManager;Connection;Statement;PreparedStatement;
CallableStatement;ResultSet;

public class User{
private int id; //自动增长
private String name;
private String password;
//省略getter and setter…
}
public interface StudentDao{
public void insert(User user) throws Exception;
public List<User> listAll( ) throws Exception;
}

[qq_39936465]

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class StudentDaoImpl implements StudentDao {

	@Override
	public void insert(User user) throws Exception {
		// TODO Auto-generated method stub
		Connection conn=new DBUtil.getConnection();
		String sql="insert into t_user values(?,?,?)";
		PreparedStatement pstmt=conn.prepareStatement(sql);
		User u=user;
		pstmt.setInt(1,u.getId());
		pstmt.setString(2, u.getName());
		pstmt.setString(3, u.getPassword());
		pstmt.executeUpdate();
		DBUtil.release(conn,null,null);	
	}

	@Override
	public List<User> listAll() throws Exception {
		// TODO Auto-generated method stub
		Connection conn=new DBUtil.getConnection();
		String sql="select * from t_user ";
		Statement stmt=conn.createStatement();
		ResultSet rs=stmt.executeQuery(sql);
		List<User> list=new ArrayList<User>();
		while(rs.next()) {
			int id=rs.getInt(1);
			String name=rs.getString(2);
			String password=rs.getString(3);
			User u=new User();
			u.setId(id);
			u.setName(name);
			u.setPassword(password);
			list.add(u);
		}
		DBUtil.release(conn,stmt,rs);	
		return list;
	}

}

[ctmuziniao]

引用 1 楼 qq_39936465 的回复:

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class StudentDaoImpl implements StudentDao {

	@Override
	public void insert(User user) throws Exception {
		// TODO Auto-generated method stub
		Connection conn=new DBUtil.getConnection();
		String sql="insert into t_user values(?,?,?)";
		PreparedStatement pstmt=conn.prepareStatement(sql);
		User u=user;
		pstmt.setInt(1,u.getId());
		pstmt.setString(2, u.getName());
		pstmt.setString(3, u.getPassword());
		pstmt.executeUpdate();
		DBUtil.release(conn,null,null);	
	}

	@Override
	public List<User> listAll() throws Exception {
		// TODO Auto-generated method stub
		Connection conn=new DBUtil.getConnection();
		String sql="select * from t_user ";
		Statement stmt=conn.createStatement();
		ResultSet rs=stmt.executeQuery(sql);
		List<User> list=new ArrayList<User>();
		while(rs.next()) {
			int id=rs.getInt(1);
			String name=rs.getString(2);
			String password=rs.getString(3);
			User u=new User();
			u.setId(id);
			u.setName(name);
			u.setPassword(password);
			list.add(u);
		}
		DBUtil.release(conn,stmt,rs);	
		return list;
	}

}

谢谢您