Question

如何使用Eclipse对SQL数据库进行增删查改查?我是新手哈..举个简单的列子

Answer 1

给一个很简单的例子你看一下：用Java两层实现的。
1.数据库脚本
use master
go

--创建数据库
if exists (select * from sysdatabases where name = 'StudentManage')
drop database StudentManage
go
create database StudentManage
go

--使用数据库
use StudentManage
go

--创建表
--创建学生信息表
if exists (select * from sysobjects where name = 'StuInfo')
drop table StuInfo
go
create table StuInfo
(
stuId int identity(1,1) primary key, --学生编号
stuName varchar(20), --学生姓名
stuSex char(2), --学生性别
stuSeat int, --学生座位
)
go
--插入测试数据
insert into StuInfo values('曾哥','男',1)
insert into StuInfo values('春哥','男',2)
insert into StuInfo values('凤姐','女',3)
insert into StuInfo values('潇洒哥','男',4)
go

select * from stuInfo

①：获取数据库的连接类
package com.svse.util;

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

/**
* 1.获得数据库连接对象 2.关闭连接资源对象
*
* @author Administrator
*
*/
public class DBHelper {

// 4个连接字符串driver，url，username，password
private final static String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

private final static String URL = "jdbc:sqlserver://localhost:1433;databasename=StudentManage";

private final static String USERNAME = "sa";

private final static String PASSWORD = "sa";

/**
* 获得数据库连接对象
*
* @return
*/
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName(DRIVER);
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}

/**
* 关闭资源
*
* @param rs
* @param st
* @param conn
*/
public static void closeResource(ResultSet rs, Statement st, Connection conn) {
try {
if (rs != null) {
rs.close();
}
if (st != null) {
st.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
//用于测试数据库的连接
public static void main(String[] args) {
Connection conn = DBHelper.getConnection();
if (conn != null) {
System.out.println("OK");
} else {
System.out.println("ERROR");
}
}

}

②：学生实体类
package com.svse.entity;

/**
* 实体类： 1.实体类对应数据库中的一张表 2.实体类的属性对应数据库中表的字段 3.一个实体类对象对应数据库中表的一条记录
*
* @author Administrator
*
*
*/
public class StuInfo {

private int stuId;

private String stuName;

private String stuSex;

private int stuSeat;

public StuInfo() {

}

public StuInfo(int stuId, String stuName, String stuSex, int stuSeat) {
this.stuId = stuId;
this.stuName = stuName;
this.stuSex = stuSex;
this.stuSeat = stuSeat;
}

public int getStuId() {
return stuId;
}

public void setStuId(int stuId) {
this.stuId = stuId;
}

public String getStuName() {
return stuName;
}

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

public int getStuSeat() {
return stuSeat;
}

public void setStuSeat(int stuSeat) {
this.stuSeat = stuSeat;
}

public String getStuSex() {
return stuSex;
}

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

③：数据访问层：对数据库的增删改查
package com.svse.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.svse.entity.StuInfo;
import com.svse.util.DBHelper;

/**
* 1.查询所有 2.根据ID查询 3.添加 4.删除 5.修改
*
* @author Administrator
*
*/
public class StuInfoDAO {

private Connection conn;// 数据库连接对象

private PreparedStatement ps;// 执行SQL语句对象

private ResultSet rs;// 结果集对象

/**
* 1.查询所有学生信息
*
* @return
*/
public List<StuInfo> getAllStuInfo() {
conn = DBHelper.getConnection();
String sql = "select * from stuInfo";
List<StuInfo> list = new ArrayList<StuInfo>();
try {
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
int stuID = rs.getInt("stuId");
String stuName = rs.getString("stuName");
String stuSex = rs.getString("stuSex");
int stuSeat = rs.getInt("stuSeat");

// 创建实体类对象
StuInfo s = new StuInfo();
s.setStuId(stuID);
s.setStuName(stuName);
s.setStuSex(stuSex);
s.setStuSeat(stuSeat);

// 将实体类对象添加到集合类中
list.add(s);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBHelper.closeResource(rs, ps, conn);
}
return list;
}

/**
* 2.根据学好查询学生信息
*
* @param stuId
* @return
*/
public StuInfo getStuInfoByStuId(int stuId) {
StuInfo s = null;
conn = DBHelper.getConnection();
String sql = "select * from stuInfo where stuId = ?";
try {
ps = conn.prepareStatement(sql);
ps.setInt(1, stuId);
rs = ps.executeQuery();
while (rs.next()) {
int stuID = rs.getInt("stuId");
String stuName = rs.getString("stuName");
String stuSex = rs.getString("stuSex");
int stuSeat = rs.getInt("stuSeat");

s = new StuInfo();
s.setStuId(stuID);
s.setStuName(stuName);
s.setStuSex(stuSex);
s.setStuSeat(stuSeat);

}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBHelper.closeResource(rs, ps, conn);
}
return s;
}

/**
* 3.添加学生信息
*
* @param s
* @return
*/
public int addStuInfo(StuInfo s) {
int count = 0;
conn = DBHelper.getConnection();
String sql = "insert into stuInfo values(?,?,?)";
try {
ps = conn.prepareStatement(sql);
ps.setString(1, s.getStuName());
ps.setString(2, s.getStuSex());
ps.setInt(3, s.getStuSeat());
count = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBHelper.closeResource(rs, ps, conn);
}
return count;
}

/**
* 4.根据学好删除学生信息
*
* @param stuID
* @return
*/
public int delStuInfo(int stuID) {
int count = 0;
conn = DBHelper.getConnection();
String sql = "delete from stuInfo where stuId = ?";
try {
ps = conn.prepareStatement(sql);
ps.setInt(1, stuID);
count = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBHelper.closeResource(rs, ps, conn);
}
return count;
}

/**
* 5.根据学号修改学生信息
*
* @param s
* @return
*/
public int updateStuInfo(StuInfo s) {
int count = 0;
conn = DBHelper.getConnection();
String sql = "update StuInfo set stuName = ?,stuSex = ?,stuSeat = ? where stuId = ?";
try {
ps = conn.prepareStatement(sql);
ps.setString(1, s.getStuName());
ps.setString(2, s.getStuSex());
ps.setInt(3, s.getStuSeat());
ps.setInt(4, s.getStuId());
count = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBHelper.closeResource(rs, ps, conn);
}
return count;
}

}

Answer 2

不知道你想说的是JDBC还是ECLIPSE工具
如果是讲工具的话，ECLIPSE并不适合SQL管理了，SQL数据库本身有个企业管理器。
如果非要用的话：请选择：window---->show view--->other--->DB Browser
关于使用你按这个上网查询一下，很多的

Answer 3

首先要用java的jdbc驱动包与数据库进行连接，你应该学的就是java吧？然后再引入java.sql.*这个包，知道了这些，其中具体的步骤你就可以在网上查出来了。希望你帮到你！

Answer 4

给你几行代码，你自己看吧：
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;databaseName=Student";
String user = "sa";
String password = "sa";
//用来连接数据库
try {
Class.forName(driverName);
Connection connection = DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}