简单的数据库操作 增 删改 查 Java编程
来源:互联网 发布:java cronexpression 编辑:程序博客网 时间:2024/05/20 01:47
public class TeacherManage
{
// 添加语句
public static final String INSERTTEACHER = "insert into teacher(name,password) values(?,?)";
{
// 添加语句
public static final String INSERTTEACHER = "insert into teacher(name,password) values(?,?)";
// 删除语句
public static final String DELETEATEACHER = "delete from teacher where teaId = ?";
public static final String DELETEATEACHER = "delete from teacher where teaId = ?";
// 修改语句
public static final String UPDATETEACHER = "update teacher set name = ?,password = ? where teaid = ?";
public static final String UPDATETEACHER = "update teacher set name = ?,password = ? where teaid = ?";
// 查询语句
public static final String SELECTTEACHER = "select * from teacher";
public static final String SELECTTEACHER = "select * from teacher";
// 添加一条记录
public static boolean insertTeacher(String name, String password)
{
boolean flag = false;
Connection conn = DBManage.getConnection();
PreparedStatement pstmt = null;
int count = 0;
try
{
pstmt = conn.prepareStatement(INSERTTEACHER);
pstmt.setString(1, name);
pstmt.setString(2, password);
count = pstmt.executeUpdate(); // 记录操作执行的记录条数
if (count != 0)
{
flag = true;
}
conn.commit();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
if (null != conn)
{
try
{
conn.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
if (null != pstmt)
{
try
{
pstmt.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}
return flag;
}
// 删除一条信息
public static boolean deleteATEacher(int id)
{
boolean flag = false;
Connection conn = DBManage.getConnection();
PreparedStatement pstmt = null;
int count = 0;
try
{
pstmt = conn.prepareStatement(DELETEATEACHER);
pstmt.setInt(1, id);
count = pstmt.executeUpdate();
if (count != 0)
{
flag = true;
}
conn.commit();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
if (null != conn)
{
try
{
conn.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
if (null != pstmt)
{
try
{
pstmt.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}
return flag;
}
{
pstmt = conn.prepareStatement(DELETEATEACHER);
pstmt.setInt(1, id);
count = pstmt.executeUpdate();
if (count != 0)
{
flag = true;
}
conn.commit();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
if (null != conn)
{
try
{
conn.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
if (null != pstmt)
{
try
{
pstmt.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}
return flag;
}
// 修改一条记录
public static boolean updateTeacher(int id, String name,
String password)
{
boolean flag = false;
Connection conn = DBManage.getConnection();
PreparedStatement pstmt = null;
int count = 0;
try
{
pstmt = conn.prepareStatement(UPDATETEACHER);
pstmt.setInt(1, id);
pstmt.setString(2, password);
pstmt.setString(3, name);
count = pstmt.executeUpdate();
if (count != 0)
{
flag = true;
}
conn.commit();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
if (null != conn)
{
try
{
conn.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
if (null != pstmt)
{
try
{
pstmt.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}
return flag;
}
// 查询信息
public static void seleteTeacher()
{
Connection conn = DBManage.getConnection();
Statement stmt = null;
ResultSet rs = null;
try
{
stmt = conn.createStatement();
rs = stmt.executeQuery(SELECTTEACHER);
while (rs.next())
{
System.out.print(rs.getInt("teaId") + " ");
System.out.print(rs.getString("name") + " ");
System.out.println(rs.getString("password"));
}
conn.commit();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
if (null != conn)
{
try
{
conn.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}
}
// 测试
public static void main(String[] args)
{
boolean flag = TeacherManage.insertTeacher("cc", "456");
boolean flag = TeacherManage.deleteATEacher(42);
boolean flag = TeacherManage.updateTeacher("haha", "147");
System.out.println(flag);
TeacherManage.seleteTeacher();
}
}
public static void main(String[] args)
{
boolean flag = TeacherManage.insertTeacher("cc", "456");
boolean flag = TeacherManage.deleteATEacher(42);
boolean flag = TeacherManage.updateTeacher("haha", "147");
System.out.println(flag);
TeacherManage.seleteTeacher();
}
}
- 简单的数据库操作 增 删改 查 Java编程
- ssm框架下对数据库表的增查删改
- ssm框架下对数据库表的增查删改
- SQLite数据库的添删改查
- MSSQL 数据库的正删改查语句
- thinkphp对数据库的删改查
- 简单模板链表。增查删改
- 数据库---简单的使用Java操作数据库增删改查
- discuz学习笔记:以easyUI DataGrid为前台进行数据库增查删改操作
- mysql增查删改
- (ASP.NET)Gridview使用EF绑定数据库支持多个网页的增查删改
- 纯JS实现表单的増删改查操作
- mongoDB的基本操作(正删改查)(整理)
- datagirdview和listview,删改查sqlserver数据库的小结
- 嵌入式关系型数据库SQLite的添删改查
- [JAVA]集合框架之自己实现一个具有基本增查删改功能的ArrayList
- 简单的数据库操作 增 删 改 查
- 简单的数据库操作 增 删 改 查
- 今天受打击了。
- 写在之前
- Win32 SDK 实现UDP聊天室程序(二)
- 疯狂的程序员(anki8088)
- 一个简单的MySQL数据库脚本
- 简单的数据库操作 增 删改 查 Java编程
- 2492解题报告
- 用 Zend Studio 消灭 PHP 应用程序中的 bug
- SOA标准发展混乱 国内业务缺少经验
- 升级PHP后不能启动MySQL被遗忘的原因
- IE无法打开二级链接
- 搞怪測試 (Monkey Test)
- 13个效果超酷的Javascript网页导航菜单
- windows及Linux系统下获取IP及MAC地址的方法