JAVA员工信息管理系统

【#第一文档网# 导语】以下是®第一文档网的小编为您整理的《JAVA员工信息管理系统》，欢迎阅读！

package JDBCPIMS.Java; import java.sql.*;

public class JDBCPIMS{

public static void main(String[] args)throws Exception {

String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String connectionStr="jdbc:odbc:PIMS"; Connection con = null; Statement stmt=null; ResultSet rs=null;

Class.forName(DBDriver);

con=DriverManager.getConnection(connectionStr,"Test","1234"); stmt=con.createStatement();

rs=stmt.executeQuery("Select * From Person"); while(rs.next()) {

System.out.print(rs.getInt("ID")+" ");

System.out.println(rs.getString("Name")+" "); }

stmt.executeUpdate("INSERT INTO Person VALUES(9,'冯壬',3,'accountant',2000,4)"); System.out.println("添加数据后的信息为："); rs=stmt.executeQuery("Select * From Person"); while(rs.next()) {

System.out.print(rs.getInt("ID")+" ");

System.out.println(rs.getString("Name")+" "); }

stmt.executeUpdate("DELETE FROM Person WHERE Name ='冯壬' ");

System.out.println("删除数据后的信息为："); rs=stmt.executeQuery("Select * From Person"); while(rs.next()) {

System.out.print(rs.getInt("ID")+" ");

System.out.println(rs.getString("Name")+" "); }

stmt.close(); con.close(); } }

本文来源：https://www.dy1993.cn/xY0K.html