一阶段-EighteenthWork-2-数据库操作

/*
二．在SQL Server 2005中附加students数据库在students数据库里已经建立studentInfo表，表结构如下
字段名类型及长度备注
stuNoChar(4)主键，学生学号
stuNameVarchar(30)学生姓名
stuSexChar(2)学生性别
stuAgeint学生年龄
表中有如下三条记录
stuNostuNamestuSexstuAge
0001张三男18
0002李四女17
0003王五男18

1、请用JDBC-ODBC桥驱动的方式，连接students数据库，
在程序中执行插入操作，插入下面的数据
stuNostuNamestuSexstuAge
0004麻六男20
在程序中执行修改操作，将学号为0003的年龄改为21
在程序中执行删除操作，将学号为0002的学生记录删除
在程序中执行查询操作，显示所有学生信息
*/

package EighteenthWork.secondTitle;

public class RunMain
{
    public static void main(String[] args)
    {
        OdbcConnDAO dao = new OdbcConnDAO();
        dao.select();
//        dao.upDate();
    }
}


================================================
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package EighteenthWork.secondTitle;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;

public class OdbcConnDAO
{
    private static String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
    private static String URL = "jdbc:odbc:sql";
    public void upDate()
    {
        try {
            Class.forName(DRIVER);//加载驱动
            Connection conn = DriverManager.getConnection(URL);//获得连接
            Statement sm = conn.createStatement();//创建操作工具
            String sql = "insert into studentInfo (stuNo,stuName,stuSex,stuAge)values('0004','麻六','男','20')";//执行操作语句
            int i = sm.executeUpdate(sql);
            System.out.println(i+"行受影响");
            sm.close();
        } catch (Exception ex) {
            System.out.println(ex.toString());
        }
    }
    public void delete()
    {
        try {
            Class.forName(DRIVER);
            Connection conn = DriverManager.getConnection(URL);
            Statement sm = conn.createStatement();
            String sql = "delete from studentInfo where stuNo='0004'";
            int i = sm.executeUpdate(sql);
            System.out.println(i+"行受影响");
            sm.close();
        } catch (Exception ex) {
            System.out.println(ex.toString());
        }
    }

    public void select()
    {
        ResultSet rs = null;
        Statement sm = null;
        StudentsVO vo = null ;
        Connection conn = null;
        try {
            Class.forName(DRIVER);
            conn = DriverManager.getConnection(URL);
            sm = conn.createStatement();
            String sql = "select user ";
//            String sql = "select * from studentInfo order by stuAge ";
//            rs = sm.executeQuery(sql);
//            System.out.println("学号\t姓名\t性别\t年龄");
//            while(rs.next())
//            {
//                System.out.print(rs.getString(1)+"\t");     //双引号内的值必须与表的字段值一致
//                System.out.print(rs.getString(2)+"\t");
//                System.out.print(rs.getString(3)+"\t");
//                System.out.println(rs.getInt(4));
//            }
        }
       catch (Exception ex) {
            System.out.println(ex.toString());
        }
        try {
            rs.close();
            sm.close();
            conn.close();
        } catch (SQLException ex) {
            Logger.getLogger(OdbcConnDAO.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
}
====================================
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package EighteenthWork.secondTitle;

import java.sql.Connection;


public interface FactorySQL extends Connection
{
    public static String Driver ="sun.jdbc.odbc.JdbcOdbcDriver";
    public static String URL="jdbc:odbc:sql";
}
====================================
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package EighteenthWork.secondTitle;

public class StudentsVO
{
    private String stuNo;
    private String stuName;
    private String stuSex;
    private int stuAge;

    public StudentsVO(String stuNo, String stuName, String stuSex, int stuAge) {
        this.stuNo = stuNo;
        this.stuName = stuName;
        this.stuSex = stuSex;
        this.stuAge = stuAge;
    }   

    public int getStuAge() {
        return stuAge;
    }

    public void setStuAge(int stuAge) {
        this.stuAge = stuAge;
    }

    public String getStuName() {
        return stuName;
    }

    public void setStuName(String stuName) {
        this.stuName = stuName;
    }

    public String getStuNo() {
        return stuNo;
    }

    public void setStuNo(String stuNo) {
        this.stuNo = stuNo;
    }

    public String getStuSex() {
        return stuSex;
    }

    public void setStuSex(String stuSex) {
        this.stuSex = stuSex;
    }
}