studentdaoimpl.java

java编码：JavaCode_version01.rar

package com.waytojob.teaching.jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.waytojob.util.ConnectionManager;

public class StudentDaoImpl implements IStudentDao
{

	public StudentDaoImpl()
	{
		super();
	}

	public void createTable(Table table) throws SQLException
	{
		Connection conn = null;
		Statement stmt = null;
		try
		{
			conn = ConnectionManager.getConnection();
			stmt=conn.createStatement();
			String sql="CREATE TABLE " + table.getName() + "("
			+ table.getFields() + ")";
			stmt.executeUpdate(sql);
		}
		catch (SQLException e)
		{
			throw e;
		}
		finally
		{
			if(conn != null)
			{
				conn.close();
			}
		}
	}

	public void addStudent(Student student) throws SQLException
	{
		Connection conn=null;
		Statement stmt=null;
		try
		{
			conn=ConnectionManager.getConnection();
			stmt=conn.createStatement();
			String sql="INSERT INTO students VALUES('" + student.getId() + "','"
			+ student.getName() + "','" + student.getGendar() + "','"
			+ student.getMobile() + "','" + student.getEmail() + "','"
			+ student.getLanguage() + "','"
			+ student.getLevel() + "','" + student.getRemark() + "')";
			stmt.executeUpdate(sql);
		}
		catch(SQLException e)
		{
			throw e;
		}
		finally
		{
			if(conn != null)
			{
				conn.close();
			}
		}
	}

	public List getStudents() throws SQLException
	{
		Connection conn=null;
		Statement stmt=null;
		List students=new ArrayList();
		try
		{
			conn=ConnectionManager.getConnection();
			stmt=conn.createStatement();
			String sql="SELECT * FROM students";
			ResultSet rs=stmt.executeQuery(sql);
			while(rs.next())
			{
				Student student=new Student();
				//学号
				String id=rs.getString(1);
				student.setId((id==null)?"":id.trim());
				//姓名
				String name=rs.getString(2);
				student.setName((name==null)?"":name.trim());
				//性别
				String gendar=rs.getString(3);
				student.setGendar((gendar==null)?"":gendar.trim());
				//手机
				String mobile=rs.getString(4);
				student.setMobile((mobile==null)?"":mobile.trim());
				//电子邮件
				String email=rs.getString(5);
				student.setEmail((email==null)?"":email.trim());
				//编程语言
				String language=rs.getString(6);
				student.setLanguage((language==null)?"":language.trim());
				//级别
				String level=rs.getString(7);
				student.setLevel((level==null)?"":level.trim());
				//说明
				String remark=rs.getString(8);
				student.setRemark((remark==null)?"":remark.trim());
				
				students.add(student);
			}
		}
		catch(SQLException e)
		{
			throw e;
		}
		finally
		{
			if(conn != null)
			{
				conn.close();
			}
		}
		return students;
	}

}