dbservice.java~41~

车辆管理系统

package DB;
import java.sql.*;
public class DbService {
    Connection con = new Db().getCon();
   public String addActor(String userid,String userpsw) throws Exception{
      String str= "失败";
      Statement stmt=con.createStatement();
        String sql= "insert into Actor values ('" + userid +"','" + userpsw +"')";
        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 Actor 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) {
        }
    }}