sqlServer连接dao

package com.softeem.testconnect;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class StudentDao {

	private Connection conn = null;

	private PreparedStatement ps = null;

	private ResultSet rs = null;

	private String url = "jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=123456;DatabaseName=mytest";

	private String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";//驱动

	private String sql_findAll = "select * from studentInfo";//查询所有信息

	private String sql_insert = "insert into studentInfo values(?,?,?,?)";//添加信息

	private String sql_findById = "select * from studentInfo where id=?";//根据唯一标识来查询

	private String sql_del = "delete studentInfo where id=?";//根据唯一标识来删除

	private void del(int id) {
		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url);
			ps = conn.prepareStatement(sql_del);
			ps.setInt(1, id);
			ps.executeUpdate();

			ps.close();
			conn.close();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void findById(int id) {
		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url);
			ps = conn.prepareStatement(sql_findById);
			ps.setInt(1, id);
			rs = ps.executeQuery();
			while (rs.next()) {
				System.out.println(rs.getInt(1));
				System.out.println(rs.getString(2));
			}
			rs.close();
			ps.close();
			conn.close();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void insert(StudentDto dto) {
		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url);
			ps = conn.prepareStatement(sql_insert);
			ps.setString(1, dto.getStudentNo());
			ps.setString(2, dto.getName());
			ps.setString(3, dto.getAge());
			ps.setString(4, dto.getAddress());

			ps.executeUpdate();

			ps.close();
			conn.close();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		// Date date = Date.valueOf("2007-02-02");
		// System.out.println(date);
		StudentDto dto = new StudentDto();
		dto.setAddress("暗暗");
		dto.setAge("24");
		dto.setName("test");
		dto.setStudentNo("2003005");
		StudentDao dao = new StudentDao();
		// dao.insert(dto);
		// dao.findById(4);
		 dao.del(5);
	}
}

StudentDto类：

package com.softeem.testconnect;

public class StudentDto {

	private int id;

	private String studentNo;

	private String name;

	private String age;

	private String address;

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public String getAge() {
		return age;
	}

	public void setAge(String age) {
		this.age = age;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getStudentNo() {
		return studentNo;
	}

	public void setStudentNo(String studentNo) {
		this.studentNo = studentNo;
	}

}