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

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

1、请用JDBC-ODBC桥驱动的方式，连接students数据库，
在程序中执行插入操作，插入下面的数据
stuNo stuName stuSex stuAge
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;
}
}