dbservice.java~1~

来自「车辆管理系统」· JAVA~1~ 代码 · 共 53 行

package DB;
import java.sql.*;
import DB.*;

public class DbService {
    Connection con = new Db().getCon();
    public String addItem(String USERID,String USERPSW) throws Exception{
        String str= "失败";
        Statement stmt=con.createStatement();
        String sql= "insert into ITEM values ('" + USERID +"','" + USERPSW +"')";
        System.out.println(sql);
        int i= stmt.executeUpdate(sql);
        if(i>0){
            str="成功";
        }
          stmt.close();
          return  str;

    }

    public String findUser(String userName,String password){
        String message = "";
        String sql = "select * from ITEM where USERID='" +
                    userName + "' and USERPSW='" + password + "'";


        try {
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            if (rs.next()) {
                message = "登录成功";
            } else {
                message = "登录失败";
            }
            rs.close();
            stmt.close();
            con.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }

        return message;

    }
    public void add(){
        try {
            Statement stmt = con.createStatement();
            int count = stmt.executeUpdate("insert ");
        } catch (SQLException ex) {
        }
    }
}