两张数据库表,对部门进行简单的增删改查,直接加代码以后看时间修改
package com.test.system;
import java.sql.*;
import java.util.Scanner;
public class TestMain {
public static void main(String[] args) {
Scanner request = new Scanner(System.in);
int flag = 0;
//添加sql命令
String sql_1 = "insert into dept(deptno,dname,loc)value(?,?,?)";
String sql_2 = "select * from dept";
String sql_3 = "delete from dept where deptno = ? ";
String sql_4 = "update dept set dname=?,loc=? where deptno = ? ";
String sql_5 = "select count(*) from emp where ename = ? and empno= ?;";
String dname,loc,ename,password;
int deptno;
Connection conn =null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bjpowernode","root","123456");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
//用户登录
System.out.println("******请输入用户名******");
ename = request.next();
System.out.println("******请输入密码******");
password = request.next();
try {
ps = conn.prepareStatement(sql_5);
ps.setString(1,ename);
ps.setInt(2,Integer.valueOf(password));
rs = ps.executeQuery();
while(rs.next()){
flag = rs.getInt("count(*)");