package dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import dao.BaseDao;
import dao.IStudentInfoDao;
import entity.StudentInfo;
public class StudentInfoDaoImpl extends BaseDao implements IStudentInfoDao {
//添加
public int insert(StudentInfo stu) {
String sql="insert into dbo.StudentInfo values(?,?,?,?,?)";
int i=0;
try {
ps=getCon().prepareStatement(sql);
ps.setString(1,stu.getSname());
ps.setString(2,stu.getSgender());
ps.setInt(3,stu.getSage());
ps.setString(4,stu.getSaddress());
ps.setString(5,stu.getSemail());
i=ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}finally{
this.closeAll(con, ps, rs);
}
return i;
}
//删除
public int delete(StudentInfo stu){
String sql="delete from StudentInfo where sid=?";
int i=0;
try {
ps = getCon().prepareStatement(sql);
ps.setInt(1, stu.getSid());
i=ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
return i;
}
//修改：
public int update(StudentInfo stu) {
String sql="update StudentInfo set sname=?,sgender=?,sage=? where sid=?";
int i=0;
try {
ps=getCon().prepareStatement(sql);
ps.setString(1, stu.getSname());
ps.setString(2, stu.getSgender());
ps.setInt(3, stu.getSage());
ps.setInt(4, stu.getSid());
i=ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
this.closeAll(con, ps, rs);
}
return i;
}
//查询
public StudentInfo delectByid(StudentInfo stu) {
String sql="select * from dbo.StudentInfo where sid=?";
try {
ps=getCon().prepareStatement(sql);
ps.setInt(1,stu.getSid());
rs=ps.executeQuery();
if(rs.next()){
StudentInfo stuinfo = null;
stuinfo.setSid(rs.getInt(1));
stuinfo.setSname(rs.getString(2));
stuinfo.setSgender(rs.getString(3));
stuinfo.setSage(rs.getInt(4));
stuinfo.setSaddress(rs.getString(5));
stuinfo.setSemail(rs.getString(6));
}
} catch (SQLException e) {
e.printStackTrace();
}
return (StudentInfo) rs;
}
//查询：根据ID查单个
public ArrayList<StudentInfo> selectAll() {
ArrayList<StudentInfo> list=new ArrayList<StudentInfo>();
try {
String sql="select * from StudentInfo";
ps=getCon().prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()){
StudentInfo stu=new StudentInfo();
stu.setSid(rs.getInt(1));
stu.setSname(rs.getString(2));
stu.setSgender(rs.getString(3));
stu.setSage(rs.getInt(4));
stu.setSaddress(rs.getString(5));
stu.setSemail(rs.getString(6));
list.add(stu);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
}

package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class BaseDao {
public static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
public static final String URL="jdbc:sqlserver://localhost:1433;databaseName=hs";
public static final String USER="hs";
public static final String PWD="123";
public static Connection con;
public static PreparedStatement ps;
public static ResultSet rs;
//获得连接对象
public static Connection getCon(){
try {
Class.forName(DRIVER);
con=DriverManager.getConnection(URL,USER,PWD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
//关闭方法
public static void closeAll(Connection con,PreparedStatement ps,ResultSet rs){
try {
if(null!=rs){
rs.close();
}if(null!=ps){
ps.close();
}if(null!=con){
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}

package text;
import java.awt.List;
import java.util.Scanner;
import dao.impl.StudentInfoDaoImpl;
import entity.StudentInfo;
public class text {
static StudentInfoDaoImpl studaoimpl=new StudentInfoDaoImpl();
StudentInfo stu=new StudentInfo();
public static void main(String[] args){
new text().upd();
}
//删除
public void del() {
StudentInfoDaoImpl studaoimpl=new StudentInfoDaoImpl();
StudentInfo stu=new StudentInfo();
stu.setSid(14);
int i=studaoimpl.delete(stu);
if(i>0){
System.out.println("删除成功");
}else{
System.out.println("删除失败");
}
}
//添加：
public void ins() {
Scanner input=new Scanner(System.in);
System.out.println("请输入姓名：");
stu.setSname(input.next());
System.out.println("请输入性别：");
stu.setSgender(input.next());
System.out.println("请输入年龄：");
String sage=input.next();
System.out.println("请输入地址：");
stu.setSaddress(input.next());
System.out.println("请输入邮箱：");
stu.setSemail(input.next());
/*
stu.setSname("李四");
stu.setSgender("男");
stu.setSage(32);
stu.setSaddress("北京");
stu.setSemail("de23@.com");
*/
int i=studaoimpl.insert(stu);
if(i>0){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
}
//修改：
public void upd(){
stu.setSid(24);
stu.setSname("好好");
stu.setSgender("女");
stu.setSage(20);
stu.setSaddress("北京");
stu.setSemail("zh@.com");
int i=studaoimpl.update(stu);
if(i>0){
System.out.println("修改成功");
}else{
System.out.println("修改失败");
}
}
//查询：
public void list(){
System.out.println("请输入要查询的学生编号：");
Scanner input=new Scanner(System.in);
int id=input.nextInt();
System.out.println("编号\t姓名\t性别\t年龄\t地址\t邮箱\t");
System.out.println();
}
}

丢这儿~省的到时候删了又要重打∑(っ °Д °;)っ