java sqlserver工具类_Java 连接 SqlServer工具类

1.下载 server2008R2驱动jar包

2.代码实现

1)实体：

package entity;

import java.io.Serializable;

import java.util.Date;

public class User implements Serializable{

private int id;

private String username;

private String password;

private Date createtime;

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getUsername() {

return username;

}

public void setUsername(String username) {

this.username = username;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

public Date getCreatetime() {

return createtime;

}

public void setCreatetime(Date createtime) {

this.createtime = createtime;

}

public User(int id, String username, String password, Date createtime) {

super();

this.id = id;

this.username = username;

this.password = password;

this.createtime = createtime;

}

public User(String username, String password, Date createtime) {

super();

this.username = username;

this.password = password;

this.createtime = createtime;

}

public User() {

super();

}

@Override

public String toString() {

return "User [id=" + id + ", username=" + username + ", password="

+ password + ", createtime=" + createtime + "]";

}

}

2.dao

package dao;

import java.util.List;

import entity.User;

public interface UserDao {

public void add(User u);

public User getByUsername(String username);

public void update(User u);

public void delete(String username);

public List findAll();

}

3.ImplDao

package daoImpl;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

import jdbcutil.JdbcUtil;

import dao.UserDao;

import entity.User;

public class UserD